How to Fill PDF Forms from Excel

Complete Guide: Filling PDF Forms from Excel

If you have a PDF with form fields and an Excel spreadsheet with data, Mergram can fill in every form automatically — no manual entry needed. This guide walks you through the entire process, from preparing your files to generating completed documents at scale.

Prerequisites

Before you begin, make sure you have:

• A PDF with form fields (AcroForm-compatible) — created in Adobe Acrobat, LibreOffice, or any standard PDF editor
• An Excel (.xlsx/.xls) or CSV (.csv) file with your data organized in columns and rows
• A free Mergram account (no credit card required)

Understanding PDF Form Fields

PDF form fields (also called AcroForm fields) are interactive areas in a PDF that accept user input. Common types include:

Each field has a name (its identifier) and a value (the data that fills it). Mergram reads these field names and matches them to your spreadsheet columns.

Preparing Your Spreadsheet

Your spreadsheet should follow these guidelines:

1. Column headers should match field names (or be similar for fuzzy matching)
2. One row per document — each row generates one completed PDF
3. Consistent formatting — dates as dates, numbers as numbers
4. No merged cells — keep the structure simple and tabular

Example data table:

Auto-Mapping: How Mergram Connects Columns to Fields

Mergram uses fuzzy matching to connect spreadsheet columns to PDF form fields. This means the names don’t need to be identical — similar names are matched automatically:

• ClientName ↔ Client Name ↔ client_name
• EmailAddress ↔ Email ↔ email_address
• PhoneNumber ↔ Phone ↔ phone_number

After auto-mapping, you can review every mapping and adjust any that aren’t correct. Fields that couldn’t be auto-mapped are highlighted for manual assignment.

When to Use PDF Form Filling

This approach is ideal when you have a pre-existing PDF form with defined fields. Common scenarios include:

• Government forms — Tax forms, visa applications, compliance documents
• HR documents — Employee onboarding forms, benefits enrollment
• Legal contracts — Standard agreement templates with variable fields
• Insurance claims — Claim forms with policyholder and incident data
• Education — Transcript requests, enrollment forms, certificate applications

If your PDF doesn’t have form fields, you can still place data fields visually using the canvas editor — see the mail merge with Google Sheets guide for that approach.

Best Practices for Reliable Merging

1. Name fields clearly in your PDF editor — use descriptive names like client_first_name instead of field1
2. Test with 2–3 rows before running the full dataset to catch mapping issues early
3. Use the preview to verify each field renders correctly with real data
4. Check date formats — ensure your spreadsheet dates match what the form expects
5. Validate required fields — make sure no critical columns have empty values

Common Issues and Troubleshooting

Fields not detected: Your PDF may use XFA forms (dynamic XML forms) instead of AcroForm fields. Try re-saving the PDF in Adobe Acrobat as a “standard” PDF with AcroForm fields.

Wrong data in fields: Check that your column mappings are correct. Fuzzy matching sometimes pairs similar-but-different column names. Unlink and re-map the field manually.

Special characters appearing incorrectly: Save your CSV file with UTF-8 encoding to preserve accented characters, CJK text, and other Unicode content.

Large file processing slowly: For spreadsheets with thousands of rows, the merge runs server-side as a background job. You can close the browser and check back — progress is tracked in the Jobs panel.

Get Started

Upload your PDF form and Excel file to Mergram’s editor to start filling forms automatically. The free plan lets you test with small batches — upgrade when you’re ready to process at scale.