How to Generate Certificates in Bulk from a Spreadsheet

What every method needs first: a clean roster

Whatever tool you use, start with a spreadsheet where each row is one recipient and each column is one thing that changes per certificate:

Keep names exactly as they should be printed. Half the pain in certificate runs is cleaning "SANTOS, maria" style data after the fact.

Whichever tool you pick, the run goes like this:

1. Start from the clean roster above.
2. Pick your route by batch size and budget; the bottom line at the end maps them.
3. Build or upload the certificate design once.
4. Map each column to the spot it belongs on the certificate.
5. Run the batch, then spot-check three PDFs before sending any of them: the longest name, a name with an accent, and the last row. That's where these break.

Canva Bulk Create

The best-looking path if you already design in Canva.

1. Design one certificate.
2. Open Bulk Create and connect your data (CSV, or a spreadsheet depending on plan), then map each text field to a column.
3. In the advanced options, set the output to individual designs and set the file naming to your name column.
4. Generate the set and export.

You need a paid plan for it (Pro or Teams, though Canva's Education and Nonprofit accounts also have it), and it's desktop only. Runs cap at 300 rows, so a 94-person cohort fits in one pass and a 400-person conference takes two.

Don't skip the naming step. Without it you get a zip full of 1.pdf, 2.pdf, 3.pdf, and a bad afternoon ahead of you if you're emailing ninety-four people.

Generate certificates from Google Sheets with Autocrat

If your roster is already in Google Sheets, this is the free path most people try first. (The Google Sheets mail merge guide compares every route from a spreadsheet, if certificates are only part of your job.)

1. Design the certificate as a slide in Google Slides.
2. Put <<Name>>, <<Course>>, <<Date>> tags where the values go.
3. In Google Sheets, install the Autocrat add-on, map each tag to a column, keep the output at one file per row, and choose PDF.
4. Run the job, or trigger it on form submissions or a schedule.

It works well for small batches. The chronic complaints are quota errors and the look of the output. On bigger runs, Apps Script dies mid-batch with "Service invoked too many times" (here's what that means and how to fix it). And the look: it renders like a Google Slides slide, because it is one.

Word mail merge

Word can merge your roster into a certificate template, but it merges everything into one long document. Getting separate, well-named PDF files per person means a VBA macro or manual splitting; we walk through the macro in our mail merge splitting guide. That's fine for one cohort a year. Run it monthly and you're babysitting a macro nobody else on the team will touch.

A bulk certificate generator that designs the certificate for you

SheetRender is ours. You upload the roster plus one example certificate you already like. An old PDF works. So does a phone photo of a paper certificate. It reads the border, the crest, and the fonts off the example and rebuilds them as a template wired to your columns; you review the result, then every row renders as its own print-ready PDF. Download the batch as a zip, or email each certificate straight to its recipient.

There's no tagging step and no design tool to learn, which matters when the batch lands on a training coordinator with no design background.

Check the rebuild before the batch runs. It is a first draft of your design: a crest can come back slightly off, or a column can land in the wrong box. The AI model that reconstructs the layout also sees your column headers and a few sample rows, trainee names included, while it builds the template. If the roster can't leave your systems, use Autocrat, which keeps the merge inside your Google account.

The free plan covers 50 documents a month, each with a "Made with SheetRender" footer, so ninety-four certificates won't fit. Starter is $19 a month for 1,500 documents with no footer; a cohort this size uses about six percent of that.

When none of these is the right tool

Some certificates have to be checked later. If an employer needs to look one up by a unique ID, on a public verification page, or through a LinkedIn badge, nothing above will do it. You want a credentialing platform, and Certifier and Accredible are the names you'll see most. Every method on this page ends in a PDF, and a PDF is a picture of a claim, not proof of one.

Bottom line

• Already a Canva shop, small batches: Canva Bulk Create.
• Free and Google-native, modest batches, don't mind placeholder tags: Google Slides + Autocrat.
• Once a year, everything already in Word: mail merge plus the separate-PDF macro.
• Recurring cohorts, hundreds of names, or a certificate someone will frame: SheetRender.

For invoices or letters on the same one-file-per-row pattern, read convert a spreadsheet to PDF automatically.

Whichever you pick, run the three-PDF spot check before anything goes out. The longest name always finds the edge of the box.