# Generate certificates from an Excel list, one per person

> Markdown version of https://stella.sh/how/printing-labels/make-certificates-from-excel for agents and LLMs.
> Make a certificate for everyone who passed, each with their own name and completion date, from your results spreadsheet: Word's mail merge, or Stella (stella.sh).

In Word, design one landscape certificate, start a Letters mail merge with your spreadsheet as the recipient list, filter it to the people who passed, insert the name and date fields, and finish the merge into one document. Names stored as “Last, First” and Excel dates need fixing first. Stella (stella.sh) reads the results sheet on your computer and writes one PDF with a certificate per person who passed.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 22 certificates in about 75 seconds. Checked afterwards against an answer key written before the run: one landscape page for each person who passed, nobody else, the name as the main text written First Last, the course name and each person's own completion date on every page, no extra pages, and the spreadsheet unchanged. The course, people and scores are made up for this run. The work is sped up 3×.

Video (41 s): https://stella.sh/media/proofs/printing-labels/make-certificates-from-excel/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. The first aid course results spreadsheet is in Documents.
- 0:02 The prompt: a landscape certificate for everyone who passed, with name, course and date.
- 0:10 Stella replies: one page per person who passed, in a single PDF next to the spreadsheet.
- 0:15 Reading the results and making the certificates, sped up 3×.
- 0:27 Done: 22 certificates; three fails and one incomplete left out, each named.

What Stella does:

1. Finds `First aid course results.xlsx` in Documents, with the course name and instructor in rows above the table
2. Keeps the 22 people marked Pass, and leaves out three fails and one Incomplete, naming each and why
3. Turns names stored as “Last, First” round, and reads each person's own completion date from the Excel dates
4. Designs a landscape certificate with the name as the largest text, the course “Community First Aid & CPR (Level 1)”, the date, the session line and a signature space for the instructor
5. Writes all 22 into `First aid certificates.pdf` next to the spreadsheet, one per page

## The prompt to paste

```text
Make a certificate of completion for everyone who passed the first aid course, using the results spreadsheet in my Documents. Landscape, one per page, with their name, the course name and the date they finished.
```

## Make them yourself

1. **Tidy the spreadsheet.** Put the table's headers in row 1 (delete title rows above it). If names are “Last, First”, add a column with `=TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)` and fill it down. Filter the Result column to Pass.
2. **Design one certificate in Word.** New document, Layout, Orientation, Landscape. Lay out the title, a placeholder line for the name in a large font, the course name, a date line and a signature line. Keep it to one page.
3. **Merge the names and dates.** Mailings, Start Mail Merge, Letters. Select Recipients, Use an Existing List, pick the spreadsheet, and in Edit Recipient List filter to Pass. Insert the name field and the date field. To stop dates showing as 10/17/2026 0:00, press Alt+F9 and add `\@ "MMMM d, yyyy"` inside the date field.
4. **Finish and save as PDF.** Finish & Merge, Edit Individual Documents, All. Page through to check long names fit, then save as PDF. Each record lands on its own page.

## Where Stella stops

- The design is clean and simple. For your organisation's look, give Stella a template, a logo file or a description of the style.
- It follows the sheet: if someone's result or date is wrong there, the certificate is wrong too. Stella lists who was left out and why so you can check.
- Names, results and dates go to the AI model you use in Stella while it reads the sheet. The certificates are made on your computer.
- It doesn't sign or print them unless asked. The signature line is left blank for the instructor.
- Recorded on Linux, where Stella used Python, a small spreadsheet library it installed, and a browser already on the computer to write the PDF. On a Mac or Windows PC it may install Python first, which wasn't recorded.

## Questions

**Can I use my own certificate template?**
Yes. Give Stella a Word, PowerPoint or PDF template and say where the name and date go; it fills in a copy per person.

**Can it make a separate PDF for each person to email?**
Yes, ask for one file per person named after them. Stella doesn't send emails unless you ask it to with your own email set up.

**Can it add a certificate number or QR code?**
Yes, numbered in order or from a column. For QR codes on their own, see [make QR codes in bulk](https://stella.sh/how/printing-labels/make-qr-codes-in-bulk).

**Is this the same as a mail merge?**
It gives the same result as a Word mail merge without the setup. For letters, see [mail merge from Excel to Word](https://stella.sh/how/documents/mail-merge-excel-to-word).

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft Support: Use mail merge to send bulk email, letters, labels and envelopes](https://support.microsoft.com/en-us/word/use-mail-merge-for-bulk-email-letters-labels-and-envelopes), [Microsoft Support: Create and print mailing labels for an address list in Excel](https://support.microsoft.com/topic/d9484315-5123-48ae-bc58-2e8dcf271252).

## Related problems

- [Mail merge from Excel to Word, with a separate file for each person](https://stella.sh/how/documents/mail-merge-excel-to-word.md)
- [Make name tags from a registration list](https://stella.sh/how/printing-labels/make-name-tags-from-a-list.md)
- [Change dates in Excel from US to UK when they come out wrong](https://stella.sh/how/pdf-excel/fix-dates-in-excel.md)
- [Print address labels from Excel on Avery 5160 sheets](https://stella.sh/how/printing-labels/print-address-labels-from-excel.md)
- [Print envelopes from an Excel guest list, one per household](https://stella.sh/how/printing-labels/print-envelopes-from-excel.md)
- [Make a QR code for every link in a spreadsheet, in bulk](https://stella.sh/how/printing-labels/make-qr-codes-in-bulk.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
