Skip to main content

Find your next tool

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

PDF

Batch

Up to 2 files per run

Acroform Fields From ColumnsText Boxes On Any Pdf Or ImageCsv Xlsx PasteColumn Auto MatchShrink To FitFile Names From Columns
Batch-aware

Up to 2 files per run. Only use one run when files share the same operation.

Workflow continuity

Move into a related operation instead of re-finding the tool.

Output-ready

Download a destination-ready result and verify it before sharing.

File limits

Configured runtime limit applies.

PDF quality check before download
Inspect edited pages
Check text/annotation placement
Confirm the final file opens correctly

Natural next steps

Continue with a related tool using the same file workflow.

Supported input

PDF, PNG, JPG, JPEG, WEBP, CSV, TSV, TXT, XLSX

Output

PDF

Multiple files

Check the upload limit below

Keep your source

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.

Bulk processingZIP-ready outputWorkflow-ready

Continue with Form Filler

Bulk-ready

Finish the job after Pdf Mail Merge with a relevant MAXScanner tool, without creating a duplicate converter page.

Output: Form Filler

Best when Pdf Mail Merge is only the first step in your workflow.

Continue with Sign Pdf

Bulk-ready

Finish the job after Pdf Mail Merge with a relevant MAXScanner tool, without creating a duplicate converter page.

  1. Pdf Mail Merge
  2. Sign Pdf
Output: Sign Pdf

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 measuredVector certificate (1.3 KB)Same certificate on 3508 × 2480 px artwork (693 KB JPEG)
100 PDFs plus the combined PDF0.7 s0.8 s
Size of one row's PDF2.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 PDFs306 KB69.4 MB
One combined PDF, 100 pages54 KB745 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
TemplatePDF (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.
RowsUp to 500 per run; the first row holds the column names, or untick that and the columns are called A, B, C.
OutputOne PDF per row in a ZIP, one combined PDF, or both. Text stays real text you can select and search.
Writing systemsLatin, 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

  1. 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.

  2. 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.

  3. 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.

  4. 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.