You have a W-9 form. You also have a spreadsheet with 247 rows of vendor information: name, address, tax ID, business type. You need 247 individually filled W-9 PDFs by end of day.
In Word, this would be a mail merge. Select a template, connect a data source, click merge, done. But your template is a PDF form, not a Word document. And Word's mail merge does not work with PDFs.
This guide explains how to do the PDF equivalent of mail merge: take one form template, connect it to a spreadsheet, and generate hundreds of individually filled PDFs in a single operation.
Why There Is No Built-In Solution
PDF forms have existed since the 1990s. They are widely used for government applications, tax documents, HR onboarding, insurance claims, and enrollment forms. Despite this, there is no mainstream tool that does mail merge natively with PDF forms.
Adobe Acrobat's Limitation
Adobe Acrobat can fill a single PDF form. It has no built-in feature to connect to a spreadsheet and fill the same form with different data for each row. You can write JavaScript to automate form filling, but Acrobat's scripting API is limited and poorly documented for batch operations.
Word Mail Merge Falls Short
Word's mail merge is designed for Word templates. You cannot use a PDF form as a merge template in Word. Some people try to recreate the PDF form layout in Word, run the merge, and then convert to PDF. This introduces the same formatting and layout problems discussed in our batch find and replace guide — the output looks nothing like the original form.
Online Tools Cannot Handle It
Online PDF form fillers handle one file at a time. Upload, fill, download. For 247 forms, that is 247 upload-fill-download cycles. Many online tools also strip form fields or flatten the output unpredictably. And uploading 247 W-9 forms with tax IDs to a third-party server is a compliance concern.
What You Need: Field Mapping
The core concept is simple. A PDF form has named fields (like "company_name", "address_line_1", "tax_id"). Your spreadsheet has column headers. A form-filling tool needs to:
- Read the PDF form and list all field names
- Read the spreadsheet and list all column headers
- Map each spreadsheet column to the corresponding PDF field
- For each row in the spreadsheet, fill the PDF form with that row's data and save a new file
When column headers match field names exactly, the mapping can be automatic. When they differ (the spreadsheet says "Company" but the form field is named "company_name"), you need a manual mapping interface.
Step-by-Step with PDF Batch Editor
Step 1: Load Your Template PDF
Open PDF Batch Editor's Form Fill module and load your PDF form template. The application immediately detects all form fields and displays them in a list: field name, field type (text, checkbox, dropdown), and current value.
For a W-9 form, you might see fields like:
topmostSubform[0].Page1[0].f1_1[0]— NametopmostSubform[0].Page1[0].f1_2[0]— Business nametopmostSubform[0].Page1[0].Address[0].f1_7[0]— AddresstopmostSubform[0].Page1[0].Address[0].f1_8[0]— City, state, ZIPtopmostSubform[0].Page1[0].SSN[0].f1_11[0]— SSN/EIN
These are the actual field names embedded in the PDF. They are often more technical than you would expect, especially for government forms.
Step 2: Connect Your Data Source
Import your CSV or Excel file. The application reads the column headers and displays them alongside the detected form fields. If your spreadsheet has a "Name" column and the form has a field named "f1_1", you map "Name" to "f1_1".
For well-structured data sources where column headers match field names, the mapping is automatic. One click, and every column is matched to its corresponding field.
Step 3: Choose Template Mode
PDF Batch Editor offers two modes for form filling:
- Template mode. One PDF form is used as a template. Each row in the spreadsheet generates a separate filled PDF. This is the mail merge mode — 247 rows produce 247 files.
- Single mode. Multiple PDF forms are loaded, and each is filled with data from a single set of values. Useful when you have different forms that all need the same data (for example, filling multiple forms for one employee).
For the W-9 scenario, you want template mode.
Step 4: Configure Output
Set the output naming pattern. The default uses the template filename plus a row number, but you can include data from any column. For example: {Name}_W9.pdf would produce files like "Globex Industries_W9.pdf".
Choose an output folder. All generated files are saved there with the naming pattern you configured.
Step 5: Execute
Click Execute. The application processes each row: opens the template, fills the fields with that row's data, saves the output file, and moves to the next row. A progress bar shows the current row and overall completion.
For 247 rows with a standard 2-page W-9 form, processing typically completes in under a minute.
Flatten After Fill: Why and When
After filling, your output PDFs contain interactive form fields. The filled values are editable — anyone who opens the PDF can change them. This is sometimes desired (for forms that need review and correction) and sometimes not (for final copies that should be locked).
Flattening converts form fields into static page content. The visual appearance is identical, but the fields are no longer interactive. The filled values become part of the page just like any other text.
Flatten when you want to produce final, non-editable copies. Leave unflattened when recipients need to review or correct values before final submission.
PDF Batch Editor has a "Flatten after fill" toggle. When enabled, each output PDF is automatically flattened as part of the fill operation. No separate step required.
Handling Different Field Types
Text Fields
Text fields are straightforward: the spreadsheet cell value is inserted as the field value. Multi-line text fields accept line breaks. If the text exceeds the field's visible area, most PDF viewers will show a scrollbar or clip the text — flattening makes the full text visible by adjusting the layout.
Checkboxes
Checkboxes accept boolean values from the spreadsheet. Recognized "checked" values include: true, yes, 1, on, and x. Anything else (including empty cells) leaves the checkbox unchecked.
Dropdown Lists
Dropdowns are filled with the spreadsheet value, which must match one of the dropdown's predefined options. If the value does not match, the field is left at its default. This prevents invalid data from entering constrained fields.
Radio Buttons
Radio button groups work like dropdowns: the spreadsheet value must match one of the available options. The matching option is selected, and all others are deselected.
Real-World Use Cases
HR Onboarding Packets
A company hires 35 new employees in Q1. Each needs a filled W-4, I-9, direct deposit authorization, benefits enrollment form, and company handbook acknowledgment. That is 175 forms total. With a spreadsheet of employee data and PDF templates for each form, the entire packet can be generated in minutes.
Tax Form Distribution
An accounting firm prepares 1099-MISC forms for 400 contractors. The contractor data lives in an Excel export from their accounting software. Template mode generates all 400 filled 1099s in a single batch, ready for mailing or electronic delivery.
Government and Regulatory Filings
Agencies provide forms as PDFs. Organizations that need to file the same form with different data for multiple entities (subsidiaries, locations, products) can generate all filings from a single spreadsheet. Building permits, environmental reports, license renewals — any repetitive filing benefits from batch form filling.
Enrollment and Application Forms
A university receives enrollment data from an online portal but needs to produce paper forms for records. With 2,000 incoming students and a 4-page enrollment form, that is 8,000 pages. Template mode generates all 2,000 filled forms from the enrollment database export.
Insurance Claims Processing
Insurance adjusters process claims using standardized PDF forms. Claim data from the internal system can be exported to CSV and batch-filled into claim forms, eliminating hours of manual data entry per adjuster per week. For non-form PDFs, you may want our guide on batch find and replace text. Once forms are filled, you can batch sign them with a digital certificate.
Tips for Success
- Match column headers to field names. The closer your spreadsheet headers match the PDF field names, the less manual mapping you need. Rename your columns before importing if the field names are known.
- Clean your data first. Remove extra spaces, fix encoding issues, and verify formats (especially dates and phone numbers) in the spreadsheet before filling. Garbage in, garbage out.
- Test with 5 rows first. Before processing all 247 rows, run a test with 5. Verify the output, check that all fields are filled correctly, and adjust mappings if needed.
- Use descriptive output filenames. Include identifying data (name, ID number) in the filename pattern so you can find specific files without opening each one.
- Archive the data source. Save the CSV/Excel file alongside the output PDFs. This creates a record of exactly what data was used to generate each form.
Frequently Asked Questions
Can I fill PDF forms from an Excel spreadsheet?
Yes. PDF Batch Editor supports both CSV and Excel (.xlsx) files as data sources. Each row in the spreadsheet becomes one filled PDF. Column headers are mapped to PDF form field names either automatically or through a manual mapping interface.
What types of PDF form fields are supported?
PDF Batch Editor supports all standard AcroForm field types: text fields, checkboxes, radio buttons, dropdown lists (combo boxes), and list boxes. Checkboxes accept values like "true", "yes", "1", or "on" to be checked.
What does flattening a PDF form mean?
Flattening converts interactive form fields into static text and graphics. After flattening, the filled values become part of the page content and can no longer be edited. This is useful for archival, preventing changes, or ensuring consistent appearance across PDF viewers.
How do I find the form field names in my PDF?
PDF Batch Editor automatically detects and lists all form fields when you load a PDF, showing each field's name, type, and current value. You can use this list to match field names with your spreadsheet column headers. Adobe Acrobat also shows field names in its Prepare Form view.
Can I generate a separate PDF for each row in my spreadsheet?
Yes. In template mode, PDF Batch Editor uses one PDF form as a template and generates a separate filled PDF for each row in your data source. If your CSV has 247 rows, you get 247 individually filled PDFs, each named based on a configurable pattern.