Sheets To Labels

How to Map Excel Columns to PDF Fields

Mar 14, 2026

One of the most common PDF automation questions is:

How do I map Excel columns to PDF fields?

If your question is broader than field mapping itself, read How to Fill a PDF from Excel.

That question has two different answers depending on the PDF.

Case 1: The PDF is fillable

If the PDF contains real form fields, the job is mostly about matching Excel headers to field names.

Example:

  • Excel full_name -> PDF Name
  • Excel issue_date -> PDF Date
  • Excel invoice_id -> PDF InvoiceNumber

In this case, field detection is the main step.

Case 2: The PDF is not fillable

If the PDF is non-fillable, there are no field names to discover. The PDF is just a static layout.

That means the mapping process changes:

  • identify the visual location on the page
  • place the column value there
  • preview the output
  • adjust styling if needed

This is where a visual mapper is much better than a simple form inspector.

How to map Excel columns to PDF fields in practice

1. Prepare the Excel file

Keep your first row clean and descriptive.

Good examples:

  • employee_name
  • start_date
  • contract_id
  • amount_due

2. Upload the PDF template

If the template is fillable, the system can often detect field names automatically.

If it is non-fillable, the system should let you place output visually.

3. Match each column to its destination

This can mean:

  • binding a column to a form field
  • binding a column to an X/Y area on the page
  • binding a column to a barcode or QR code block

4. Preview long and short values

Always test:

  • long names
  • large numbers
  • empty fields
  • multi-page templates

That catches clipping and spacing issues early.

What if you need to find PDF field names?

If the PDF is fillable, field names can usually be read from the PDF structure or a field inspector.

If the PDF is non-fillable, there are no field names to find. In that case, the practical solution is to switch from field detection to visual mapping.

That is why many "find PDF field names" workflows eventually turn into "map spreadsheet data onto a PDF template."

A better workflow for Excel-to-PDF mapping

PDF Mail Merge supports both approaches:

  • direct mapping to fillable PDF fields
  • visual placement for non-fillable PDF templates

That makes it useful for certificates, contracts, invoices, labels, and other documents that may not have built-in form fields at all.

For a deeper overview of the non-fillable workflow, read How to Fill a Non-Fillable PDF from Excel or Google Sheets.

If you are mapping fields for specific document types, the same logic applies to PDF invoices from Excel, bulk certificates from Excel, and tax forms in bulk from Excel.

Frequently asked questions

How do I find PDF field names from Excel mail merge data?

If the PDF is fillable, inspect the field names and map your Excel headers to them. If the PDF is not fillable, use a visual mapper instead.

Can I map Excel columns to a non-fillable PDF?

Yes. You map the column to a visual position on the page instead of to a built-in field name.

Can one Excel row generate one PDF?

Yes. That is the standard batch PDF generation 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.