Step-by-step workflow
How to mail merge from Excel to a PDF form without Acrobat in 4 steps
Whether your target document is an interactive AcroForm or a flat government, insurance, or accounting PDF, the browser workflow takes under two minutes.
- 1
Format your Excel (.xlsx) or CSV sheet
Put clear column headers in Row 1 (such as Legal Name, EIN, Address, Policy Number, or Amount) and place one client, vendor, employee, or claim record on each row below.
- 2
Upload your fillable or flat PDF form
Drop your existing PDF into JustFill. Interactive AcroForm fields are read immediately, while flat or scanned PDFs have their text boxes, tables, and checkboxes detected by AI.
- 3
Map Excel columns to PDF fields
Confirm the automatic header-to-field mapping. Use deterministic header matching or 1-click AI semantic matching to pair every spreadsheet column with its target PDF box.
- 4
Preview every row and download the ZIP
Click through individual rows on the live PDF preview to verify alignment, fix any cell inline in the browser grid, and download one populated PDF per row in a clean ZIP.
Method comparison
Mail merge Excel to fillable PDF: Browser Workflow vs. Acrobat & Word
Most teams searching for how to mail merge from Excel to a PDF form hit a wall because Microsoft Word cannot populate an existing PDF layout and Adobe Acrobat has no built-in multi-row spreadsheet merge command.
| Workflow | Preserves PDF layout | Separate PDF per Excel row | Platform requirements | Cost & trade-offs |
|---|---|---|---|---|
| JustFill (Browser Excel → PDF) | Yes — fillable, flat & scanned PDFs | Yes — 1 PDF per row in a ZIP | Mac, Windows, Linux, Chrome/Edge (No install) | Free 5-row preview; $7 7-Day Pass or $19/mo Starter |
| Adobe Acrobat Pro (Built-in) | Only AcroForms (1 file at a time) | No native multi-row spreadsheet merge | Desktop install | ~$239/year per seat |
| Acrobat + AutoMailMerge Plug-in | Only pre-built AcroForms | Yes | Windows only (requires full Acrobat Pro) | Acrobat license + $149+ plug-in |
| Microsoft Word Mail Merge → PDF | No — must rebuild layout in Word | Requires macro/split add-in for separate files | Desktop Office | Breaks official government & insurance PDF grids |
Built for B2B operations
Mail merge Excel to fillable PDF or flat forms with zero template lock-in
Download a ready-to-fill CSV/Excel template directly from any uploaded PDF for 100% deterministic header matching, or drop in your existing ERP, AMS, DMS, or HRIS spreadsheet and let AI semantic matching pair your columns automatically.
- Works with interactive AcroForms, flat PDFs, and scanned documents
- Supports both Microsoft Excel (.xlsx) and CSV spreadsheets
- Combines comb character boxes (VINs, SSNs, EINs, NPIs) into single fields
- Inline browser grid editor to fix individual rows before ZIP export
- Save calibrated templates to run recurring monthly batches in 60 seconds
High-volume PDF forms teams mail merge from Excel
Tax, CPA & Vendor Packets (W-9, 2848, 1095-C)
Pre-fill vendor W-9 requests, IRS Form 2848 Powers of Attorney, and ACA 1095-C employee statements directly from accounting exports.
See Bulk W-9 CSV GeneratorACORD 125, 126, 140 & COI Insurance Schedules
Map agency schedule of locations Excel sheets and AMS exports onto ACORD 125, 126, 140, and ACORD 25 Certificate of Insurance PDFs.
See ACORD 125/126/140 Batch FillCMS-1500 & UB-04 Medical Claim Automation
Batch-populate Boxes 1–33 on CMS-1500 (HCFA) and Form Locators 1–81 on UB-04 institutional claim PDFs from billing CSV exports.
See CMS-1500 & UB-04 AutomationFrequently asked questions
How to mail merge from Excel to a PDF form without Acrobat?
Upload your existing fillable, flat, or scanned PDF form to JustFill, import your Excel (.xlsx) or CSV spreadsheet where the first row contains column headers, verify the automatic column-to-field mapping, preview each populated record on the PDF canvas, and export a ZIP archive containing one completed PDF per spreadsheet row — with no Adobe Acrobat Pro license or Windows plug-in required.
How does mail merge Excel to fillable PDF work when the PDF is flat or scanned?
Standard mail merge scripts only work if the PDF already has named AcroForm fields. JustFill uses D-FINE visual AI field detection to find blank lines, table cells, and checkboxes on flat or scanned PDFs, so you can mail merge Excel to fillable PDF templates or non-fillable government, insurance, and medical forms alike.
Can I keep interactive AcroForm fields or flatten the merged PDFs?
Both. By default, batch export produces clean, print-ready PDFs in a single ZIP so recipients cannot accidentally alter pre-filled figures. On monthly plans, you can also export interactive AcroForm PDFs or send Shareable Fillable Links when a client or vendor needs to complete remaining fields and e-sign.
Why not use Microsoft Word mail merge to PDF?
Word mail merge works well for letters you author inside Word, but converting an official PDF form (like an IRS W-9, Form 1095-C, ACORD 125/126/140, or CMS-1500 claim) into Word destroys exact box coordinates, comb fields, checkboxes, and multi-column tables. Direct Excel-to-PDF mail merge keeps the original PDF untouched.
What if my Excel column headers do not exactly match the PDF field names?
JustFill matches exact and synonymous headers automatically, and includes AI semantic column matching so a column named "Company / LLC" maps cleanly to "Business Name (if different from above)". You can also download a pre-formatted CSV template with the exact field names from any uploaded PDF.
How many Excel rows can I mail merge into PDFs at once?
You can test 5 sample rows for free in the browser. For clean watermark-free ZIP exports, the $7 7-Day Pass supports a one-off batch up to 25 rows, while Starter ($19/month), Pro ($49/month), and Business ($99/month) support 25, 100, and 500 rows per batch.
Run your first Excel-to-PDF mail merge in 60 seconds
Test five rows free in your browser with no credit card required, or open the full batch workflow with your own PDF and Excel file.