4 ways to create certificates in bulk from Excel

If you already have names, dates, and course details in Excel, the hard part is not the spreadsheet. It is turning every row into a certificate without copy-pasting.

PowerPoint has never had a native mail merge button. That gap is why so many teams end up with a workaround: Word, VBA macros, Canva, or a dedicated merge tool. The right choice depends on where your design already lives, how many certificates you need, and whether you want editable PowerPoint files at the end.

Here is a practical comparison of four common approaches.

Quick comparison

Method	Best when	Local?	Typical limit	Output
Word mail merge	You can live with a Word/PDF certificate and a one-page layout	Yes	Practical, not a hard cap; awkward for multi-page certificates	Word / PDF
PowerPoint + VBA	You can write or maintain macros and must stay on the desktop	Yes	Whatever your script and Office install can handle	PPTX / PDF
Canva Bulk Create	You already design in Canva	No (Canva cloud, paid plans, desktop editor)	300 rows and 150 columns per Bulk Create batch	Canva designs / PDF
PPTXMailMerge	You already have a PowerPoint template and an Excel file	Processing happens on our servers; files are not stored	Hundreds of slides in one go	Editable PPTX, one file or one file per person

1. Word mail merge

Free and native, but awkward if the original design is in PowerPoint.

Word is the only Microsoft Office app with a built-in mail merge. That is why this method is still recommended in Microsoft-adjacent forums and by PowerPoint MVPs: export the slide as a picture, drop it into Word, then merge Excel data on top.

If your certificate was designed in PowerPoint, the workflow looks like this:

Create the design in PowerPoint and leave empty space where Excel values should appear.
Save that single slide as an image (PNG or JPG).
Create a Word document and insert the image as a background (typically with wrap set to Behind text).
Crop or resize the page so it matches the image.
Connect Word to your Excel file, insert merge fields, and complete the merge.

Pros

Built into Word, so there is no extra software to buy.
Everything stays on your computer.
Fine for a simple, one-page certificate that you will print or save as PDF.

Cons

You flatten a live PowerPoint design into a background image. Logos, fonts, and spacing are no longer native slide objects.
It is a lot of setup if you already designed in PowerPoint.
It is effectively limited to a single page. If each Excel row should become two slides per person (certificate plus transcript, for example), Word mail merge gets much harder.
The result is a Word document, not an editable PowerPoint file.

Use Word mail merge when the certificate is simple, local-only processing is a hard requirement, and you do not mind leaving PowerPoint behind.

2. PowerPoint + VBA

Flexible and local, but it requires code and macros.

PowerPoint still has no mail merge ribbon. The classic desktop workaround is a VBA macro that opens Excel, loops through rows, duplicates a template slide, and replaces placeholder text.

You can do almost anything this way, as long as you know how to code: one slide or many, one combined deck or a file per person, extra logic for grades, images, or file names. Ready-made snippets exist for specific designs. The catch is that those scripts are usually hardcoded to one Excel layout and one PowerPoint template. Adding a new column in Excel and a matching field on the certificate often means opening the VBA editor and changing the script.

Today you can ask an LLM to generate or regenerate that VBA. That helps with the first draft. You still have to place the code in a macro-enabled file (.pptm), enable macros, test it against your actual template, and keep it working after Office updates.

Pros

Stays on your machine.
Can be tailored to almost any certificate workflow.
No need to rebuild the design in Word or Canva.

Cons

Requires VBA knowledge, or time to adapt generated code.
IT policies often block macros. Sharing a .pptm file across a team is messy.
Scripts tend to break when someone adds a field, opens another workbook, or upgrades Office.
Ready-made code rarely survives a template change without a developer (or an LLM plus a debugging session).

We wrote a longer take on this in Why PowerPoint Mail Merge with VBA is a Maintenance Nightmare. VBA is a reasonable choice for a technical person producing certificates on an air-gapped PC. It is a weak choice if non-technical staff need to run the process every month.

3. Canva Bulk Create

Very good if you are willing to design and work in Canva. If your stack is already Canva and you mostly produce certificates, Bulk Create is a natural fit. You connect a spreadsheet to a Canva template, map columns onto text boxes or image frames, and generate a page (or a separate design) per row.

Canva’s own help confirms that Bulk Create accepts Excel (.xlsx) and CSV files. You can also type data in by hand or pull it from Canva Sheets.

Official limits worth knowing

According to Canva’s Bulk Create help and Bulk Create vs Data Autofill:

Bulk Create is available on Canva Pro, Teams, Business, Enterprise, Education, and Nonprofits — desktop only, not on the free plan and not in the mobile editor.
A Bulk Create batch supports up to 300 rows and 150 columns. Larger lists have to be split.
You can connect up to 150 data fields.
Only one media item per cell is used.
Image URLs are not supported. Links are treated as plain text. Photos must be embedded in the sheet or taken from your Canva library.
For a multi-page template, you need to connect data on each page.

Canva Sheets can hold more data than the Bulk Create app itself; Canva notes that the 300-row cap applies to the Bulk Create app, not to Sheets in general.

Practical cons

You leave PowerPoint. Reusing an existing .pptx certificate means recreating it in Canva.
Batches over about 50 certificates often make the editor feel slow, and larger runs are more likely to need splitting, re-previewing, or downloading in chunks.
Output lives in Canva. You get Canva designs or exported PDFs, not native PowerPoint files you can tweak slide-by-slide in Office.

Choose Canva when the design starts in Canva, volumes stay in the low hundreds, and you are happy to pay for a Pro-level plan.

4. PPTXMailMerge

The best fit when you already have PowerPoint plus Excel and want to keep that workflow.

You keep the certificate you already designed. You keep the Excel file you already maintain. Map columns to placeholders such as {{name}}, {{course}}, and {{date}}, then generate.

That is the whole job: reuse the design, reuse the data, map one to the other. You can produce several hundred slides in one go. If a name is too long or a date format looks off, the result is still an editable PowerPoint file (or files) you can fix without rebuilding a merge. A single switch gives you one PowerPoint file per Excel row instead of one giant deck.

For certificates, start with the PowerPoint Certificate Generator. The same merge also works in the generic Excel to PowerPoint tool if you need extra slides, tables, charts, or QR codes.

Pros

Reuse the PowerPoint template and Excel data you already have.
Multi-slide templates work naturally: each Excel row can fill one slide or several.
Output stays editable .pptx, so you can still tweak a certificate after the merge.
One combined presentation, or a file per person, with optional names from Excel columns.
No Word conversion, no VBA, no Canva redesign.

Cons

You send the template and data to our servers for processing. We use those files only to generate the output. File contents are not kept: they are isolated per job and deleted when the job completes. See the privacy policy for the details.

If your certificates already live in PowerPoint and your roster already lives in Excel, this is the shortest path from spreadsheet to finished files.

Which should you use?

Stay in Word if local-only processing matters more than keeping a PowerPoint design, and each certificate is a single page.
Write VBA if you must stay fully offline, you can maintain macros, and IT will allow them to run.
Use Canva Bulk Create if you already design certificates in Canva and your batches stay within Canva’s 300-row desktop workflow.
Use PPTXMailMerge if the design is a PowerPoint file, the data is Excel, and you want hundreds of certificates — optionally one file per person — without flattening the slide to an image or maintaining a macro.

Most training teams we talk to already have both files. In that case, skip the Word detour and the VBA editor: generate the certificates from PowerPoint and Excel and download either one deck or a ZIP of individual files.