PDF mail merge, one file per row

Upload a spreadsheet and map your column names to template merge fields. DocuPotion generates a separate PDF for every record, so you never split one long merged file by hand again.

50 free documents No credit card Set up in minutes
Your data
Name
Email
Plan
PDF
Dear Maria,

Mail merge is the classic way to turn a list of records into documents, but the built-in Word and Google Docs versions are painful for PDFs: you merge into one long file, then fight to split it into separate documents, and redo the whole thing whenever the template changes. DocuPotion mail merges PDFs directly: build a reusable template, upload a spreadsheet and get one PDF per row. Check out the demo below to see how it works.

Try it yourself

Run the sample spreadsheet below and watch each row become its own PDF.

Merge fields sit wherever data should be filled in.

Northfield College
Office of Admissions
August 1, 2026

Dear {{student_name}},

We are delighted to offer you a place at Northfield College to study {{programme}}, beginning {{start_date}}. Your application reference is {{application_id}}.

Please confirm your place by {{accept_by}}. If you have any questions, your admissions advisor, {{advisor}}, is happy to help.

Warm regards,
Admissions Office, Northfield College

Here's how it works

From a list of records to a finished PDF for each one.

1

Bring your data

Upload a spreadsheet: CSV, Excel or Google Sheets. Each row in your file becomes one document in the batch.

2

Build your reusable template

In DocuPotion, build a reusable template and add merge fields like {{name}} or {{date}}. Design a template from scratch with our AI-powered editor, or upload one of your existing documents.

3

Generate a PDF per row

DocuPotion fills the template for every row and returns a separate, finished PDF for each one.

DocuPotion AI editor showing a contract template

Frequently asked questions

How do you mail merge a PDF document?

Build a reusable template in DocuPotion with merge fields like {{name}}, then upload a spreadsheet of your records. DocuPotion fills the template once per row and returns an individual PDF for each record, so you skip the Word or Google Docs mail merge step entirely.

Can I mail merge to separate PDF files instead of one combined document?

Yes. DocuPotion creates a separate PDF for each record, so you get individual files rather than one long merged document you have to split up afterwards.

Can I mail merge from Excel to PDF?

Yes. Upload an Excel or CSV export as-is; each row populates one PDF from your template, with no need to open Word or Google Docs first.

Do I need Microsoft Word or Google Docs?

No. You build the template in DocuPotion and merge your data straight in, so you can skip Word and Google Docs mail merge entirely.

What can I use as the data source?

For a mail-merge batch, a spreadsheet: CSV, Excel or Google Sheets. Each row populates one PDF. If you'd rather generate documents one at a time as new data arrives instead of as a batch, that's available separately through our REST API, Zapier, or n8n.

Can I generate a large batch of PDFs at once?

DocuPotion allows you to generate up to 5,000 PDFs in a single run. If you have a spreadsheet with more than 5,000 rows of data, you can split into multiple files and do several runs.

Can I match the PDFs to my branding?

Yes. DocuPotion templates use your own logo, colours, fonts and layout, so every generated PDF is on-brand and consistent.

Can I fill out PDF forms bulk?

Yes. DocuPotion maps input fields on fillable PDF forms to merge fields. You can map these merge fields to columns in your spreadsheet and generate filled-out PDFs in bulk.

Mail merge to PDF without the busywork

Build your template once and generate an individual PDF for every record. Start free with 50 documents, no credit card required.

Start free trial