Spreadsheet to badges
Print Name Badges from Excel
Turn your Excel or Google Sheets list into matching name badges with one CSV import and a printable PDF sheet layout.
| Name | Title | Group |
|---|---|---|
| Priya Raman | Head of Product | Speaker |
| Sofia Marchetti | Event Coordinator | Staff |
| Daniel Okafor | Senior Software Engineer | Attendee |
What you get
Use the names you already have in your spreadsheet to fill every badge, with each row supplying a name, title, company and group. Save the list as a CSV, match the columns in the maker and preview the full set before printing.
Highlights
- CSV import for lists of up to 500 people
- Match columns to name, title, company, group and pronouns
- Accent colors set by your Group column
- Preview every row before printing
- Sheets for Avery 74459 inserts and Avery 5395 stickers
- Your list is read in the browser, never uploaded
Templates
Good places to start
- Event header, a big readable name, title and company, and a footer strip colored by attendee type.Use this template
- A bold side stripe carries the role; first name leads in large type for easy reading across a room.Use this template
- Show header, a role tab, the exhibitor's company up front and a booth number footer.Use this template
Setting up an attendee spreadsheet that imports cleanly
Keep one person per row with clear column headings, remove blank rows and confirm names before saving the sheet as CSV from Excel or Google Sheets. Match each imported column to the appropriate badge field, including employee ID or department where needed, and inspect the preview before accepting the list.
Planning Group values before a color-coded badge import
Use consistent Group values such as Speaker, Staff and Attendee so the same role receives the same label and accent throughout the print run. Check for spelling variations before export, and use a label override when a registration code needs to appear as a readable role on the badge.
Printing a few hundred spreadsheet badges without wasting stock
Sort the spreadsheet in the order you want to hand out badges, then preview long names and a sample from each group before exporting. Print an alignment test on plain paper first, load the correct stock and use 100% scale for the final run.
Step by step
How to print name badges from an Excel or Google Sheets list
Prepare the spreadsheet
Put a header row at the top, such as Name, Title, Company, Group and Pronouns, and give every person one row below it. Remove merged cells, blank rows and notes under the list, and keep everything on a single worksheet.
Save it as a CSV file
In Excel, choose File > Save As (or Save a Copy when AutoSave is on) and pick CSV UTF-8 (Comma delimited), which keeps accented letters like é and ñ intact. Excel saves only the active worksheet. In Google Sheets, open the tab you need and choose File > Download > Comma Separated Values (.csv). XLSX files can't be uploaded directly.
Upload the CSV in the maker
Open the maker, select a template and choose the size that matches your badge stock, such as Avery 74459. Import your CSV in the People panel, match its columns and preview the resulting badges; files can contain up to 500 people and be up to 2 MB.
Map columns to badge fields
Match each spreadsheet header to a badge field: Name to name, Title to title, Company to company, Group to group, and Pronouns to pronouns. A spare column such as Table or Track can map to the custom field used by the {{custom1}} token. Leave columns you don't need unmapped.
Set group colors and labels
Each distinct Group value gets its own accent color on the template's group-colored parts, such as the footer strip on Conference Classic. Adjust accent colors for up to three groups, and add a label override where a code like SPK should print as Speaker.
Preview each badge and the sheet
Step through the people navigator to check each badge, starting with the longest names to confirm auto-fit keeps them readable. Fix typos in the People table. Then open the sheet preview to see how badges fall on each printed page.
Export, test alignment and print
Export the PDF, as vector or 300 DPI, with cut lines if you're trimming cardstock. Print the alignment test sheet on plain paper at Actual size or 100 percent scale, never Fit to page, and hold it over your badge stock. Nudge the offset in 1/32 inch steps, up to 0.25 inch, then print the badges.
Merging a spreadsheet into badges: CSV import, Word mail merge or Avery's online tool
BadgesGenerator.com
Best forEvent lists with roles, where each row's Group value should set the badge color with no extra rules
Strengths
- A mapping step matches your column headers to badge fields
- Group values turn into accent colors and optional labels automatically
- Step through every row in preview before you print
- The spreadsheet is processed in your browser and never uploaded
Tradeoffs
- CSV only: save Excel or Google Sheets files as CSV before importing
- Save your spreadsheet as CSV before importing
- Imports top out at 500 people
- Photo file names must match a person name or employee ID
Microsoft Word mail merge
Best forWord users who want to merge straight from an Excel workbook and finish the layout in a desktop document
Strengths
- Uses an existing Excel list as recipients without converting to CSV
- Insert Merge Field drops a column's value wherever your cursor sits in the label
- Rules like If...Then...Else can print different text depending on a column's value
Tradeoffs
- The merge runs through several stages: label setup, recipients, fields and the final merge
- Styling each group differently takes more work than inserting conditional text
Avery Design & Print Online
Best forMerging a spreadsheet onto a specific Avery product with Avery's own template for that number
Strengths
- Avery's free web tool includes a spreadsheet import for personalizing each item
- Start by entering the Avery product number from your package
- Nothing to install on your computer
Tradeoffs
- Organized around Avery product numbers rather than generic sizes
- Supported file types and import steps may change, so check Avery's site for current details
The bottom line: If your roles need different colors and you're comfortable saving a CSV, import it into the badge maker. If the list must stay an Excel workbook and you know Word's Mailings tab, run a Labels merge. If your stock is Avery and you want Avery's template for it, try Design & Print Online, checking its current import options first.
Frequently asked questions
Can I upload an XLSX workbook instead of saving a CSV?
No, the maker reads CSV files only. In Excel, use File > Save As and choose CSV UTF-8 (Comma delimited). In Google Sheets, use File > Download > Comma Separated Values. In Apple Numbers, choose File > Export To > CSV. Keep the original workbook too, since a CSV holds just one sheet of plain values without formatting.
Why do accented names look garbled after I import my Excel list?
The file was probably saved as plain CSV (Comma delimited) instead of CSV UTF-8, and that older format can scramble letters like é, ü or ł. Open the original workbook, save it again as CSV UTF-8 (Comma delimited), and import the new file. Google Sheets downloads already use UTF-8, so this mostly happens with Excel.
How many sheets will a 500-person Excel list print on?
Spreadsheet import accepts up to 500 people in a CSV file of 2 MB or less, with no account required. That list takes 84 six-badge Avery 74459 sheets or 63 eight-badge Avery 5395 sheets, so keep extra stock for test prints and replacements.
Why are my spreadsheet badges printing slightly off the Avery inserts?
Usually the print dialog scaled the PDF. Choose Actual size or 100 percent scale and turn off Fit to page. Then print the alignment test sheet on plain paper, lay it over the insert sheet against a window, and move the offset in 1/32 inch steps, up to 0.25 inch either way. If the error grows down the page, check the paper guides.
Does spelling in the Group column have to match exactly?
Keep it consistent. Every distinct value becomes a separate group with its own color, so Volunteer and Volunteers split into two groups, and a stray typo like Speakr creates a third. Before exporting, sort the sheet by Group and scan for near-duplicates, or use Find and Replace to merge them into one spelling and one capitalization.
Is my attendee spreadsheet sent to a server when I import it?
No, the maker reads the CSV inside your browser, and the names, titles, companies and pronouns in it are never uploaded. That helps when an attendee list holds details people shared only with the organizer. Keep your own copy of the file somewhere safe, because the maker doesn't store lists in the cloud for later.
Ready to print your badges?
Pick a template, add your names and export print-ready sheets. Free for up to 500 people.