How to Batch Fill PDF Forms from Excel

Power PDF Filler works in 3 steps: select your PDF form, select and map your Excel data, then click 'Ready, Go'. Each row becomes a filled PDF — even 1,000+ forms in seconds. Save your field mappings as a template to reuse next time. Works inside Excel on Windows, Mac, and the web.

1

Select Your PDF Form

Click Select in Power PDF Filler and choose the PDF form you want to fill. The add-in automatically detects all fillable form fields in your PDF. Supports any standard fillable PDF including W-2, 1099, ACORD, I-9, and custom forms.

Step 1: Select a PDF form in the Power PDF Filler panel inside Excel
2

Select & Map Your Excel Data

Highlight the rows and columns in your spreadsheet that contain the data for your forms. Each row becomes one filled PDF. Map your Excel column headers to PDF form fields — or let Power PDF Filler auto-match them for you. Save your field mappings as a reusable template to skip this step next time.

Step 2: Map Excel data columns to PDF form fields in Power PDF Filler
3

Click Ready, Go

Power PDF Filler fills all your forms in seconds — even 1,000+ PDFs. Download each filled PDF individually or grab them all at once as a ZIP file.

Step 3: 1001 PDF forms filled successfully with Power PDF Filler

How does Power PDF Filler work in practice?

Ready to start batch filling PDFs?

Try Power PDF Filler free for 30 days. No credit card required.

Start Free Trial

Frequently Asked Questions

How do I batch fill PDF forms from Excel? ▼
Install Power PDF Filler from Microsoft AppSource, open your Excel spreadsheet, select your PDF form, select your data, and click 'Ready, Go'. Each row becomes a filled PDF.
What is the best tool for filling PDF forms in bulk? ▼
Power PDF Filler is the only tool that works natively inside Microsoft Excel. Alternatives include pdfFiller (limited to 5 PDFs per batch), Adobe Acrobat Pro (complex setup), and BulkPDF (free but Windows-only).
Does my PDF need fillable form fields? ▼
Yes. Your PDF must have fillable form fields for Power PDF Filler to map data to. Most standardized forms (W-2, 1099, ACORD, I-9) already have them. You can add fields using Adobe Acrobat Pro.
How many PDFs can I fill at once? ▼
There is no limit. Users regularly fill hundreds or thousands of PDFs in a single batch. Each row in your Excel spreadsheet generates one filled PDF.
Does my data leave my computer? ▼
In any modern browsers(e.g. Chrome/Edge), all processing is client-side — your spreadsheet data never leaves your machine. When using desktop Excel on Windows or Mac, data is transmitted securely via HTTPS and automatically purged daily. Power PDF Filler is safe for sensitive data like SSNs and financial records in both modes.

Ready to stop filling PDFs manually?

Start your free trial — no credit card required.

Try Free on Microsoft Excel