How to print name tags from Google Sheets

By Jake Marsh · Updated

To print name tags from Google Sheets, install Labelyard and open Extensions > Labelyard > Create labels. Search 5395 under Label sheet for 2-1/3 x 3-3/8 in badges (8 per sheet), write **{{Name}}** on the first line and {{Company}} below it on the Design tab, upload your logo, then click Create PDF. Each attendee row becomes one badge.

Before you start

  • A tab of attendees with one person per row: First name, Last name, Company or Role, and anything else you want on the badge.
  • Name badge sheets. The 5395 and 8395 adhesive badges share one layout. For insert badges or another size, measure one and use Custom.
  • A logo as a PNG, JPG, GIF or WebP file, if you want one.

Steps

  1. Open Extensions > Labelyard > Create labels in the attendee sheet.
  2. Search 5395 and click "Name badges, 2-1/3 x 3-3/8 in, 8 per sheet".
  3. Choose the rows. To print badges for late registrations only, filter the sheet and pick Only rows visible after filtering.
  4. Write the badge on the Design tab:
    **{{First name}} {{Last name}}**
    {{Company}}
    
    Double stars make the name bold. Set Align to Center and raise Largest size so the name reads from across a room; long names shrink to fit.
  5. Add the logo under Logo or picture. Choose its position (Left, Right or Top) and size. It's stored inside this spreadsheet and prints on every badge.
  6. Add a QR code if you check people in. Under QR code or barcode, set the value to a column such as {{Ticket URL}} or {{Attendee ID}}. Each badge gets its own code.
  7. Print the test page, then Create PDF. Print at 100%.

Getting the badge to read well

A name badge is read from a meter or two away, often at an angle, so the name needs to be the biggest thing on it by a wide margin. A few things help:

  • One line for the name. If first and last name together are long, Labelyard shrinks the line until it fits. Putting the first name alone on line 1 keeps it large, with the last name smaller underneath.
  • Leave out empty lines. Tick Leave out lines whose columns are empty, so a guest with no company doesn't get a blank gap in the middle of the badge.
  • Keep the logo small. A logo set to Top takes space from the name. Left or Right at a small size usually leaves more room.
  • Test on plain paper first. The free alignment test page prints the badge outlines with numbers, so you can hold it against a badge sheet before you print on the real thing.

Ideas that work on badges

EventLine 1Line 2Extra
ConferenceName in boldCompanyQR code with the attendee ID
Classroom or campFirst name only, largeGroup or table{{#}} as a seat number
Volunteer shiftNameRoleA colored border
WorkshopNamePronounsLogo at the top

What it costs

Labelyard's free trial covers your first 300 labels or 14 days, whichever comes first, with no card needed. Previews and alignment test pages never count. After that it's $9.99 a month, $39 a year or $99 once for lifetime use on one Google account, and a $149-a-year team plan covers everyone at your company or school domain. Install it from the Labelyard page.

Labelyard: Print Labels & Envelopes

Print address labels, name tags and stickers from Google Sheets rows, lined up on the first try $9.99 a month or $39 a year per Google account.


Questions

Can I print first names bigger than last names?

Put the first name on its own bold line and the last name on the next line. Largest size sets the starting size for the whole badge, and each line shrinks only if it doesn't fit.

Can every badge have a different QR code?

Yes. The code value takes column names, so https://example.com/checkin/{{ID}} makes one code per row. Codes are drawn inside Google and don't go through another website.

How do I reprint one badge for a walk-in?

Add the person as a new row, select it, choose Only the rows I select in the sheet, and under Start on a used sheet click the next empty spot on your partly used badge sheet.

Do the badges come out in color?

Text color, the border and your logo print in color on a color printer. Set the text color with Color on the Design tab.


More Labelyard guides


More Google guides