Tutorials

How to Print Event Name Badges from a Spreadsheet — Conferences & Meetups

Design and print professional conference name badges in SheetsToLabels. Import attendee data from Excel or Google Sheets, add role color-coding, and batch print on Avery badge inserts.

Great for events, meetups, and conferences.

Need the generator instead of the guide? Use the Name Badges from Excel tool to import attendee rows from Excel, CSV, or Google Sheets, preview badge sheets, and export a print-ready PDF.

1. Prepare Data

  • First Name
  • Last Name
  • Company
  • Role (Speaker, Attendee, VIP)

2. Template

Standard Insert sizes: 3" x 4" or 2.25" x 3.5".

  • Check Avery 5390 or 5392.

3. Design Tips

  • Readability is King: The First Name should be legible from 6 feet away. Use a font size of 24pt-30pt.
  • Role Coding:
    • Use a shape (rectangle) at the bottom with a background color.
    • You can manually sort your Excel file by Role to print "VIPs" in one batch on red paper, and "Attendees" on white, or create separate designs.
  • Conversation Starters: Add a field like Industry or Interests to spark chat.

Example conference badge design