Fill multiple PDF forms from Excel or CSV

Fill Multiple PDF Forms from Excel — PDF Mail Merge

Fill the same PDF for every customer, vendor, employee, or case. Each Excel or CSV row becomes one reviewed PDF, ready to download in a ZIP.

Try five spreadsheet rows free with a watermark and free AI column matching. Clean ZIP exports are included in Starter ($19/month for up to 25 rows), Pro ($49/month for 100 rows), and Business ($99/month for 500 rows).

Want to inspect the files first? Download a PDF template, five Excel rows, and the resulting PDF mail merge ZIP.

Your data lives in Google Sheets? Fill the PDF directly from Sheets with the JustFill add-on.

22-second walkthrough

One PDF. Five spreadsheet rows. One ZIP.

A real production workflow with a synthetic vendor form and a five-row Excel workbook: match all nine fields, review every PDF, and export one ZIP.

  1. 1Review nine PDF fields once
  2. 2Match 9/9 Excel headers
  3. 3Approve five and export ZIP

PDF mail merge, without Word

How to fill multiple PDF forms from Excel

Keep the original PDF layout. Put column names in the first spreadsheet row and one customer, employee, vendor, or case in each row below it. JustFill creates a separate PDF for every selected row.

  1. 1

    Upload the original PDF

    Use an AcroForm, a flat PDF, or a scan. JustFill detects the fields before the merge.

  2. 2

    Import XLSX or CSV

    Dates, leading zeros, percentages, booleans, and spreadsheet headers are preserved for mapping.

  3. 3

    Check the column mapping

    Matching headers map directly. Ambiguous columns can use AI-assisted mapping.

  4. 4

    Review and export

    Approve the records you want and download individual filled PDFs in one ZIP.

Sample input

Create one filled PDF per Excel row

NameBusiness nameTax class
Alex MorganNorthwindLLC
Jordan LeeContosoS Corp
Taylor KimFabrikamIndividual
Live PDF Field Preview (Row 1 of 3)

Name

Alex Morgan

Business name

Northwind

Tax class

LLC

Click any spreadsheet row above to preview its generated PDF. All 3/3 columns auto-matched by AI.

Upload or send the source files

Upload the PDF you need to repeat. Fillable forms, flat PDFs, and scans are supported.

Map columns to PDF fields

Import CSV or XLSX. JustFill matches spreadsheet headers and row values to the detected PDF fields.

Review before export

Your team checks generated drafts before download, so the workflow saves time without skipping human review.

Where it fits

Mail Merge from Excel to Fillable PDF (No Word or Acrobat Plug-ins)

Most tutorials on how to do a mail merge in Excel only explain how to merge spreadsheet rows into a Microsoft Word letter. When B2B ops teams, bookkeepers, HR managers, and paralegals need to mail merge from Excel directly into an official fillable or flat PDF form, converting the PDF to Word destroys checkboxes, comb boxes, multi-column tables, and signature blocks. JustFill maps your .xlsx or .csv columns directly onto native AcroForm fields or calibrated flat PDF coordinates and exports a ZIP of individual PDFs.

Customer application forms
Vendor setup forms
Employee onboarding PDFs
Order and quote forms
Account update forms
Inspection or intake packets

Your next spreadsheet

Reuse a PDF form with Excel or CSV

Once you have checked a form’s fields, keep that layout for the next spreadsheet. Reopen your saved work from My Sessions, import the new rows and prepare a separate PDF for each selected record. You can repeat the workflow without rebuilding the form.

Keep the original blank PDF as your master so every new batch starts from the same form. Use one record per row and keep the same column headers to reuse your saved mapping, then check renamed or missing columns before generating PDFs. Store identifiers with leading zeros as text in Excel, and test a few rows first: new values may be longer or use different date formats.

Choose the output for your task. If a recipient needs to type into a blank PDF, use interactive AcroForm export to create clickable fields. For a list of records you already have in Excel, the batch workflow creates completed PDF copies. Exporting an interactive form is optional; you can fill your original flat PDF or scan directly in JustFill.

Start with your blank PDF

Simple pricing

Test five sample rows free—then unlock clean ZIP exports from $19/month.

Run the five-row sample first with free automatic AI column matching. Starter ($19/mo), Pro ($49/mo), and Business ($99/mo) unlock reusable monthly batch workflows for up to 25, 100, or 500 records.

Running larger spreadsheet batches? Get Pro — $49/month for up to 100 rows per batch (or Business at $99/month for up to 500 rows).

Starter

Recommended first workflow

$19
/ month
  • AI field detection for 250 new pages per month
  • Reusable templates — refills use no detection pages
  • Up to 25 PDFs per batch
  • 125 clean output pages per month
  • Clean, watermark-free ZIP exports
  • CSV and XLSX imports
  • Review every record before export
Starter: 25 records for $19/month. Pro: 100 for $49/month. Business: 500 for $99/month. Each plan also enforces its monthly clean-output allowance.

Paid workflow

For the next batch, reopen your saved work.

Keep the PDF and column mapping in your saved session. When the next spreadsheet is ready, reopen it from My Sessions and import the new rows. Monthly plans provide recurring clean-output and AI allowances for ongoing work.

Reopen the saved PDF

Open the same session from My Sessions to restore the PDF, field positions, and saved column mapping.

Import the next spreadsheet

Use the same column headers to reuse your mapping. Check any changed or missing columns before generating the new records.

Review and download the new batch

Review the new records, approve the ones you need, and download their PDFs in a ZIP within your monthly plan allowance.

Guardrails

Draft preparation with human review.

Clear boundaries

JustFill prepares PDF drafts from data your team provides. It does not validate business decisions, legal meaning, tax treatment, compliance status, or whether a form should be submitted.

Frequently asked questions

Mail Merge from Excel to Fillable PDF (No Word or Acrobat Plug-ins)

To mail merge from Excel to a fillable, flat, or scanned PDF without Microsoft Word or paid Adobe Acrobat plug-ins, upload your original PDF form to JustFill, import your .xlsx or .csv workbook, verify the automatic header-to-field mapping, preview each populated record in the browser, and export a single ZIP containing one completed PDF per Excel row.

How to Do a Mail Merge in Excel for Official PDF Forms

Prepare an Excel (.xlsx) or CSV spreadsheet with field labels in Row 1 and one client, employee, vendor, or entity in each row below. Upload your official PDF template (such as IRS Form W-9, Form 1095-C, Form SS-4, Form 2848, Form 843, or USCIS Form I-9), match your Excel columns to the PDF fields once, review every generated draft on screen, and download the batch as a ZIP archive.

Mail Merge Excel vs. Classic Word Mail Merge

Classic Word mail merge pulls Excel rows into a .docx flow layout—which works for letters and mailing labels, but breaks official government, tax, insurance, and banking PDFs by scrambling checkboxes, multi-column tables, comb boxes, and signature blocks. JustFill performs a direct Excel-to-PDF mail merge by keeping the original PDF geometry locked and writing each Excel row directly onto native AcroForm fields or calibrated flat PDF coordinates.

How to populate a PDF form from Excel data

Upload your existing PDF form once, import your Excel (.xlsx) or CSV spreadsheet, match the column headers to the detected PDF fields, preview each generated record in the browser, and export all approved copies together in one ZIP.

Can I batch fill a non-fillable or scanned PDF from Excel?

Yes. You do not need pre-existing interactive AcroForm fields. JustFill detects text boxes, checkboxes, dates, and comb fields on flat or scanned PDFs first, then maps your Excel or CSV columns to those detected positions.

Create one filled PDF per Excel row

Put your field names in the first spreadsheet row and one customer, vendor, employee, or vehicle record in each row below it. JustFill auto-populates one separate PDF per Excel row and packages the approved files into a single clean ZIP download.

Can I reuse a PDF template with new Excel or CSV rows?

Yes. Reopen your saved PDF and column mapping from My Sessions, import the new XLSX or CSV, and review the generated records. Keeping the same headers lets you reuse the mapping; check any changed columns and longer values. Keep the original blank PDF as your master and download approved copies in a ZIP within your monthly plan allowance.

Does an interactive PDF export also create a PDF for every spreadsheet row?

Interactive AcroForm export creates a PDF with clickable fields for a recipient. To create a separate completed copy for every spreadsheet row, use the batch workflow: import Excel or CSV, review the records and download their PDFs in a ZIP. You can use a flat PDF or scan directly, without first exporting an interactive form.

How do I mail merge a PDF from Excel?

Upload the PDF form once, import the Excel or CSV file, map each column to a detected PDF field, review the generated records, and download one completed PDF per selected row in a ZIP. The original PDF layout stays untouched.

Can I mail merge PDF documents without Adobe Acrobat?

Yes. Acrobat has no native spreadsheet mail merge, so a browser-based workflow is usually simpler than an Acrobat plug-in or script. Nothing needs to be installed and the form does not have to be rebuilt in Word.

Can a PDF form be filled from Excel data automatically?

Yes. Spreadsheet headers that match field names are mapped automatically, and ambiguous columns can be corrected by hand before generation. Automatic mapping never skips the review step: every generated record stays visible before export.

Can I mail merge a PDF from Google Sheets?

Yes. Install the JustFill add-on for Google Sheets and Drive, connect your JustFill account, choose a saved PDF form, and fill one PDF per row into a Drive folder. Set up the form once in JustFill and reuse it for the next batch. You can also download the sheet as Excel or CSV and use the browser workflow without connecting your Google account.

Can I create a fillable PDF from Excel?

JustFill fills an existing PDF rather than converting a spreadsheet into a new fillable form. If the goal is one completed copy of a form per spreadsheet row — for customers, vendors, or employees — that is exactly what the batch workflow produces.

Does it work with scanned or flat PDFs?

Yes. JustFill detects field locations in fillable, flat, and scanned PDFs before mapping spreadsheet columns.

Does each spreadsheet row create a separate PDF?

Yes. The first row contains the Excel or CSV column names. Every selected data row becomes one reviewable PDF in the exported ZIP.

Is this the same as Word mail merge?

It uses the same one-row-per-document idea, but fills your existing PDF directly. You do not need to recreate the form in Word or convert the PDF first.

Can I review results before downloading?

Yes. Each spreadsheet row becomes a reviewable record. Approve the records you want before creating the ZIP.

Does JustFill email the generated PDFs?

Not in the current self-service batch. It creates individual PDFs and packages the approved files in a ZIP for download.

What happens to uploaded documents?

Transfers use TLS. Rendered page images are deleted within 7 days and source documents within 30 days unless you save the PDF as a reusable template.

Direct Excel-to-PDF Architecture

Mail Merge Excel vs. Classic Word Mail Merge

When you search for how to do a mail merge in Excel, standard guides route you into Microsoft Word. That works for paragraphs of text, but fails when you must preserve an exact government, bank, insurance, or client PDF template.

Why Classic Excel → Word Mail Merge Breaks Official PDFs

  • Destroys PDF checkboxes & comb boxes: Converting an IRS, USCIS, or state DMV PDF into Word scrambles tax-classification checkboxes, 17-character VIN combs, and SSN/EIN boxes.
  • Breaks multi-column tables & pagination: Dense 12-month coverage grids (like Form 1095-C Part II) and signature blocks shift across page boundaries and get rejected by agencies or portals.
  • Outputs a single merged document: Word merges rows into one giant document instead of exporting individual, row-named PDFs in a clean ZIP archive.

How to Do a Mail Merge in Excel for Official PDF Forms

  • Native AcroForm & flat PDF coordinates: JustFill keeps your exact source PDF untouched and maps .xlsx or .csv columns directly onto native AcroForm fields or AI-detected flat/scanned coordinates.
  • Automatic boolean & checkbox normalization: Spreadsheet values like Yes, True, 1, or X cleanly tick the target PDF checkbox without shifting surrounding borders.
  • Row-by-row visual preview & ZIP export: Inspect every populated record in your browser, edit exceptions inline, and download one separate PDF per spreadsheet row in a single ZIP.
Popular Official PDFs for Excel Mail Merge

Mail Merge from Excel to Fillable PDF (No Word or Acrobat Plug-ins)

Start with a verified blank form below or upload your own internal packet. You can test five spreadsheet rows free in the browser before upgrading for watermark-free batch ZIP exports.