How to import data from excel to multiple pdf files?

[Maria21938442tgmv]

I have a scenario here and google for an hour, seems could not find an answer.  So hopefully some experts would be able to help me here:

My scenario is:

1.) 5 columns of data in an excel file

2) 100 individual pdf forms wtih different names

How can I import the 5 columns of data into individual pdf forms?  

Many thanks.  

[try67]

This type of operation is called a Mail Merge. It can be achieved using a script. You will need to have a template PDF form with field names that match the names of the columns from the Excel file. You then need to save the Excel file a plain-text file (CSV or tab-delimited) and use the script to read the data from this file and populate it into the PDF form, saving it under a new name in each iteration.

I've actually developed a (paid-for) tool that does exactly that (plus a lot more, like the ability to automatically email the merged files to the recipients, or to flatten them, or to merge them as a single file, etc.). If you're interested, you can find it here: https://www.try67.com/tool/acrobat-mail-merge-and-email-pdf-files

[Maria21938442tgmv]

Hi Try67,

Thank you for your answer.   

So your script is able to put the data to each "already created pdf" file that already existed?  

From my undestanding to your explanation, do you mean:

(1) Extract data under a CSV file

(2) Create a pdf template with the fields in the 5 columns of csv file data

(3) Use the script to pull the data from teh CSV file to the fill the template and then create a new set of 100 pdf forms, right? 

So would step 3 then be able to merged this csv file data to all my exisiting 100 pdf files with other information in it already?  

Thank you. 

[try67]

No, not quite. The tool generates new files, it doesn't write the data into existing ones. Is that your scenario?

If so, it could be possible, but will require a custom-made solution. You can contact me privately via [try6767 at gmail.com] to discuss it further.