Copy link to clipboard
Copied
I'm trying to fill a PDF file with data coming from XLSX or CSV, can someone help?
Copy link to clipboard
Copied
Hi @rania_3094,
Import form Data
Sometimes, individuals submit filled-in forms as data-only files rather than complete PDF files. These files aren't PDFs but use another format, such as FDF or XML. You can see the data submitted by an individual recipient in the context of the PDF by opening the original file and importing the information from the data file.
In Acrobat, open the PDF form you want to import data into.
Select All Tools from the global bar in the upper left, and then select Prepare a Form.
For more information on Managing Form Data, please read this: https://adobe.ly/4fXZbl7
Let us know more details, and will try to assist.
~Tariq
Copy link to clipboard
Copied
Hi,
I did that but Import only brings the row that I hightlight at the time of import. I want to create ideally a different file for each row or at least import all rows with a new form for each row. How do I do that?
Copy link to clipboard
Copied
That is called a Mail Merge. It can be done using a script, such as this (paid-for) tool I've developed:
https://www.try67.com/tool/acrobat-mail-merge-and-email-pdf-files
Copy link to clipboard
Copied
Not directly. You must first save them as a tab-delimited text file, and then you'll be able to use the Import Form Data command of Acrobat on it, assuming the field names and column headers match.
Copy link to clipboard
Copied
I am confused by your response because I have a tab limited Excel sheet which contains data which I would like to be entered into my form fields but when I try to import that data into the form on Adobe, it does not give me the option of importing a tab limited text file, but it is instead asking me to use an FDF or XML file.
Copy link to clipboard
Copied
Are you sure it's a regular PDF file? Can you edit the fields in it, for example?
Find more inspiration, events, and resources on the new Adobe Community
Explore Now