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 WhatsAppWhich 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.
| Method | Time for ~100 names | Cost | One PDF per person? | Limits |
|---|---|---|---|---|
| Word mail merge (Microsoft 365, Windows or Mac) | 15–30 min the first time | Included with Word | No: one combined file, then split it | Desktop Word only; Word for the web and phone apps have no mail merge |
| Word + Merge Tools add-in or a macro | 20–40 min to set up, then minutes | Free download / your time | Yes, named after each person | Windows desktop Word; you allow macros or an add-in |
| Google Slides + Autocrat (Sheets add-on) | 20–30 min | Free | Yes, saved to Google Drive | Needs Google permissions; large lists run in parts |
| Canva Bulk Create | 10–15 min | Paid Canva plan (Pro, Teams and up), or Canva for Education / Nonprofits | No: one PDF with all pages, or a ZIP of images | Desktop only, up to 300 rows at a time |
| PowerPoint | Slow (copy slide by slide) | Included with Office | No | No mail merge built in; use Word or an add-in |
| Free certificate generator (this site) | 2–5 min | Free, no login, no watermark | Yes: a ZIP with a PDF, JPG or PNG per person, named after them | Its 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 sends | 50 messages free, then from ₹149 for 250 | Each person gets their own copy in their WhatsApp chat | Needs 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
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
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
Start the merge
Go to the Mailings tab → Start Mail Merge → Letters. (Letters is the right type for certificates: one page per person.)
- 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
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
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
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
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.
- 9
Open your certificate design
Pick a certificate template and type a placeholder name like “Participant Name” where the name goes.
- 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.
- 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.
- 12
Generate
Choose the rows (up to 300 at a time) and click Generate. Canva makes a new design with one page per person.
- 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.
- 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.
- 15
Write the details once
Title, the line above the name, the description, organisation, date and up to two signatories.
- 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.
- 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.
- Participation
Hi {{name}}, thank you for taking part. 🎉 Your certificate of participation is attached. We hope to see you at the next event!
- Course completion
Congratulations {{name}}! 🎓 You have successfully completed the course. Your certificate is attached – feel free to share it.
- School
Dear {{name}}, well done! Please find your certificate attached. We are proud of your effort this year. 🌟
- Staff award
Dear {{name}}, thank you for your hard work this year. Your certificate of appreciation is attached. Congratulations from the whole team! 🏆
- Hindi
नमस्ते {{name}} जी, भाग लेने के लिए धन्यवाद। आपका प्रमाण पत्र (certificate) साथ में भेजा गया है। शुभकामनाएँ! 🎉
- Gujarati
નમસ્તે {{name}}, ભાગ લેવા બદલ આભાર. આપનું પ્રમાણપત્ર (certificate) સાથે મોકલ્યું છે. શુભેચ્છાઓ! 🎉
- 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.
- 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.
- 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.
- 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
Is Canva Bulk Create free?
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.
Can I make bulk certificates in PowerPoint?
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.
How do I make multiple certificates with different names for free?
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.
Why does the date show wrong in my mail merge certificate?
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.
Can I mail merge certificates on my phone?
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.
How do I send each certificate to its participant on WhatsApp?
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