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
- Bulk W-9s for a whole vendor list — the official IRS Form W-9 is a classic fillable PDF.
- Work orders generated from a jobs sheet.
- Ready-made templates you copy and fill without building anything.
- Applications, waivers, purchase orders, enrolment forms — anything repetitive.
Common questions
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.




