CSV is still one of the most common export formats for orders, contacts, invoices, and fulfillment data. That is why so many teams eventually search for the same thing:
How do I fill a PDF from CSV and generate one PDF per row?
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.
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_nameinvoice_numbertracking_numberissue_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 nameinvoice_number-> invoice referencetracking_number-> barcodepayment_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
PDF Mail Merge 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 or internal forms rather than labels, the same mapping model also applies to workflows like How to Fill PDF Invoices from Excel 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.
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.