Making certificates in bulk from a list of names

Course completions, training records, awards, membership cards. The design is done and approved; what is left is putting 140 different names on it and sending each person their own file. That last part is where the afternoon goes.

Get the list right first

Almost every bad batch traces back to the spreadsheet, and it is much cheaper to fix there than to reprint. Before you generate anything:

• One row per certificate, one column per variable. Name, course, date, certificate number. First row is the column names.
• Check the names as they will be printed. Capitalisation, accented characters, double-barrelled surnames. A certificate with a mangled name gets reprinted, always.
• Give every row something unique. Two people called Maria Santos will overwrite each other if the file name is just the name. A certificate number column solves it and is worth having anyway.
• Format dates in the spreadsheet, not the template. Put the finished text — 14 March 2026 — in a column. Merge fields have a habit of turning that into 3/14/2026.

Using Excel as the certificate generator

A bulk certificate generator is really just two files: the design, and the list of names. Excel holds the names; the design stays in Word or PowerPoint. Nothing else is needed.

Word or PowerPoint for the design

Use whichever you designed it in. PowerPoint is the more common choice for certificates — landscape by default, easy to place a border, a logo and a signature image exactly where you want them. Word is fine if the layout is simple.

Wherever text must change per person, type a placeholder: {{Name}}, {{Course}}, {{Date}}, {{CertNo}}. Match the column names in your list and the two line up on their own.

One layout warning specific to certificates: names vary in length far more than people expect. Set the name text box wide, centred, and check the longest name in your list before running the batch, or it will wrap onto two lines on exactly the certificates you did not check.

Why mail merge is awkward here

Word's mail merge can put the names in, but it produces a single document with 140 pages. You still have to cut it into 140 files and name each one, which is its own problem. And PowerPoint has no mail merge at all — if your certificate is a .pptx, that route is closed before it starts.

Generate them one file each

Docs from Excel works from the list alone: upload it, type “completion certificates for a first-aid course”, and you get one certificate per person, named from whichever column you choose — the recipient's name, or the certificate number. Already designed a .docx or .pptx you like? Upload that and it is used as-is.

Choose PDF as the output and they are ready to email or send to a print shop without anyone being able to edit the text on the way. There is a certificate template among the worked examples on the home page if you want to see the shape of one before making your own.