PDF Form Filling

What is PDF Form Filling?

PDF Form Filling lets you take a PDF that already has fillable form fields (AcroForm fields) and populate them with data from your spreadsheet. Instead of manually typing into each field, you map spreadsheet columns to form fields and generate hundreds of completed PDFs in one go.

How Form Filling Works

1. Upload a PDF with form fields

   Upload a PDF that contains fillable AcroForm fields. Mergram automatically detects all form fields and lists them in the sidebar.

2. Upload your spreadsheet

   Upload an Excel or CSV file (or connect a Google Sheet). Column headers become available data fields.

3. Map columns to form fields

   For each detected form field, choose which spreadsheet column should fill it. Matching column and field names are auto-mapped.

   Speed up mapping

   Name your spreadsheet columns to match your PDF form field names exactly. For example, if a field is named FirstName, name your column FirstName. This enables full auto-mapping with zero manual configuration.

4. Preview and fill

   Preview individual rows in real time, then merge to generate all filled PDFs at once.

Supported Field Types

Mergram detects and fills these PDF form field types:

• Text fields — Single-line and multi-line text inputs
• Checkboxes — Checked/unchecked based on your data
• Radio buttons — Selected option from a group
• Dropdowns — Pre-defined list selections

Auto-Mapping

When your spreadsheet column headers match PDF form field names, Mergram auto-maps them:

• Exact name matching — A column named First Name maps to a field named First Name
• Fuzzy matching — Similar names are auto-mapped using multi-phase fuzzy matching (abbreviation expansion, token overlap, and similarity scoring)
• Manual override — Change any mapping by selecting a different column from the dropdown

Common Use Cases

• Tax forms — W-2, 1099, and other IRS forms with employee or contractor data
• Certificates — Training, completion, and award certificates with recipient details
• Employment — Offer letters, I-9, W-4, and direct deposit forms for new hires
• Insurance — Claim forms, policy applications, and beneficiary updates
• Legal — Contracts, agreements, disclosures, and consent forms
• Healthcare — Patient intake, consent forms, and medical history questionnaires
• Education — Enrollment forms, grade reports, and student ID cards

Preparing Your PDF

For best results, your PDF should have properly defined form fields. If your PDF’s form fields aren’t being detected:

• Use PDF Form Repair to fix corrupted appearance streams
• Ensure the PDF was created with form-authoring tools (Adobe Acrobat, LibreOffice, etc.)
• Flatten any annotations that might interfere with form field detection
• Avoid scanned PDFs — they need OCR before form fields can be extracted

Form Mode vs Canvas Mode

Tips & Best Practices

• Check field detection — After uploading, verify all expected fields appear in the sidebar
• Test with a few rows — Preview several rows before running a bulk merge
• Keep original PDFs — Save a copy of the blank form in case you need to re-upload
• Use consistent naming — Match column headers to field names for auto-mapping
• Validate data types — Ensure checkboxes receive boolean-like values (Yes/No, True/False, 1/0) and dropdown values match the available options exactly

Limitations

• No digital signatures — Digital signature form fields are not supported
• No calculated fields — JavaScript-calculated fields in PDFs are not evaluated during merge
• No file attachment fields — File attachment form fields are not supported
• Field styling — Form Mode inherits the original PDF field styling. For custom fonts, colors, or sizes, use Canvas Mode instead