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.

The short version, whichever tool you pick:

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.

Option 1: 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.

Three things to know before you commit. It needs a paid plan (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 is two. And that naming step matters: skip it and you get a zip full of 1.pdf, 2.pdf, 3.pdf, a bad afternoon when you're emailing ninety-four people.

Option 2: Generate certificates from Google Sheets with Autocrat

If your roster is already in Google Sheets, this is the free path most people try first.

1. Design the certificate as a Google Slide.
2. Put <<Name>>, <<Course>>, <<Date>> tags where the values go.
3. In the Sheet, 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 two 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 Slide, because it is one.

Option 3: 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.

Option 4: A bulk certificate generator that designs the certificate for you

This one is ours, so read it knowing that. With SheetRender, 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 if the person running the batch is a training coordinator rather than a designer.

On cost: the free plan is 50 documents a month with a small "Made with SheetRender" footer, enough to render a handful and check the design comes out right. Ninety-four certificates won't fit in it. Starter is $19 a month for 1,500 documents with no footer, so a cohort this size uses about six percent of the allowance.

When none of these is the right tool

If your certificates need to be verifiable, with a unique ID per certificate, a public verification page, or a LinkedIn badge, none of the options above does that. That job belongs to a credentialing platform; Certifier and Accredible are the usual names there. Everything on this page produces 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: 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: try SheetRender free.

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