Answers / PDF Forms
how can I merge data from an excel spreadsheet into a pdf fill in form in Adobe Pro?
Jennifer McCloud 703 days ago
The most straightforward way would be exporting the Excel data as tab-delimited file, and then import that as a Data Object, interpret it and fill the according values into your form.
Hope this can help.
Do you mean a "mail merge"-type operation (creating a new PDF for each row in the spreadsheet), or just importing a single set of values from Excel into a PDF?
Visit my custom-made PDF scripts website: http://try67.blogspot.com
Contact me personally: firstname.lastname@example.org
I have a spreadsheet with client names,address, SSN, etc that I want to import into an existing Adobe fill-in form to create a new form for each.
Jennifer McCloud Commented 703 days ago | Report
OK. There's a built-in option in the PDF Maker plugin in Excel and Word that can do that, but it's Windows only and only in some versions, I believe.
In addition, I have developed a script that can do it without relying on this plugin and can process any type of plain-text CSV or text file and offers more advanced naming options. See here:
Gilad D (try67) Commented 703 days ago | Report
There is a great suggestion in this discussion titled Can I import data from an Excel spreadsheet to a fillable PDF Form?
It explains how you can import data from Excel into a PDF form, which requires that you set a few things up in Excel.
Follow me on All things Acrobat and more blog
Thanks for sharing the link. I mostly use PDFfiller to create fillable pdfs. Its not the same thing, but maybe someone needs it. It also allows you to erase in a pdf and esign. Its pretty easy to use and its pretty cheap. I think you can get a free week if you and a friend both register.
anne go Commented 169 days ago | Report
Get started withAcrobat DC
Start free trial
Everything you need to get started using the all-new Acrobat DC.
Learn more >
Last 30 Days