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, and can email each one to the person on its row, so you never split and send a merged file by hand again.

50 free documents No credit card Set up in minutes
Your data
Name
Email
Plan
PDF
Dear Maria,
G24.9/5 Rated on G2 by real users
860,000+
Documents generated to date
2,000+
Documents generated every day

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. If your sheet has an email column, DocuPotion can also send each person their own PDF, with a subject and message personalised from their 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. Download them all, or map an email column and have each PDF delivered straight to its recipient.

DocuPotion AI editor showing a contract template

Mail merge to email, with the PDF attached

DocuPotion treats delivery as part of the merge. Map the email column in your spreadsheet and each recipient gets their own PDF as an attachment, with a subject line and message personalised from their row, sent the moment their document is generated.

Delivery is tracked per recipient (sent, delivered, or bounced), failed emails can be resent without regenerating anything, and you can send yourself a test first: one email, exactly as your recipients will see it.

  • Personalised subject and message. Merge fields work in the email as well as the document.

  • Per-recipient delivery status. Sent, delivered, or bounced, at a glance.

  • Replies come to you. Set your own reply-to address so responses reach the right inbox.

Email delivery is included on paid plans. Prefer to send them yourself? Just download the batch.

See it in action

A spreadsheet becoming individually named PDFs, each emailed to its recipient.

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.

Can DocuPotion email each merged PDF to its recipient?

Yes. Map a column in your spreadsheet as the recipient address and DocuPotion emails each person their own PDF as an attachment. The subject line and message body support merge fields, so every recipient gets a personal email rather than an obvious blast. Emails are sent from documents@send.docupotion.com and replies go to an address you choose. Email delivery is available on paid plans.

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, generate an individual PDF for every record, and email each one to its recipient. Start free with 50 documents, no credit card required.