Generate certificates from an Excel list, one per person
A results sheet of 26 people as 22 landscape certificates, only the ones who passed.
A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 13 s in real time.
The short answer.
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.
Stella does this on Windows, Mac and Linux.
What happened.
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×.
How Stella does it.
- Finds
First aid course results.xlsxin Documents, with the course name and instructor in rows above the table - Keeps the 22 people marked Pass, and leaves out three fails and one Incomplete, naming each and why
- Turns names stored as “Last, First” round, and reads each person's own completion date from the Excel dates
- 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
- Writes all 22 into
First aid certificates.pdfnext to the spreadsheet, one per page
The prompt.
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.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
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.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.
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.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 it 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.
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.
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.
- Microsoft Support: Use mail merge to send bulk email, letters, labels and envelopes
- Microsoft Support: Create and print mailing labels for an address list in Excel
Checked against these sources on 14 November 2026.