How-to guide

How to mail merge certificates from Excel (Word, Canva, Google Slides or free)

To mail merge certificates in Word, keep the names in an Excel sheet with a header such as Name, open your certificate in Word, go to Mailings → Start Mail Merge → Letters, then Select Recipients → Use an Existing List and pick the sheet. Click the name line, choose Insert Merge Field → Name, check a few people with Preview Results, and finish with Finish & Merge → Edit Individual Documents. You get one Word file with a page for each person. The step most people get stuck on is saving each certificate as its own PDF, because Word has no button for it. Below are the honest ways to do that, plus Canva Bulk Create, Google Slides, and a free generator that makes every certificate as a separate PDF in one ZIP, with no install.

Updated · Free · No install · Works with your own WhatsApp

Which way to mail merge certificates: time, cost and limits

Every route below gives you certificates with different names. They differ in how long they take, whether they cost anything, and whether you end up with one big file or one file per person. Times are for about 100 names once the design is ready.

Ways to make multiple certificates with different names
MethodTime for ~100 namesCostOne PDF per person?Limits
Word mail merge (Microsoft 365, Windows or Mac)15–30 min the first timeIncluded with WordNo: one combined file, then split itDesktop Word only; Word for the web and phone apps have no mail merge
Word + Merge Tools add-in or a macro20–40 min to set up, then minutesFree download / your timeYes, named after each personWindows desktop Word; you allow macros or an add-in
Google Slides + Autocrat (Sheets add-on)20–30 minFreeYes, saved to Google DriveNeeds Google permissions; large lists run in parts
Canva Bulk Create10–15 minPaid Canva plan (Pro, Teams and up), or Canva for Education / NonprofitsNo: one PDF with all pages, or a ZIP of imagesDesktop only, up to 300 rows at a time
PowerPointSlow (copy slide by slide)Included with OfficeNoNo mail merge built in; use Word or an add-in
Free certificate generator (this site)2–5 minFree, no login, no watermarkYes: a ZIP with a PDF, JPG or PNG per person, named after themIts own designs (with your logo), up to 2,000 names per list; works on a phone
Rapid Sender (your own design, sent on WhatsApp)5 min to set up, then it sends50 messages free, then from ₹149 for 250Each person gets their own copy in their WhatsApp chatNeeds a phone number column; about 100 sends per 25–35 min

Just need the certificates, fast and free? Open the free certificate generator

Mail merge certificates in Word from Excel (Microsoft 365)

These are the menu names in Word for Microsoft 365, Word 2021 and Word 2024 on Windows. Word for Mac has the same Mailings tab with the same buttons. Word for the web (in the browser) and the Word phone app cannot do a mail merge, so use a computer.

  1. 1

    Make the Excel sheet

    Put the names in the first sheet, with a header row on top: Name in A1, and other columns if you need them, such as Course, Date or Rank. One row per person, no blank rows, no merged cells. Save the file and close it: Word often fails to connect, or shows an empty list, while the workbook is open in Excel.

  2. 2

    Set up the certificate in Word

    Open your design, or start from File → New and search “certificate”. For a landscape certificate use Layout → Orientation → Landscape. If the design is a picture, add it with Insert → Pictures → This Device, then Picture Format → Wrap Text → Behind Text, and stretch it to the page edges. Leave the name line empty.

  3. 3

    Start the merge

    Go to the Mailings tab → Start Mail Merge → Letters. (Letters is the right type for certificates: one page per person.)

  4. 4

    Connect the Excel sheet

    Mailings → Select Recipients → Use an Existing List…, pick your Excel file, choose the sheet (for example Sheet1$) and keep “First row of data contains column headers” ticked. To leave someone out, use Edit Recipient List and untick them.

  5. 5

    Insert the name

    Click where the name goes, then Mailings → Insert Merge Field → Name. You will see «Name». Select it and set the font, size and colour as you want the names to look, and centre the line. Add «Course», «Date» and others the same way.

  6. 6

    Preview a few people

    Click Preview Results and use the arrows to step through the list. Check the longest name: Word does not shrink text to fit, so if it wraps onto two lines, choose a smaller size for the whole field.

  7. 7

    Finish the merge

    Mailings → Finish & Merge → Edit Individual Documents… → All → OK. Word opens a new document (usually called Letters1) with one certificate per page. Choose Print Documents instead if you are printing on paper.

  8. 8

    Save as PDF

    In the new document, File → Save As → choose PDF as the file type (or File → Export → Create PDF/XPS). This gives one PDF with every certificate. To get one PDF per person, see the next section.

Try it with your own list

Upload an Excel or CSV file, write your message and see exactly how it looks before anything is sent.

Get the Excel sheet right (the problems that show up on the certificate)

  • Dates come out as 11/19/2026 or 46345. Click the date field, press Alt+F9 to see its code, change it to { MERGEFIELD Date \@ "d MMMM yyyy" }, then press Alt+F9 again and update with F9. It now shows 19 November 2026. Or simply type the date as text in Excel, like 19 November 2026.

  • Names in ALL CAPS or all small letters: add a column with =PROPER(A2) in Excel, fill it down and merge that column. Check names like McDonald or initials afterwards.

  • First and last name in two columns: add a column with =A2&" "&B2, or insert both merge fields with a space between them.

  • Find the longest name before you design: a helper column with =LEN(A2), sorted largest first, shows which name to test in the preview.

  • Hindi, Gujarati, Marathi, Tamil and other scripts merge fine from an .xlsx file. Pick a font that has that script, such as Nirmala UI on Windows. If you use a CSV, save it as CSV UTF-8, or the names turn into question marks.

  • Roll numbers or certificate numbers losing their leading zeros: format that Excel column as Text before typing, or write them like RS-2026-0001.

  • Got the names from a Google Form? Open the responses in Google Sheets and use File → Download → Microsoft Excel (.xlsx), then connect that file.

How to save each mail merge certificate as a separate PDF

Word’s mail merge has no “one PDF per record” option. Edit Individual Documents gives one long document, and Save As PDF gives one long PDF. That is fine for printing, but not when every participant needs their own file. These are the honest options, from quickest to most technical:

  • Split the combined PDF. Save the merged document as one PDF, then split it every 1 page. Adobe Acrobat (paid) does this under Organize Pages → Split, and free desktop tools such as PDF24 Creator on Windows do it offline. The catch: files come out numbered (1, 2, 3…) in the order of your sheet, not named after the person, so renaming 100 files is the slow part. Avoid free online splitters for student or staff lists, since your file is uploaded to their server.

  • Save them one by one. In the merged document (Letters1), click on a person’s page, then File → Save As → PDF, press Options… and choose Page range → Current page (Word for Windows), and type their name as the file name. Realistic for 10 or 15 people, painful beyond that.

  • Use the Merge Tools add-in. Word MVP Doug Robbins offers a downloadable add-in at mergetoolsaddin.com with a “Merge to individual documents” utility that saves a Word or PDF file per record, named from a column in your sheet. It is for desktop Word on Windows. Column headers must be letters and numbers only (no spaces or symbols, such as FullName instead of Full Name).

  • Use a macro. If you are comfortable with VBA, a short macro can merge one record at a time and save each with ExportAsFixedFormat, naming the file from the Name field. It works, but you need to enable macros and debug it yourself.

  • Skip Word for this step. If what you really need is one file per person, the free certificate generator gives you a ZIP with a PDF for each person, already named after them, in a couple of minutes. If you need each person to receive their file, Rapid Sender sends each one their own copy on WhatsApp (see below), so you never handle the separate files at all.

Bulk certificates in PowerPoint

PowerPoint has no mail merge, which is why “bulk certificate in PowerPoint” searches end in forum threads. You have three practical choices. Design the certificate in PowerPoint, save the slide as a picture (File → Save As → PNG) and use it as the background of a Word mail merge as above. Or upload that PNG or a PDF of the slide to Rapid Sender and place the name box on it. Or use a paid PowerPoint add-in made for merges. Copying the slide 100 times and typing each name is the slowest route and the one where spelling mistakes creep in.

Google Slides or Google Docs: the Autocrat route

Google Slides and Docs have no mail merge of their own either, but free add-ins fill the gap. The best known is Autocrat, a Google Sheets add-on: you make the certificate in Slides (or Docs) with placeholders like <<Name>>, keep the names in a Google Sheet with a column called Name, then in the sheet open Extensions → Autocrat → Launch and create a job. You pick the template, match each <<tag>> to a column, choose PDF as the output, set the file name (for example <<Name>> Certificate) and a Drive folder, and run it. Each person gets their own PDF in Drive, and it can email them too.

Things to know: the add-on asks for access to your Drive and Gmail, big lists are processed in batches because Google limits how long an add-on can run at once, and free Gmail accounts can only send a limited number of emails a day from add-ons. Other certificate add-ons in the Google Workspace Marketplace work in a similar way, usually with a small free tier and paid plans, so check what each one asks to access before you install it.

Canva Bulk Create for certificates (needs a paid Canva plan)

Canva Bulk Create is the easiest of the design tools, but it is not on the free Canva plan. Canva lists it for Canva Pro, Teams, Business and Enterprise, plus the free Canva for Education and Canva for Nonprofits programmes, and only on the desktop (computer), not the phone app.

  1. 9

    Open your certificate design

    Pick a certificate template and type a placeholder name like “Participant Name” where the name goes.

  2. 10

    Open Bulk Create

    In the left panel, open Apps and choose Bulk create. Choose Upload data and select your CSV or Excel file (or Enter data manually for a short list). Google Sheets need to be downloaded as CSV or .xlsx first.

  3. 11

    Connect the name

    Right-click the placeholder name → Connect data → choose the Name column. Connect any other columns the same way, then click Continue.

  4. 12

    Generate

    Choose the rows (up to 300 at a time) and click Generate. Canva makes a new design with one page per person.

  5. 13

    Download

    Share → Download. A PDF gives one file with all the pages; PNG or JPG gives a ZIP with one image per page, numbered rather than named. For separate PDFs you still need to split the file.

The faster way: every certificate as its own PDF in one ZIP (free)

If you do not already have a Word or Canva design you must use, the free certificate generator skips the mail merge completely and works on a phone too. Everything happens in your browser, so the names are never uploaded.

  1. 14

    Pick a design

    Appreciation, participation, completion, merit, winner, webinar, sports or student of the month. Add your school or company logo if you like.

  2. 15

    Write the details once

    Title, the line above the name, the description, organisation, date and up to two signatories.

  3. 16

    Add the names

    Paste a list (one name per line) or upload your Excel, CSV or Google Sheets download and pick the name column. Long names are made smaller to fit automatically.

  4. 17

    Download the ZIP

    Press “All as ZIP” and choose PDF, JPG or PNG. You get one file per person, numbered in list order and named after them (for example 01 - Priya Shah.pdf), for up to 2,000 names per list. No watermark and no login.

Make all your certificates in a few minutes: Free bulk certificate generator

Keep your own design and send each certificate on WhatsApp

Making the files is only half the job; someone still has to get each certificate to each person. Most participants, students and parents in India check WhatsApp long before email. Rapid Sender, a bulk sender for WhatsApp, does the merge and the delivery in one go, from your own WhatsApp number. It is an independent tool, not made by WhatsApp or Meta.

You can use any design, including the one you made in Word, Canva or PowerPoint: export it once without a name (as a PDF, JPG or PNG), upload it with a sheet of names and phone numbers, and drag a name box onto the name line. Each person gets their own copy, with their own name printed on it, in their WhatsApp chat, with a message that greets them by name.

  1. Participation

    Hi {{name}}, thank you for taking part. 🎉 Your certificate of participation is attached. We hope to see you at the next event!

  2. Course completion

    Congratulations {{name}}! 🎓 You have successfully completed the course. Your certificate is attached – feel free to share it.

  3. School

    Dear {{name}}, well done! Please find your certificate attached. We are proud of your effort this year. 🌟

  4. Staff award

    Dear {{name}}, thank you for your hard work this year. Your certificate of appreciation is attached. Congratulations from the whole team! 🏆

  5. Hindi

    नमस्ते {{name}} जी, भाग लेने के लिए धन्यवाद। आपका प्रमाण पत्र (certificate) साथ में भेजा गया है। शुभकामनाएँ! 🎉

  6. Gujarati

    નમસ્તે {{name}}, ભાગ લેવા બદલ આભાર. આપનું પ્રમાણપત્ર (certificate) સાથે મોકલ્યું છે. શુભેચ્છાઓ! 🎉

  1. 18

    Export a blank certificate

    From Word, File → Save As → PDF before you insert any merge field. From Canva, download the design as PDF or PNG with the name line empty.

  2. 19

    Prepare the sheet

    Columns for name and phone (with or without +91, spaces are fine), plus anything else to print, such as course or rank.

  3. 20

    Upload and place the name

    Open rapid-sender.com, upload the sheet, attach the certificate, drag a text box onto the name line and link it to the name column. Pick the font, size and colour, including Hindi, Gujarati or Marathi fonts, and check the longest name in the preview.

  4. 21

    Write the message, test, send

    Use one of the messages below, link WhatsApp with the QR code or a pairing code, send a test to yourself, then send to the list. The report shows who received theirs; fix wrong numbers and send again to only those left.

Already have the certificates and only need to send them? Send certificates on WhatsApp

Sending a whole batch with Rapid Sender: cost and time

The first 50 messages on each WhatsApp number are free, with every feature and no watermark, which covers a class or a small workshop. Bigger lists use one-time credit packs from ₹149 for 250 messages, with no monthly plan. Personalised certificates go out at about 100 every 25 to 35 minutes, so keep the tab open, or sign in and use “Send later” to pick a time. Send only to people who took part and gave you their number.

Frequently asked questions

How do I mail merge certificates in Word from Excel?

Put the names in Excel with a header row (Name), save and close it. In Word, open the certificate and use Mailings → Start Mail Merge → Letters, then Select Recipients → Use an Existing List and choose the file. Click the name line, Insert Merge Field → Name, check with Preview Results, and finish with Finish & Merge → Edit Individual Documents.

How do I save each mail merge certificate as a separate PDF?

Word has no built-in option for this. Either save the merged document as one PDF and split it every 1 page (files come out numbered, not named), save each record by hand, use the Merge Tools add-in or a VBA macro on Windows, or use the free certificate generator, which gives one PDF per person, named after them, in a ZIP.

No. Bulk Create is part of Canva Pro, Teams, Business and Enterprise, and of the free Canva for Education and Canva for Nonprofits programmes. It works on the desktop only and takes up to 300 rows at a time.

PowerPoint has no mail merge. Save your slide as a PNG and use it as the background of a Word mail merge, upload it to Rapid Sender and place the name on it, or use a paid PowerPoint merge add-in.

Use the free certificate generator: pick a design, write the details once, paste the names or upload an Excel sheet, and download a ZIP with a PDF, JPG or PNG for each person. No login and no watermark, up to 2,000 names per list. Google Slides with the free Autocrat add-on also works if you prefer Google Drive.

Word takes the raw date from Excel. Press Alt+F9 on the field and add a format switch, for example { MERGEFIELD Date \@ "d MMMM yyyy" }, then Alt+F9 and F9 again. Or type the date as plain text in the sheet.

Not in Word: the Word phone app and Word for the web have no mail merge. The free certificate generator and Rapid Sender both work in a phone browser.

Upload one blank certificate and a sheet with names and phone numbers to Rapid Sender, place the name box, write a message with {{name}} and link your WhatsApp. Each person gets their own certificate in their chat. The first 50 messages are free.

Ready to send your message?

Upload your list, write your message and connect your WhatsApp. It is free and takes a few minutes.

Start sending