How to Batch Fill PDF Forms from Excel

Power PDF Filler works in 4 steps: select your PDF form, select your Excel data, preview the mapped fields, then click 'Ready, Go'. Each row becomes a filled PDF — even 1,000+ forms in minutes. Works inside Excel on Windows, Mac, and the web.

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

Select 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.

Step 2: Select Excel data rows and columns for batch filling

Preview Mapped Data

Review how your Excel data maps to the PDF form fields before filling. The preview shows a side-by-side view of the field mapping table and the filled PDF, so you can verify everything looks correct before generating all your forms.

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. Save your field mappings as a template for next time.

Step 4: 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, upload 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 Chrome and 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 AppSource