Participant

Question

fill a PDF file with data coming from XLSX or CSV

Forum|Forum|1 year ago
January 10, 2025
3 replies
2759 views

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

PDF

Participant

I had the exact same headache a while back—trying to bulk-fill PDF forms from CSV. Spent way too much time on it for invoices and stuff.

In the end, I built this Chrome extension myself called PDF Mail Merge — it just works. Drag in your CSV and a fillable PDF template, it auto-maps fields, generates one PDF per row, and zips them all up instantly. All offline in your browser, no servers. Super quick for hundreds of docs.

Try it here: Chrome Web Store link. Saved me tons of time, hope it helps someone

1aerllik

Participant

THANK YOU !!! saved me

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 Ahmad

Community Manager

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