Sheets To Labels

How to Fill a PDF from Excel

Feb 25, 2026

The question usually starts in a very simple form:

How do I fill a PDF from Excel?

At first, that sounds like a one-off document problem.

But in practice, it almost always means something larger:

  • one spreadsheet already contains the data
  • one PDF template already exists
  • each row needs to become one finished document

That is why "fill a PDF from Excel" is usually not just PDF editing. It is a spreadsheet-to-PDF generation workflow.

Why Excel is a common source for PDF generation

Excel is often where structured document data already lives.

Teams use it for:

  • invoices
  • contracts
  • certificates
  • tax forms
  • payroll records
  • internal document packs

In most of these cases, the layout does not change much. The values do. That makes Excel a natural source for repeatable PDF generation.

A realistic scenario

Imagine an operations team with an Excel file containing 250 rows.

Each row contains:

  • name
  • document ID
  • date
  • amount
  • address

They also have one approved PDF template.

What they do not want is:

  • opening 250 PDFs by hand
  • copying the same fields over and over
  • checking every exported file for formatting drift

What they need is a way to connect the spreadsheet to the template once, preview the result, and generate the full batch.

Fillable vs non-fillable PDFs

This distinction matters because the workflow depends on the template.

Fillable PDF

A fillable PDF already contains built-in form fields.

In that case, the job is mostly:

  • inspect the fields
  • map Excel columns to those fields
  • generate the output

Non-fillable PDF

A non-fillable PDF is just a static layout.

There are no form fields to discover, so the workflow has to place values visually on the page instead.

That is why support for non-fillable templates matters so much in real business workflows.

For the static-template case, see How to Fill a Non-Fillable PDF from Excel or Google Sheets.

How to fill a PDF from Excel

1. Start with one row per output document

Typical columns might include:

  • full_name
  • document_id
  • issue_date
  • amount
  • address

2. Upload the PDF template

This can be:

  • a fillable form
  • a non-fillable PDF
  • a single-page template
  • a multi-page document

3. Map each Excel column to the PDF

This can mean:

  • binding a column to a fillable field
  • placing a value at a fixed position on the page
  • generating a barcode or QR code from a cell value

If your main question is specifically about finding field names or mapping columns correctly, read How to Map Excel Columns to PDF Fields.

4. Preview real rows

Always test:

  • short values
  • long values
  • empty optional fields
  • large numbers

That catches layout problems early.

5. Generate one PDF per row

Once the mapping is correct, every Excel row can become one PDF.

That is the core model behind Excel-driven PDF generation.

If that one-row-to-one-file workflow is your main use case, see How to Generate One PDF Per Row from Excel.

What people usually mean by "fill a PDF from Excel"

In practice, this search intent often includes several related workflows:

  • fill a fillable PDF form from Excel
  • fill a non-fillable PDF template from Excel
  • generate one PDF per row
  • run PDF mail merge from spreadsheet data

That is why the best solution usually combines:

  • spreadsheet import
  • field mapping
  • preview
  • batch generation

Common document types

This workflow is especially useful for:

  • invoices
  • certificates
  • contracts
  • payroll PDFs
  • tax forms

If your use case is document-specific, see How to Fill PDF Invoices from Excel, How to Generate Bulk Certificates from Excel, How to Fill Tax Forms in Bulk from Excel, and How to Generate Pay Stubs in Bulk from Excel.

A practical way to do it

PDF Mail Merge supports Excel-driven PDF mapping and batch generation for both fillable and non-fillable templates.

That makes it useful when you already have:

  • spreadsheet data
  • an existing PDF template
  • a need to generate multiple personalized PDFs quickly

Frequently asked questions

Can Excel fill a PDF automatically?

Yes, when paired with a PDF mapping workflow. Excel provides the data, and the mapper applies it to the PDF template.

Do I need a fillable PDF?

No. A non-fillable PDF can also work if the tool supports visual placement on static templates.

Is this the same as PDF mail merge?

In many cases, yes. Filling a PDF from Excel is often a spreadsheet-driven PDF mail merge workflow.

Try PDF Mail Merge

If you want a privacy-first way to map spreadsheet data onto fillable or non-fillable PDF templates, try PDF Mail Merge. It works with Excel, CSV, and Google Sheets and can generate one PDF per row.