Skip to content

PDF Mail Merge From Excel or CSV

Turn one PDF and a list into a PDF for every row: certificates with each name, letters with each address, invoices with each amount. Fields are filled in the template’s own font, and a centered name stays centered.

Mail merge

Your PDF

Choose your settings

Settings appear once you add a PDF.

Save as

Ctrl + Enter runs it ·

Bytes sent anywhere: 0 B

Keyboard shortcuts

Ctrl K
Search all tools
Ctrl V
Paste files to add them
Ctrl Enter
Run the tool
?
Show this list
Esc
Close this list or the search
  • Excel, CSV or pasted rows The first row names the columns. Each field in the template is matched to its column automatically.
  • The template’s own font Each value is written into the page in the template’s font, size and color, not pasted on top in a box.
  • Named the way you file them Each PDF is named by a column you choose, such as the name, and the set comes as one ZIP.

How to do a mail merge into a PDF

  1. Add your PDF: Add your template PDF. Fields written like {{Name}}, <<Name>> or [[Name]] are found for you; on a finished design, pick the sample text to replace instead, such as “John Smith”.

  2. Check the settings: Add your list: an Excel or CSV file, or rows pasted from a spreadsheet. Check that each field points at the right column and choose which column names the files.

  3. Save the result: Press Make the PDFs. Every row becomes its own PDF (all in one ZIP), or choose All in one PDF to print the whole set at once.

Settings and tips

Tips for a clean mail merge

  1. Write fields exactly like the column names, such as {{Name}} for a column called Name, and they are matched for you.
  2. On a design you can’t change, type a sample name in the template (say “John Smith”) and replace that text instead.
  3. Keep each field on its own line in the design: a centered name stays centered however long it gets.
  4. Check the “Row 1 will read” line before you run it: it shows the first row exactly as it will go in.
  5. Exported PDFs often keep only the letters the design uses. When you export, embed the whole font (in Word: Embed fonts with only the characters used turned off), so every name is set in it.
  6. Need the same change in many existing PDFs instead? Find and Replace in PDF does that.

Good to know

Why mail merge straight into a PDF?

Certificates, offer letters and invoices are usually designed once, in Canva, InDesign or Word, and exported as a PDF. The classic mail merge lives in Word and makes Word documents, so the design has to be rebuilt there, and it rarely looks the same afterwards. Here you start from the finished PDF: the design stays exactly as it is, and only the fields change.

Each value is written into the page in the template’s own font, size and color, the way the original text was set, so a name on a certificate looks printed, not pasted on. And because it all runs in your browser, the list of names, addresses or amounts is never uploaded anywhere.

What people make with a PDF mail merge

  • Course and event certificates

    One design and a list of participants: a certificate for each, saved under each person’s name.

  • Offer letters and HR letters

    Name, role, salary and start date filled into the company letter for every new joiner.

  • Invoices and receipts

    A receipt template filled with each customer’s name, amount and date from a spreadsheet export.

  • Name badges and place cards

    Choose All in one PDF to print every badge in one go.

  • School report covers and admit cards

    Student name, roll number and class from the class list.

Worth knowing

  • Each field is filled on its own line. A long value isn’t wrapped onto the next line, so keep fields such as addresses to one line each, or split them into Address 1 and Address 2.
  • The template needs real text. A scanned certificate has no text to replace: run it through OCR PDF first, or rebuild the template.
  • Embedded fonts often carry only the letters the template uses. A letter the font lacks is set in a matching substitute, and the report says how many.
  • Up to about 500 rows works smoothly on a laptop; a very large list is faster split into batches.
  • Fields inside fillable form boxes aren’t filled. Use Fill PDF Form for those.

Why it doesn’t upload

A mail-merge list is a list of people: names, addresses, amounts, sometimes ID numbers. Online merge services take the list and the template onto their servers. Here both are read inside this browser tab and every PDF is written on your device, so the list never leaves it.

Check it in your browser’s Network tab

Questions

How do I mail merge into a PDF?

Add a PDF with fields such as {{Name}} (or a sample name to replace), add your Excel or CSV list, check the columns and press Make the PDFs. You get one PDF per row in a ZIP, or all of them in one PDF. It’s free, with no sign-up and no upload.

Can I make certificates from an Excel list?

Yes. Design the certificate once, export it as a PDF with {{Name}} where the name goes (or a sample name), and add your Excel list here. Each certificate gets its name in the certificate’s own font, kept centered, and is saved under that person’s name.

Do I need Word or Acrobat for a PDF mail merge?

No. Word’s mail merge makes Word documents, and Acrobat has no merge from a spreadsheet. Here you start from the PDF itself, so the design stays exactly as it is and only the fields change.

What if my PDF has no {{fields}}?

Press Replace other text on the page and type the text that changes from copy to copy, such as the sample name “John Smith” or the date, then pick its column. That text is replaced in every copy.

Is my list uploaded?

No. The template and the list are read inside this browser tab, and every PDF is made on your device. Nothing is sent to a server.

More edit & text tools

All edit & text tools