Answers / Forms
how can I merge data from an excel spreadsheet into a pdf fill in form in Adobe Pro?
Jennifer McCloud 674 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 674 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 674 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 141 days ago | Report
Acrobat XI trial
Get the trial now
how can I update my signature on a revised document?
Asked by Jon Rose · 1 answer
how disable zoom when double click
Asked by Kia Bazargan · 1 answer
can't get cloud tool to work
Asked by Bruce Greenwald · 1 answer
I can create a pdf file from a new Cannon MF216 on my screen using Adobe XI but cannot sav...
Asked by Charles Philbrick · no replies
Interactive PDF form in Acrobat Pro and Reader XI can be filled but text does not save or ...
Asked by JIL GORDON · 2 answers
Sticky Notes are now appearing huge. How do I fix this?
Asked by David Christel · 2 answers
Last 30 Days
The Acrobat User Community is where you can connect with Acrobat and Adobe Document Services peers and experts. If you use Acrobat, Reader or EchoSign, you'll want to take advantage of the many free community resources like tutorials, tips, and Q&A to learn more about Acrobat and document services.