fill a PDF file with data coming from XLSX or CSV

Forum|Forum|1 year ago
January 10, 2025
2 replies
3159 views

I'm trying to fill a PDF file with data coming from XLSX or CSV, can someone help?

PDF

try67

Community Expert

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.

A

Adam31864800p8ku

Participant

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.

try67

Community Expert

Are you sure it's a regular PDF file? Can you edit the fields in it, for example?

T

Tariq Dar

Legend

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.

From the Prepare a form panel, Select Options ... > Import data.
In the Select File Containing Form Data dialog box, select athe format ofthe data file you want to import. Then, locate and select that file, and select Open.

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

M

Muhammad31058043k8z6

Participant

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?

try67

Community Expert

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

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