Import multiple rows from Excel Sheet to a single Form

Forum|Forum|5 years ago
August 27, 2020
2 replies
692 views

I want to create a form that resembles a directory (e.g. multiple people per page) and populate the fields from an existing spreadsheet. The fields are the standard fields (Last Name, First Name, etc). My spreadsheet currently has 40 people listed but will grow over time. How do I import multiple rows from a spreadsheet into the form? I have successully imported one person but that information populates each of the three seperate entities on the page. I am using Adobe Pro DC and excel.

PDF forms

This topic has been closed for replies.

CPAlexander17583891

Participating Frequently

Without exporting your data from Excel, you might be able to use Word's Mailings tab features to import the existing data. Then you could print the Word document to an Adobe pdf as required. (A disclaimer here, I've not used Word's Mailings functions, but it seems intuitive.)

try67

Community Expert

This can be achieved using a custom-made script, assuming the names of the fields in the PDF follow a pattern, such as "Name1", "Name2", "Name3", etc. You would need to save the Excel file as a plain-text file, then read it with the script, parse its contents and use a loop to apply the values from it to the fields in your file. Not a trivial task...

If you're interested I could develop this script for you, for a fee. You can contact me privately via [try6767 at gmail.com] to discuss it further.

S

Shawna0101Author

Participant

I was afraid it was far more complicated than I imagined. I do appreciate the offer, but I think I will have to figure out a different method. Thank you for your response. It did get me that much further along.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded