Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel file which contains many rows of data, each row has columns like last name, first name, gender etc. I would like to batch fill these data into a form which is in PDF format, each row should then generate a new PDF file.

The problem is that the pdf file is not of the fillable type. It's not intended to be filled out on computer, there is no textbox that allows you to enter text. It's originally supposed to be printed out and filled out by pen.

Is there a way to accomplish this?

share|improve this question
None that I know. Most likely this would need custom programming. – Brad Patton Apr 10 '13 at 17:46
This is a product recommendation request which is off topic here. That means there is a chance it could be closed. In order to improve your question, and avoid closure, you can edit your question to something like, "How can I do this?" or "Is there a way to accomplish this?", which would not be off topic. – CharlieRB Apr 10 '13 at 17:51
@CharlieRB Thanks. I have updated my question. – bobo Apr 10 '13 at 20:54
You won't be able to do this with a batch file. – Prof Pickle Apr 11 '13 at 4:59
up vote 1 down vote accepted
  1. Create (or extract) a high-resolution image from the PDF form.
  2. Create a Word document using this image as a background image.
  3. Add mail merge text fields in the appropriate places on top of the PDF.
  4. Perform the mail merge with the source Excel document.
  5. Divide into separate documents if necessary.
  6. Save As PDF from Word.

If you need them, each of these steps should have instructions somewhere on this site or elsewhere on the Internet.

share|improve this answer
Yes, this is the correct way to do this. For each mail merge label, playing with its paragraph before/after spacing will allow us to position it on the document more accurately. – bobo May 5 '14 at 9:35

You will need to add form fields to your PDF using Adobe Acrobat or another PDF editor which supports adding form fields. Once you have a PDF with form fields to use as your template there are a number of products that do mail merge with a PDF template and data from a CSV file.

If you have Adobe Acrobat then the company I work for sells a product called Debenu PDF Aerialist which includes a mail merge feature which will do exactly what you're looking for.

share|improve this answer

if i were you, I would use word's mail merge functionality to fill the information from the Excel file,it will generate a long word document, if you are using word 2007 or later,save it as a pdf file and find a pdf split software to split the pdf file.use the excel file to save as a txt file and edit to a batch file to rename all the pdf files.

and 1. word 2013 can convert existing pdf file to word file. 2. use pdf split software to save file names like "1.pdf,2.pdf,3.pdf" so you can create a batch file using the excel file.

share|improve this answer

You must log in to answer this question.

protected by bwDraco May 6 at 18:48

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .