How to Batch Fill PDF Forms
Batch filling generates hundreds or thousands of individually personalized PDF forms from a single template and a data source like a spreadsheet. This is essential for mass-producing certificates, personalized letters, tax forms, employee onboarding packets, event badges, and any document where the layout stays the same but each copy contains unique data. SublimePDF merges your CSV or Excel data with a PDF form template to produce one filled PDF per data row.
Follow the step-by-step instructions below, then use the free tool directly — no registration or download required.
Open Tool →How to Batch Fill PDF Forms — Step by Step
Upload the blank PDF form template
Open the Batch Fill tool and upload your PDF form with empty interactive fields. The tool lists all field names found in the template — these become the merge targets for your data.
Upload your data source
Upload a CSV or Excel file containing the data to fill into the forms. Each column header should match (or be mappable to) a form field name. Each row represents one filled form to generate.
Map columns to form fields
The tool auto-maps columns to form fields when names match. Manually connect any unmatched pairs — for example, map the spreadsheet column 'Full Name' to the form field 'applicant_name'. Unmapped columns are ignored.
Preview sample outputs
Preview 2–3 filled forms to verify the data merges correctly. Check for truncated text (field too small for the data), missing values, and formatting issues like dates or currencies that need specific formats.
Set output options
Choose individual PDFs (one file per row, named by a data field like employee name) or a single combined PDF (all filled forms merged into one document with optional separator pages between entries).
Generate and download
Click 'Generate' to produce all filled forms. Download as a ZIP of individual files or a single merged PDF. The tool reports how many forms were generated and flags any rows that had data errors.
Pro Tips
- 💡 Clean your data source before uploading — remove extra spaces, standardize date formats, and fix inconsistencies. Garbage in the spreadsheet means garbage in every generated PDF.
- 💡 Test with 3–5 rows first before running a full batch of hundreds. This catches mapping errors and formatting issues without wasting processing time on a large dataset.
- 💡 For personalized certificates, use a field for the recipient's name that's sized generously. Names vary dramatically in length, and a too-small field truncates longer names.
- 💡 When generating individual files, use a unique data field (like employee ID or email) in the filename pattern to avoid duplicate names and ensure easy identification.
Privacy & Security
All processing happens directly in your browser. Your files are never uploaded to any server — they remain on your device throughout the entire process. SublimePDF uses WebAssembly technology for fast, secure, client-side processing.
Works Everywhere
This tool works on any modern browser — Chrome, Firefox, Safari, or Edge — on desktop, tablet, or mobile. No software to install. PDF is an open ISO standard supported by all major platforms.
How to Batch Fill PDF Forms — FAQ
What data formats can I use as the source?
Can I batch fill forms with images (like photos)?
What happens if a data value is too long for a form field?
Can I flatten the filled forms so recipients can't edit them?
Related Guides
How to Fill Out a PDF Form Online
Many important forms — tax documents, applications, contracts — come as PDF files. SublimePDF lets you fill them out directly in your browser without printing, handwriting, and scanning.
How to Batch Convert To PDF
When you have dozens of Word documents, Excel spreadsheets, images, and presentations that all need to become PDFs, converting them one by one is tedious and error-prone. Batch conversion processes your entire folder of files in one operation, applying consistent settings to every document. SublimePDF's batch converter handles mixed file types and outputs a ZIP of individual PDFs or a single merged document.
How to Add Page Numbers to PDF
Adding page numbers to a PDF makes documents easier to navigate and reference. Whether it's a report, manuscript, or legal document, SublimePDF lets you add customizable page numbers in seconds.