# Make name tags from a registration list

> Markdown version of https://stella.sh/how/printing-labels/make-name-tags-from-a-list for agents and LLMs.
> Turn an event sign-up export into name badges for Avery 5395 sheets: duplicates merged, cancellations out, accents right. Word's merge, or Stella (stella.sh).

Clean the list first: delete cancellations and remove duplicate sign-ups by email, then run a label mail merge in Word with Avery US Letter 5395 Name Badges, the first name in a big font and the last name and company below. Check accented names in the preview. Stella (stella.sh) does the cleaning and the layout from the export on your computer and writes a print-ready PDF on the 5395 grid.

- 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: 37 badges on five sheets in about two and a half minutes. Checked afterwards against an answer key written before the run: US Letter pages, every confirmed person on exactly one badge inside a 5395 position, company on each, first name bigger than the company line, accented names spelled right, no cancellations, nothing printed outside the badges, names capitalised, and the CSV unchanged. The attendees and companies are made up for this run. On seven badges the company line reads “Independent” where the list said “self-employed”; Stella said so and offered to switch it back. The work is sped up 8×.

Video (46 s): https://stella.sh/media/proofs/printing-labels/make-name-tags-from-a-list/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. The Fall Summit registrations export is in Downloads.
- 0:02 The prompt: badges for Avery 5395, first name big, skip cancellations and double sign-ups.
- 0:12 Stella replies: it will lay the badges out for 5395 sheets and list who was dropped.
- 0:18 Cleaning the list and laying out the sheets, sped up 8×.
- 0:31 Done: 37 badges on 5 sheets, 3 cancellations and 3 double sign-ups left out, print at 100%.

What Stella does:

1. Reads `Fall Summit registrations.csv` in Downloads: 43 sign-ups
2. Leaves out three cancellations and merges three people who signed up twice, keeping the properly capitalised entry when one copy was typed in lower case
3. Keeps people who share a first or last name apart, since each has their own email and company
4. Lays 37 badges on five Avery 5395 sheets (8 per sheet, 2 across and 4 down), first name large, last name and company underneath, with a font that prints Zoë, Siobhán, Łukasz and Thảo correctly
5. Prints “Independent” where the sheet said “self-employed”, says so, and offers to change it or add a Speaker tag

## The prompt to paste

```text
Make name badges for everyone coming to our Fall Summit from the registrations file in my Downloads, to print on Avery 5395 sticker sheets. First name big, with their last name and company underneath. Skip anyone who cancelled, and a few people signed up twice.
```

## Make the badges yourself

1. **Clean the sign-up list.** Open the export in Excel. Filter the Status column and delete the cancelled rows. Then select the table and use Data, Remove Duplicates, ticking only Email, so someone who registered twice keeps one row. Fix any names typed in lower case.
2. **Save it so accents survive.** If the list is a CSV, save it as an Excel workbook (.xlsx) before merging. Word sometimes reads CSV files in the wrong encoding, which turns Zoë into ZoÃ«.
3. **Merge onto badge labels.** In Word: Mailings, Start Mail Merge, Labels, Avery US Letter, 5395 Name Badges. Select Recipients, Use an Existing List, open the workbook. In the first badge insert First name on its own line in a large size, then Last name and Company smaller, and click Update Labels.
4. **Preview, merge and test.** Preview Results and page through looking for long company names that wrap and for broken accents. Finish & Merge, then print page one on plain paper at 100% and hold it against a badge sheet before printing the rest.

## Where Stella stops

- Stella decides what counts as a duplicate (same email here) and says who it merged. If two people share one email, check its list before printing.
- Very long names or company names are made smaller to fit, so a few badges may have smaller text than the rest.
- Attendee names, emails and companies go to the AI model you use in Stella while it reads the export. The badge file is made on your computer.
- It makes the PDF; it doesn't print it unless you ask. Print one plain-paper test sheet first.
- Recorded on Linux, where Stella installed a small PDF library for Python and used a font that has the accented letters. On a Mac or Windows PC it may install Python first, which wasn't recorded.

## Questions

**What size is an Avery 5395 name badge?**
3⅜ × 2⅓ inches, 8 per US Letter sheet in 2 columns and 4 rows. Other brands sell sticker badges in the same layout.

**Can it make badges for insert holders instead of stickers?**
Yes: give the holder's card size (4 × 3 in is common) and it lays them out on plain card stock with cut lines.

**Can it add a role, ticket type or QR code to each badge?**
Yes, from any column in the list: ask for a Speaker tag, a coloured band per ticket type, or a QR code. See [make QR codes in bulk](https://stella.sh/how/printing-labels/make-qr-codes-in-bulk).

**What about certificates for the same people afterwards?**
See [certificates from Excel](https://stella.sh/how/printing-labels/make-certificates-from-excel): one page per person, from the same kind of list.

**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: Filter for unique values or remove duplicate values](https://support.microsoft.com/en-us/office/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2), [Microsoft Support: Print labels for your mailing list](https://support.microsoft.com/kb/294684).

## Related problems

- [Generate certificates from an Excel list, one per person](https://stella.sh/how/printing-labels/make-certificates-from-excel.md)
- [Print address labels from Excel on Avery 5160 sheets](https://stella.sh/how/printing-labels/print-address-labels-from-excel.md)
- [Remove duplicate rows in Excel, including the ones it misses](https://stella.sh/how/pdf-excel/remove-duplicate-rows-in-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)
- [Print barcode labels from Excel with name and price](https://stella.sh/how/printing-labels/make-barcode-labels-from-excel.md)

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