automatedpdf.tools

Guides · How-to

How to batch fill PDF forms from Excel without Adobe

Push spreadsheet rows into a fillable PDF template without Acrobat mail merge. Map Excel/CSV columns to fields and download one PDF per row—what r/excel users want when they say “batch fill PDFs using Excel.”

Open Fill PDF from Excel or CSV ↗

What people are asking

r/excel (“batch fill PDFs using Excel”, “Excel data to populate PDF form”), Facebook “how to mail merge PDF documents”, estimators filling bid forms from sheets.

The pain is retyping the same W-9 / 1099 / intake fields a hundred times. Spreadsheet → ZIP fixes that.

What Fill PDF from Excel or CSV actually does

  • Read Excel (.xlsx/.xls/.ods) and CSV.
  • Map columns to fillable PDF fields; sheet picker for multi-sheet workbooks.
  • Emit one completed PDF per row in a ZIP.

What it does not do

  • Extract tables from a PDF into Excel (that is the opposite direction).
  • Fill scanned PDFs that have no real form fields—you need a fillable template.

Steps

  1. Start with a fillable PDF template (AcroForm fields).
  2. Open Fill PDF from Excel or CSV.
  3. Upload template + spreadsheet; map columns to fields.
  4. Generate and download the ZIP of filled PDFs.
  5. Optional: flatten so recipients cannot edit field values.

Related guides

Fill out a PDF from Excel · Mail merge PDF forms · Flatten so fields are not editable

Go deeper

Scenario guides hub · Open Fill PDF from Excel or CSV · All PDF tools · Privacy

Last updated 2026-08-20 · Research-backed long-tail