How to Batch Fill 100+ PDF Forms from an Excel or CSV File (Without Acrobat Mail Merge Plugins)

Description and use

Teams can generate 100+ populated PDFs in a single pass by converting flat PDFs to fillable, cleaning spreadsheets, mapping columns, previewing, and exporting a ZIP archive.

Problem

Teams need to generate one populated PDF per row from an Excel or CSV file, but built‑in mail merge tools either do not support PDFs or require manual per‑row import, and many PDF templates are flat and non‑fillable.

Outcome

Teams can now generate 100+ populated PDFs in a single pass, eliminating manual per‑row processing and third‑party plugins.

Workflow

• Verify PDF template is fillable or flat
• If flat, convert to fillable using Convert PDF to Fillable Form or Word to Fillable PDF converter
• Prepare spreadsheet: format leading zeros as text, remove title rows, use Yes/No for checkboxes, add unique filename column
• Upload fillable PDF template to Fill PDF from Excel workflow
• Upload .xlsx or .csv file
• Verify column‑to‑field mappings and preview rows
• Export batch ZIP containing one PDF per row

Evidence

Adobe Acrobat Pro has no native multi-row Excel mail merge.

Source

If your template has no interactive fields, you only need to add them once before running your 100-row batch.

Source

Most batch PDF errors come from silent spreadsheet formatting quirks rather than the PDF itself.

Source