Fill hundreds of PDF forms from a spreadsheet

Mail merge for PDFs. Load a template, map fields to columns, generate filled forms for every row.

Download Free Trial

247 W-9 forms · One spreadsheet · Five minutes

PDF mail merge in three steps

1

Load Template & Data

Load your PDF form template. Import your data source — CSV or Excel spreadsheet. The app automatically detects all fillable form fields.

2

Map Fields to Columns

Match PDF form field names to spreadsheet columns. Auto-mapping handles exact name matches. Review and adjust any remaining fields manually.

3

Generate Filled Forms

Click execute and generate one filled PDF per data row. 247 employees in the spreadsheet means 247 completed W-9 forms, each with unique data.

Production-grade form filling

Data Sources

  • Import from CSV files
  • Import from Excel spreadsheets (.xlsx)
  • Automatic column detection and mapping
  • Handles hundreds or thousands of data rows
  • Preview data before generating forms

Field Detection

  • Auto-detects all fillable fields in PDF forms
  • Supports text fields, checkboxes, radio buttons, dropdowns
  • Smart auto-mapping matches field names to column headers
  • Manual override for custom field-to-column mappings
  • Shows field preview with sample data before execution

Output Options

  • One output PDF per data row
  • Custom output filenames with row data variables
  • Flatten forms to lock filled values permanently
  • Keep forms editable if further input is needed
  • Organized output directory structure

Template Mode

  • Fill the same form template with different data sets
  • Single form fill for one-off completions
  • Batch fill across multiple different form PDFs
  • Supports multi-page form templates
  • Chain with digital signing in a pipeline

Real-world PDF form automation

HR Onboarding

An HR manager fills 500 W-9 forms from an employee spreadsheet. Each form gets the correct name, address, SSN, and signature line — all generated in five minutes flat.

Insurance Applications

An insurance agency processes 200 policy applications per week. Import applicant data from their CRM export, map to form fields, and generate pre-filled applications ready for review.

Student Records

A school administrator generates 800 enrollment forms from a student database. Each form is pre-filled with the student's information and flattened for permanent records.

Frequently Asked Questions

What data formats can I import?

You can import data from CSV files and Excel spreadsheets (.xlsx). The app automatically detects column headers and maps them to PDF form field names. Manual overrides are available for any field that doesn't auto-match.

Can I flatten the forms after filling?

Yes. Flattening converts fillable fields into static content, locking in the values permanently. This is ideal for archival, printing, or when you want to prevent further edits. You can also keep forms editable if recipients need to add more data.

Does it support checkboxes and dropdowns?

Yes. The form filler handles text fields, checkboxes, radio buttons, and dropdown lists. Your spreadsheet data is mapped to the appropriate field types automatically.

How are output files named?

You can define custom output filenames using data from any column in your spreadsheet — for example, naming each filled form after the employee name or invoice number from that row.

Stop filling PDF forms by hand

Mail merge for PDFs. One spreadsheet, hundreds of filled forms. Free 14-day trial.

Download Free Trial

Windows 10/11 · No credit card required · All features included