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

Make name badges

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:

ColumnWhere it goes on the badge
First nameThe large line in the middle
Last nameUnder 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

  1. 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.

  2. 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.

  3. 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.

  4. Print

    Open Print. Under How many, Every row of your datalist prints one badge for each guest.

Make name badges

The top half of a sheet of 2⅓ by 3⅜ inch name badges, each with the event name Riverside Makers Meetup, a large first name such as Maya, the last name and the company
Badges from a made-up guest list on 2⅓ × 3⅜ in badges, drawn by the Name badge layout, with an event name across the top. “Christopher” was made smaller to fit.

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:

PaperSizePer sheet
Adhesive name badges, compatible with Avery® 53952⅓ × 3⅜ in8
Name badge inserts, compatible with Avery® 53902¼ × 3½ in8
Name badge inserts, compatible with Avery® 53923 × 4 in6
Name badge labels, compatible with Avery® L478580 × 50 mm10 (A4)
Name badge labels on a roll, compatible with Brother® DK-123460 × 86 mmA roll, one at a time

On 2⅓ × 3⅜ in badges On 3 × 4 in inserts On A4 (10 per sheet)

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.

Make name badges Printing help

Feedback

Suggestions and feedback

What would make EncodeLabel better, or what isn’t working? It goes straight to the people who run the site.

Only if you’d like a reply.

We use your email only to reply to you. Please don’t include passwords or private details. Privacy Policy

Add EncodeLabel to your Home Screen

One tap to your labels, like an app, with nothing to download from an app store.