Sheets To Labels

How to Fill a Non-Fillable PDF from Excel or Google Sheets

Mar 21, 2026

Fill PDF from Excel or Google Sheets

A Reddit question captured a problem that shows up all the time:

"I'm trying to find a way to find out the mapping of the fillable fields of a pdf document"

At first, that sounds simple.

Open the PDF. Find the form fields. Map Excel columns to those fields. Generate one PDF per row.

That works if the PDF is a real fillable form.

But many of the PDFs businesses actually need to automate are not fillable PDFs at all. They look like forms, labels, invoices, or certificates, but technically they are just static PDF templates with no AcroForm fields inside.

That is why the better question is not just "How do I find the fillable fields?" It is:

How do I fill any PDF from Excel, CSV, or Google Sheets, even when the PDF is not fillable?

If your question is broader and not only about static templates, read How to Fill a PDF from Excel.

What a non-fillable PDF actually means

A fillable PDF contains real form fields inside the file. Those fields have names and can usually be detected automatically.

A non-fillable PDF is different:

  • it has no editable form fields
  • it has no field names to inspect
  • it is just a visual layout

This is common with PDFs exported from Word, Canva, Illustrator, a shipping platform, or an internal business tool.

Why most PDF mail merge tools fail here

Many PDF form fillers only work when a PDF already contains form fields. When the template is non-fillable, they have nothing to bind your spreadsheet columns to.

The practical solution is a visual mapper.

Instead of reading built-in fields, a mapper lets you place spreadsheet data onto the PDF visually:

  • text
  • numbers
  • images
  • QR codes
  • barcodes

That is what makes non-fillable PDF automation possible.

The workflow that works

The right workflow for PDF mail merge looks like this:

1. Start with spreadsheet data

Your data source can be:

  • Excel
  • CSV
  • Google Sheets

Each row becomes one output PDF.

2. Upload an existing PDF template

This can be:

  • a fillable PDF form
  • a regular non-fillable PDF
  • a multi-page PDF template

If your source is Google Sheets, one practical workflow is to launch the add-on from the sheet first, then continue in the full browser mapper. That is the same product flow shown in PDF Mail Merge guide.

Install and launch PDF Mail Merge from Google Sheets

If your source is Excel or CSV, the idea is the same: bring the spreadsheet data and the PDF template into one mapping workspace before you place fields.

3. Map fields visually

If the PDF is fillable, map spreadsheet columns to the built-in fields.

If the PDF is non-fillable, map spreadsheet columns to positions on the page instead.

For example:

  • name goes into the recipient block
  • order_id goes in the reference area
  • tracking_number becomes a barcode
  • certificate_url becomes a QR code

In practice, this is the step that matters most for non-fillable PDFs. Instead of trying to discover fields that do not exist, you drag spreadsheet columns into the correct visual positions on the PDF.

Map spreadsheet columns onto the PDF visually

4. Preview one row

Preview a sample record before generating the full batch to check:

  • alignment
  • spacing
  • clipping
  • font size
  • barcode readability

The preview step is where you catch the common real-world issues:

  • long names
  • narrow address blocks
  • oversized numbers
  • content that shifts on multi-page templates

Preview how the spreadsheet data will look on the PDF

5. Generate one PDF per row

Once the mapping is correct, generate one PDF per row from the spreadsheet.

This is the core batch PDF generation workflow most people are actually looking for.

After the preview looks right, generate the full batch. Depending on the workflow, that can mean one combined PDF or a ZIP of individual PDF files.

Generate the final batch of PDFs

A better way to think about the problem

The old model is:

PDF form filling

The better model is:

PDF template mapping plus batch generation

That shift matters because once you support non-fillable PDFs, you can automate the messy real-world templates businesses already use.

A privacy-first way to do this

If you want to fill non-fillable PDFs from spreadsheet data, PDF Mail Merge supports both fillable and non-fillable PDF templates with a visual web editor.

It is designed around a workflow that is:

  • browser-based
  • local-first
  • privacy-first

That matters when your PDFs contain customer addresses, invoices, certificates, tax records, or internal business documents.

If your data already lives in Google Sheets, you can also use the Google Workspace add-on.

For a walkthrough, watch the video demo.

The reason this workflow works well for non-fillable PDFs is simple: it does not depend on embedded form fields. It depends on a visual mapper, preview, and local batch generation flow.

Frequently asked questions

Can I fill a non-fillable PDF from Excel?

Yes. If the PDF has no built-in form fields, you can still fill it by mapping spreadsheet columns to visual positions on the page.

Can I fill a non-fillable PDF from Google Sheets?

Yes. The workflow is the same. You connect your Google Sheets data, map columns to the PDF template, preview the result, and generate one PDF per row.

Is this the same as PDF mail merge?

Yes. Many users call this PDF mail merge, especially when a spreadsheet is merged into a PDF template to create personalized documents in bulk.

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.