PDF Mail Merge from Excel — Bulk Certificates
Fill a PDF form or a certificate template from Excel, CSV or pasted rows: one PDF per row, named from your columns, as a ZIP or one combined file. No upload, no watermark.
Loading only the code needed for this tool…
PDF editing
Apply edits deliberately, then inspect the final PDF
Annotations, forms, stamps, page numbers, headers and watermarks are destination-specific edits. Check placement, readability and whether the final output still matches the document purpose.
Input
.pdf, .png, .jpg, .jpeg
Output
Batch
Up to 2 files per run
Up to 2 files per run. Only use one run when files share the same operation.
Move into a related operation instead of re-finding the tool.
Download a destination-ready result and verify it before sharing.
Configured runtime limit applies.
Natural next steps
Continue with a related tool using the same file workflow.
PDF, PNG, JPG, JPEG, WEBP, CSV, TSV, TXT, XLSX
Check the upload limit below
Review the result before sharing
Smart workflows
Finish the job, not just the file
Use the existing tool graph to continue into useful next steps. Bulk and output-packaging capabilities are surfaced automatically where the underlying tool supports them.
Continue with Form Filler
Bulk-readyFinish the job after Pdf Mail Merge with a relevant MAXScanner tool, without creating a duplicate converter page.
- Pdf Mail Merge
- Form FillerWorkflow-ready
Best when Pdf Mail Merge is only the first step in your workflow.
Continue with Sign Pdf
Bulk-readyFinish the job after Pdf Mail Merge with a relevant MAXScanner tool, without creating a duplicate converter page.
- Pdf Mail Merge
- Sign PdfBulk processing · Workflow-ready
Best when Pdf Mail Merge is only the first step in your workflow.
About This Tool
Choose a template, add your spreadsheet rows, say where each column goes, then select Make PDFs. You get one PDF per row, each named from your columns (for example Ana Ruiz-FA-2026-001.pdf), in a ZIP, or every row in one combined PDF, or both. The template can be a PDF form with fillable fields, any other PDF, or a PNG or JPG of a certificate, letter or card. The rows can come from an Excel .xlsx file, a CSV or TSV file, or cells pasted straight from Excel or Google Sheets. Everything runs in your browser: the template and the list are not uploaded, there is no watermark and no sign-up, and one run takes up to 500 rows.
Two kinds of template
- A PDF with form fields (a registration form, a W-9-style tax form, a letter with fillable boxes). Each field is matched to the column with the same name, ignoring case, spaces and punctuation, so the field full_name takes the column Full name. A close name is matched too when only one column fits; anything else you choose from a list. Checkboxes are ticked when the cell says yes, 1, x or ✓ (or sí, oui, ja, はい and the like). A dropdown only accepts its own choices, and the check before the run tells you which rows have another value. Tick Make the filled fields part of the page if nobody should change the values later.
- Any other PDF or a picture. Tap the page where text should go. A tap just above a printed line (the name line on a certificate) puts the box on that line, as wide as the line. In the box, type text with column names in double braces, such as Awarded to {{Name}} on {{Date}}, and pick the size, alignment, bold, a serif or sans-serif face and a colour. A picture is placed on an A4 or US Letter page, turned to the picture's orientation.
Worked example: 100 first-aid certificates
We made an A4 landscape certificate in a PDF (a border, a title and printed lines, 1.3 KB) and a class list of 100 rows with the columns Name, Course, Date and ID. Every twelfth name was Japanese, Chinese, Korean or Arabic, and one was 59 characters long. Four text boxes went on the certificate: the name in 34 pt bold serif, the course in 20 pt, the date in 12 pt and the certificate ID in 8 pt. File names followed {Name}-{ID}. These are the measured results of the tool's own engine on a desktop computer; a phone takes several times longer.
| What we measured | Vector certificate (1.3 KB) | Same certificate on 3508 × 2480 px artwork (693 KB JPEG) |
|---|---|---|
| 100 PDFs plus the combined PDF | 0.7 s | 0.8 s |
| Size of one row's PDF | 2.7 KB to 4.8 KB (Latin names 2.8 KB; a Japanese name 4.2 KB and an Arabic name 4.5 KB, because a small piece of the font is embedded) | 694 KB |
| ZIP of 100 PDFs | 306 KB | 69.4 MB |
| One combined PDF, 100 pages | 54 KB | 745 KB |
The 59-character name did not fit the 16.3 cm name line at 34 pt, so it was set at 17.5 pt and the result screen reported "Text was made smaller to fit in 1 row (first: row 50)". The combined PDF is so much smaller with artwork because it stores the template once and repeats it on every page, while each separate PDF has to carry its own copy. At 500 rows the artwork run took 3.4 s and 1.6 s more to build the ZIP: 347 MB of separate PDFs, against 0.9 MB for the combined file.
What goes in and what comes out
| Supported | |
|---|---|
| Template | PDF (fillable or not, several pages), PNG, JPG, WebP. A picture longer than 3508 px, or a PNG over 1.5 MB, is saved again as a JPEG so each PDF stays small. |
| Data | .xlsx (first sheet), .csv, .tsv, .txt, or pasted cells. A CSV saved by Excel in Japanese, Korean or Chinese (Shift_JIS, EUC-KR, GB18030, Big5) is read correctly when you use this page in that language. Old .xls files must be saved as .xlsx first. |
| Rows | Up to 500 per run; the first row holds the column names, or untick that and the columns are called A, B, C. |
| Output | One PDF per row in a ZIP, one combined PDF, or both. Text stays real text you can select and search. |
| Writing systems | Latin, Greek, Cyrillic, Chinese, Japanese, Korean, Arabic (shaped and right to left) and Devanagari on placed text. Bengali, Thai and Hebrew cannot be drawn yet; the tool says so instead of printing empty boxes. Form fields cannot show Devanagari correctly, so use placed text for Hindi. |
How long values are fitted
The size you choose is the largest size. A value too long for its box is made smaller until it fits, but never below 6 pt. Below that, the end is cut with "…" and the row is listed after the run so you can fix it. A box set to Several lines wraps words at the box width, which suits addresses and short paragraphs. Start alignment means the left edge for Latin text and the right edge for Arabic, so one template works for both. Latin text uses Helvetica or Times; other writing systems use Noto fonts that are downloaded only when your data needs them.
File names
Write column names in braces in File names: {Name}-{ID}, {{Name}} or certificate-{#}, where {#} is the row number (001, 002 …). Characters that Windows or macOS do not allow in names (/ \ : * ? " < > |) become a hyphen, names are cut at 100 characters, a name that comes out empty becomes row-007, and repeated names get -2, -3 and so on. The same list therefore always gives the same names.
Checks before you make the PDFs
Under the settings the tool lists what would go wrong: a placeholder or file-name column that does not exist (often a spelling difference), cells that are empty in a column you use, file names that repeat, and dropdown values the form does not offer. The preview shows the real PDF for any row; type a row number to check the longest name or the one with accents before you run all of them.
After the PDFs are made
Send the combined PDF or the first file on to Sign PDF, Merge PDF, Compress PDF or Encrypt PDF (password) without uploading it again. To make a fillable form to merge into, start with Form Creator; for a single form typed by hand, Form Filler is quicker. For envelopes and sticky address labels from the same list, use the Address Label Maker.
When this is not the right tool
- It does not send e-mail. You get the files; attach them yourself, or use your e-mail program's own mail merge with the ZIP's names.
- Only text is merged. A different photo, signature or QR code per row is not supported yet; put a fixed logo or signature in the template.
- Word templates (.docx) are not read. Make the letter a PDF first, or use Word's own mail merge if you need conditional paragraphs ("if the amount is over 100, add this sentence").
- Big batches with a picture template on a phone: each separate PDF carries the picture, so 500 certificates on 700 KB artwork come to about 350 MB, plus the same again for the ZIP. The tool estimates this from the preview row and warns when your device may not cope. Choose All rows in one PDF (under 1 MB here) or split the list.
- Dynamic XFA forms (some government forms made with Adobe LiveCycle) have no standard fields to fill; they show up as a PDF without form fields.
- Password-protected templates must be unlocked with Unlock PDF first.
How to Use
Choose the template
A PDF with or without form fields, or a PNG or JPG of a certificate or letter. Or select Use a sample certificate to try the tool first.
Add the rows
Open an Excel .xlsx or CSV file, or paste cells copied from a spreadsheet. The first row holds the column names; up to 500 rows per run.
Say where each column goes
Form fields are matched to columns by name; change any match in the list. On other templates, tap the page to add text boxes with {{Column}} placeholders.
Check and make the PDFs
Set the file names from columns, look at the preview of any row and the checks, then select Make PDFs. Download the ZIP, the combined PDF or both.
Use Cases
Certificates for a course or event
Names, course and date from the attendance list onto your own certificate design, one PDF per person named after them.
Filling the same form many times
A registration, consent or order form filled once per row of a spreadsheet, flattened if the values should stay fixed.
Personal letters and cards
Letters, invitations or place cards with the name and address of each recipient, as separate files or one file to print.
Frequently Asked Questions
How do I mail merge from Excel into a PDF?+
Choose the PDF (or a picture of the design) as the template, open the Excel file or paste its cells, and point each column at a form field or a text box on the page. Select Make PDFs and you get one PDF per row in a ZIP, or all rows in one PDF.
Can I fill a fillable PDF form from Excel for many people at once?+
Yes. Fields are matched to columns with the same name, checkboxes are ticked from yes/1/x, and each row becomes its own filled copy of the form. Tick Make the filled fields part of the page if the values should not be edited later.
How do I make certificates with different names from a list?+
Use your certificate as the template (PDF, PNG or JPG), tap the name line to add a box, and type {{Name}} in it. Long names are made smaller to fit the line, and the preview shows any row before you run all of them.
Is my spreadsheet uploaded anywhere?+
No. The template, the rows and the finished PDFs stay in your browser on this device. Analytics record which button was used and whether the run worked, never file names, column names or cell values.
Can each PDF be named after the person?+
Yes. Put column names in braces in File names, for example {Name}-{ID}. Characters that file systems refuse are replaced, and repeated names get -2, -3 so no file overwrites another in the ZIP.
Does it work with Japanese, Chinese, Korean or Arabic names?+
Yes, as real text: the matching Noto font is embedded for the characters used, and Arabic is joined and set right to left. Bengali, Thai and Hebrew cannot be drawn yet, and the check before the run tells you if your list contains them.