Guide
Name badges from a spreadsheet
One row per guest, one badge each: the first name as large as it fits, then the last name and the company.
Updated
Get the list ready
Any guest list works: an Excel or CSV file, a Numbers or OpenDocument file, or rows pasted from Excel or Google Sheets. Put the headings in the first row and one guest in each row under them. The Name badge layout looks for these columns:
| Column | Where it goes on the badge |
|---|---|
| First name | The large line in the middle |
| Last name | Under the first name |
| Company (or Organization) | Under the last name, in smaller type |
| Role (or Job title) | At the bottom, if your list has it |
Capitals, spaces and underscores in the headings don’t matter, so first_name works too. A list with one Name or Full name column works as well: then the whole name is the large line.
The badges print each name exactly as it is in your spreadsheet, so check the spelling there first.
Make the badges
Start the layout
The button below opens the designer with the Name badge layout on 2⅓ × 3⅜ inch adhesive badges, 8 per sheet. A label you were working on stays one Undo away.
Add your list
Click Add a datalist and choose your file, or paste the rows. A CSV, an Excel file or a tab-separated text file can be read, up to 15 MB and 20,000 rows. Until you change the badge, the layout fills itself in from your columns. If you’ve already changed it, choose Layouts, then Name badge again.
Check the badges
Step through the guests with the arrows under the badge. Check every row draws every badge and lists any that need a look.
Print
Open Print. Under How many, Every row of your datalist prints one badge for each guest.
Long names
The first name is printed as large as the badge allows: about 50 points for a short name such as Maya on 2⅓ × 3⅜ inch badges. A longer name is made smaller until it fits the width, so Christopher comes out at about 38 points on the same badge.
Only a name that still doesn’t fit at 8 points is cut off, and Check every row lists it. Shorten it in your spreadsheet (a first name people use, or initials) and add the list again.
Badge paper
Adhesive badges stick straight onto clothing; inserts go into plastic badge holders. Some badge papers in the list:
| Paper | Size | Per sheet |
|---|---|---|
| Adhesive name badges, compatible with Avery® 5395 | 2⅓ × 3⅜ in | 8 |
| Name badge inserts, compatible with Avery® 5390 | 2¼ × 3½ in | 8 |
| Name badge inserts, compatible with Avery® 5392 | 3 × 4 in | 6 |
| Name badge labels, compatible with Avery® L4785 | 80 × 50 mm | 10 (A4) |
| Name badge labels on a roll, compatible with Brother® DK-1234 | 60 × 86 mm | A roll, one at a time |
Before the first real sheet, open Print, then Line it up, and choose Print a test page. Print it on plain paper and hold it against a sheet of badges, up to a window. It never counts toward your labels.
Logo, event name, numbers
- A logo: add an Image and drag it to the top of the badge, then pick the names and move them down to make room.
- The event’s name: add a Text box across the top and type it once. It is the same on every badge.
- Numbered badges or tickets:
{{#}}is the label number, 1, 2, 3 and so on, and{{#|000}}prints 001, 002, 003. - The date:
{{today|D Mmmm YYYY}}prints the day you print, such as 21 October 2026. Dates on labels has the other forms.
Everything on the badge can be moved, resized or deleted, as on any label in the designer.
Your list stays in your browser
A guest list holds other people’s names. The file or the rows you paste are read by your own browser, on your own computer or phone. The list isn’t sent to EncodeLabel to make the badges: the preview, the PDF and the print are all made on your device.
It reaches the site only if you log in, press Save and say yes to keeping the list. The Privacy Policy says what is kept and for how long.
Try it
Free for up to 100 labels a month. No account needed. Your labels are made in your browser.