Try Acrobat DC
These forums are now Read Only. If you have an Acrobat question, ask questions and get help from the community.


how to import excel data in fillable pdf

I have a large excel document. I want to import the data into a PDF form....like a Mailmerge.

I know how to import one row at a time.

But, is there a way to take a one page fill able form, import the excel data and create a page for each one of rows?


Kris Johnson


1 Answer

At least a couple of options if you want to do the job through Acrobat

  1. export .xls to .csv or .txt (comma or tab separated values); then write your own Acrobat JavaScript to load those data into the PDF form (you can find someone who did it for you http://try67.blogspot.it/2013/02/reader-importexport-form-data.html);
  2. use OLE automation provided by the Interapplication Communication API (http://www.adobe.com/devnet/acrobat/interapplication_communication.html): so, you can write a small program in VBA or VBS to read data from Excel and write them into the PDF form;


Ricardo Falegnami   

Please specify a reason: