How to Fill PDF Forms from Excel Data

Connect a spreadsheet to a PDF’s form fields and generate one filled PDF per row — in batches, downloaded as a single ZIP.

If your team fills the same PDF over and over — order forms, tax forms, applications, service agreements — and that data already sits in a spreadsheet, you are typing everything twice. ExForms lets you fill PDF forms from Excel: connect a spreadsheet table to a PDF’s form fields, then generate one finished PDF per row. A hundred rows become a hundred filled PDFs, delivered as a single ZIP. The person receiving the forms needs nothing installed.

The short version

To fill PDF forms from Excel, upload a fillable PDF, map each form field to an Excel column once, then generate. The mapping is saved with your template set, so next month you drop in fresh data and run it again. No re-setup, no manual entry.

What you can do

  • Use real fillable PDFs. Standard AcroForm PDFs and the more complex XFA forms are both supported.
  • Turn flat PDFs and scans into forms. A picture of a form (PDF, PNG, JPG, TIFF) becomes fillable with the visual field placement designer.
  • Auto-map in one click. ExForms can read the PDF’s field names and build an Excel sheet with those names as column headers, so you just fill the columns.
  • Generate in batches. Every data row produces its own filled PDF.
  • Name files dynamically. Build each output file name from field values, like the person’s name and date.
  • Download everything as one ZIP.

How to fill PDF forms from Excel: step by step

1. Create a template set

Open the ExForms add-in from the Data tab in Excel. In the tree view, right-click a folder and choose Add New Set. Give it a clear name (for example, “Client W-9s”) and an optional description.

2. Upload your PDF

Add your fillable PDF to the set. ExForms reads its form fields automatically.

3. Map fields to Excel columns

Match each PDF field to the spreadsheet column that feeds it. In a hurry? Use Auto-mapping to generate an Excel sheet pre-labelled with the PDF’s field names, then fill in the values.

4. Generate and download

Run the set. ExForms fills one PDF per row and hands you a single ZIP with all of them inside.

No form fields? You can still fill PDF forms from Excel

Plenty of “PDFs” are really just flat scans with no interactive fields. Instead of rebuilding them, you place fields visually — click where each value belongs, once — and fill from Excel after that. See how to add fillable fields to any PDF for the walkthrough.

Where people fill PDF forms from Excel

Common questions

No. You generate finished, standard PDF files. Whoever receives them just opens a normal PDF.
AcroForm is the classic fillable-PDF standard; XFA is a newer, form-heavy format used by some government and enterprise documents. ExForms handles both.
Use the visual field placement designer to drop fields onto the flat page, then fill from Excel. You can get the result back as a PDF or an image.
As many rows as you have. Generation draws on your plan’s document allowance, and form add-on packs can extend it for large or seasonal batches without changing your subscription.

Fill PDF forms from Excel today

Point ExForms at a PDF you already use, map it to a sheet you already have, and watch the batch come back filled. Full details live in the PDF Forms guide.

About the Author: Catalin

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.