Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

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 at 9:35

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 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.