Part of Batch labels. Excel, CSV, and Google Sheets how-tos start on that page.

How to print name badges from Google Sheets

Yes. You can print name badges from Google Sheets. Publish the attendee list as CSV, map first name and company, then print one badge per row. Free, no signup.

← Back to Blog

How to print name badges from Google Sheets

Published: · 3 min read · How-to
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.

Open name badge template

Name badge sample from the free label maker
This is the name badge template in the free app. Open it and swap in your own text.

Have the attendee list in Google Sheets? Publish it as CSV, open the free label maker, map {{first}} and {{company}}, and print one badge per row. Faster than a Docs mail merge.

Good to know: The sheet must be published as CSV (or you download CSV). We fetch only that published file. We do not log into your Google account.

How to print name badges from Google Sheets

  1. In Sheets: File, Share, Publish to web, choose CSV. Copy the link. Or download CSV.
  2. Open https://app.mylabelmaker.com. No signup. Set 4x3, or your badge stock.
  3. Add {{first}}, {{last}}, {{company}}. Paste the publish URL or upload the CSV.
  4. Preview two rows. Print the stack, or download PDF if you print another way.

Keep the sheet tidy

One person per row. Header names that match the tokens. No merged cells. If a name is missing on row 40, the badge will be blank there too.

Print or save

Got a Zebra? Print from the browser with Browser Print, at the printer's DPI. Otherwise download PNG, JPG, SVG, PDF, or ZPL. JSON keeps the label you can open later.

Merge the attendee sheet

Preview a row, then print the room.

Open name badge template