Sheets To Labels

How to Fill a PDF from CSV and Generate One PDF Per Row

Mar 12, 2026

CSV is still one of the most common export formats for orders, contacts, invoices, and fulfillment data. That is why many teams eventually run into the same question:

How do I fill a PDF from CSV and generate one PDF per row?

Batch PDF Mail Merge Tool

Need to fill PDF forms in bulk from Excel or Google Sheets? Upload your PDF template and data sheet, map fields visually, and generate filled PDFs in seconds.

Start PDF Mail Merge

The good news is that CSV works perfectly well for PDF mail merge. The bad news is that many tools only support fillable PDFs, which is not enough for real-world templates.

If your source data is in Excel instead, read How to Fill PDF Forms from Excel in Bulk. If the data is live in a shared sheet, read PDF Mail Merge from Google Sheets.

Why CSV is a strong input format for PDF mail merge

CSV is simple and portable. It works well when your data comes from:

  • Shopify exports
  • WooCommerce exports
  • CRM exports
  • warehouse systems
  • internal admin tools

Each CSV row can become one generated PDF, which makes it a clean fit for batch document generation.

Fillable and non-fillable PDFs both matter

If your PDF already contains form fields, you can map CSV columns directly to those fields.

If your PDF is not fillable, you need a visual mapper instead. That lets you place CSV values onto fixed positions in the template.

That is the difference between a basic PDF form filler and a real CSV-to-PDF workflow.

How to fill a PDF from CSV

1. Clean your CSV headers

Use readable column names such as:

  • customer_name
  • invoice_number
  • tracking_number
  • issue_date

Good headers make field mapping much easier.

2. Upload the CSV file

Make sure the first row contains your headers and the rest of the rows contain data.

3. Upload the PDF template

Use either:

  • a fillable PDF form
  • a non-fillable PDF template

4. Map columns to the PDF

Examples:

  • customer_name -> recipient name
  • invoice_number -> invoice reference
  • tracking_number -> barcode
  • payment_url -> QR code

5. Preview and batch generate

Preview one record first, then generate one PDF per CSV row.

Common CSV-to-PDF use cases

This workflow is useful for:

  • invoices
  • receipts
  • shipping documents
  • certificates
  • event badges
  • internal forms

A privacy-first option

Fill PDF from Excel, Google Sheets, or CSV supports CSV imports, PDF field mapping, non-fillable PDF templates, and batch generation in a local, privacy-first browser workflow.

If your template has no form fields, the visual mapper still lets you place text, barcodes, QR codes, and images exactly where they belong.

If your data is in Google Sheets instead of CSV, see PDF Mail Merge from Google Sheets.

If your CSV is being used for invoices, certificates, contracts, or internal forms rather than labels, the same mapping model also applies to How to Fill PDF Invoices from Excel, How to Generate Bulk Certificates from Excel, How to Fill PDF Contracts from Google Sheets, and How to Batch Fill PDF Forms Without Acrobat.

Frequently asked questions

Can I generate one PDF per row from CSV?

Yes. That is the normal batch generation model. Each CSV row becomes one personalized PDF.

Can I use CSV with a non-fillable PDF?

Yes. As long as the tool supports visual mapping onto the PDF template, CSV works fine with non-fillable PDFs.

Is CSV better than Excel for PDF mail merge?

CSV is often simpler for exports and automation pipelines. Excel is more convenient for manual editing. Both work well.

Fill PDFs from Excel, Google Sheets, or CSV

If you need to map spreadsheet data onto fillable or non-fillable PDF templates, try filling PDFs from Excel, Google Sheets, or CSV with PDF Mail Merge. It supports one PDF per row, merged review files, and ZIP exports.