PDF mail merge
One form, one spreadsheet, a filled copy for every row.
Drop files here
or click to choose from your deviceAccepted: PDF, CSV, TSV, TXT
Up to 3 files per runUp to 20 MB per file5 runs per dayFree PDFs end with a small “Made with nouplo.com” lineRemove limits with Pro✓ Works offline
Your files stay on your device
This tool runs entirely in your browser. Nothing is uploaded, nothing is stored, and you can even turn off your internet connection before you start.
Example
Example: 14 end-of-season certificates from one fillable PDF and a team list
A youth soccer coach has certificate.pdf, made in a form editor with text fields player_name, team and season and a checkbox mvp, and tigers-spring.csv saved from the team sheet: 14 rows under the headings Player Name, Team, Season, MVP and Coach email. What to produce: A separate file for each row.
- Columns are matched to fields with case, spaces and underscores ignored: Player Name fills player_name, and Team and Season fill their own fields.
- MVP fills the checkbox: yes on one row ticks it, and the 13 empty cells leave it unticked.
- Coach email matches no field, so it is left out and named in a note beside the result: Columns with no field of that name: Coach email.
- Each row is filled into a fresh copy of the template and flattened, so the names are printed text that nobody can edit later.
| What to produce | You get |
|---|---|
| A separate file for each row | 14 files, certificate-01-Ava Example.pdf to certificate-14-Nora Example.pdf |
| One PDF with a copy per row | certificate-merged.pdf, 14 pages to print in one go |
Fourteen certificates, each named after its player, ready to email to the families one by one. Open the first one before you send them all.
How it works
- Add two files: the PDF with form fields in it, and a CSV whose first row is the column headings.
- Name the columns after the fields. Case, spaces and underscores are ignored, so “Full name” fills “full_name”.
- Choose one merged PDF for printing, or a file per row for sending out.
- Download and check the first copy before you print two hundred.
Frequently asked questions
- Where do the form fields come from?
- From the PDF you add. Make them in Acrobat, LibreOffice Draw or any form editor: a text field named “name”, another named “date”, and so on. A PDF with no fields has nothing to fill, and the tool says so.
- Why are the fields no longer editable afterwards?
- Because each copy is flattened — the field becomes ordinary printed text. Two copies of the same form in one file would otherwise share their field names and show the same values on every page.
- Which field types work?
- Text fields, checkboxes, dropdowns and radio groups. A checkbox is ticked for anything except an empty cell, 0, no, false or off (or the word for no in another language, such as nein, non or não).
- How many rows can it do?
- Up to five hundred in one run. Past that a browser struggles to hold the result; split the list and run it twice.
- What are the files called?
- After the template, with the row number and the value in the first matching column: certificate-01-Ava Example.pdf, certificate-02-Ben Sample.pdf. The number is padded to the length of the list, so the files sort in order. One merged file is called certificate-merged.pdf.
- Can I use a spreadsheet file?
- Save or download it as CSV first; most spreadsheet programs offer CSV under Save As or Download. The tool reads .csv, .tsv and .txt files and works out whether the columns are separated by commas, semicolons or tabs, or you can choose.
- Is my list uploaded?
- No. The PDF and the spreadsheet are read in your browser and the copies are made there — which matters, because a mail merge list is usually a list of real people.