Turn your Excel list into name badges
Upload a spreadsheet or paste rows, check the column mapping, and go straight to the badge editor with every attendee in place.
Upload a spreadsheet or paste rows, check the columns, and open the editor.
Drop your Excel or CSV file here
Excel, CSV or Google Sheets
Google Sheets: download it as CSV, or .
Include the header row if you have one (Name, Company, Role…). Nothing is uploaded.
No sign-up to start. Your list stays in this browser.
Excel, CSV or Google Sheets
How to make name badges from Excel
Excel can’t lay out badges on its own, and a mail merge takes setup for every event. Here you bring the spreadsheet as it is, confirm the columns, and get one badge per row.
-
Step 1: Save or export your list
Use the spreadsheet you already have: an .xlsx from Excel, a .csv or .tsv, or an attendee report from your registration tool.
-
Step 2: Upload it or paste the rows
Drop the file in the box above, or copy the cells in Excel or Google Sheets and paste them into the Paste list tab.
-
Step 3: Check the column mapping
We guess which column is the first name, last name, company, role and so on. You confirm or change each one, and see who needs a look.
-
Step 4: Create badges
The editor opens with one badge per row. Pick a template, add your logo, review the names and download a print-ready PDF.
How to set up your spreadsheet
- One header row at the top (Name, Company, Role…). Title rows above it are skipped.
- One person per row. Empty rows are skipped and reported.
- Either one full-name column, or separate first and last name columns.
- Optional: job title, company, role or ticket type, pronouns, city or table, and a QR link.
- No merged cells. Unmerge them and fill in each row.
- The first sheet with data is read. Other sheets are listed in a Sheet menu so you can switch.
Column names we recognize
You don’t have to rename anything: these headers (and close variations, in any capitalization) are matched for you. Any other column is kept as an extra field you can put on the badge.
| Badge field | Headers we match | Notes |
|---|---|---|
| Full name | Name, Full Name, Attendee Name, Badge Name, Name on badge | One column with the whole name, printed as it is. |
| First name | First Name, First, Given Name, Forename | Use with Last name. We never guess which part of a full name is the first name. |
| Last name | Last Name, Last, Surname, Family Name | Printed under or after the first name, depending on the template. |
| Company | Company, Organization, Organisation, Employer, Affiliation | Optional. |
| Job title | Job Title, Title, Position, Designation | Optional. |
| Role | Role, Ticket Type, Attendee Type, Registration Type, Badge Type | Speaker, Staff, VIP… Role colors always print the role word too. |
| Pronouns | Pronouns, Preferred Pronouns | Optional. Empty cells leave no gap. |
| Location | City, Location, Country, Table | City, country or a table number. |
| QR content | QR Code, QR URL, Check-in URL, Ticket URL | A link or reference per person, drawn as a QR code with its quiet zone. |
| Registration ID | Attendee #, Registration ID, Ticket ID, Barcode #, ID | Kept as text (leading zeros stay). Used to match people when you update the list. |
| Email (matching only) | Email, E-mail, Email Address | Not printed unless you add it. Helps match people when you update the list. |
| Don’t use | Order Date, Total Paid, Phone, Payment Status | Payment, phone and address columns are left out by default. You can change that. |
Google Sheets and other sources
-
Google Sheets
Select the cells, copy, and paste them into the Paste list tab. Or choose File → Download → Comma-separated values (.csv) and upload that file. There is no live link to your sheet: if the sheet changes, import it again.
-
Eventbrite and other registration tools
Export the attendee report as CSV or Excel and upload it as it is. Ticket Type becomes the role and Attendee # the registration ID, and payment, fee and phone columns are left out by default. We aren’t connected to any registration service.
-
Apple Numbers, .xls and .ods
Save or export the file as .xlsx or .csv first (in Numbers: File → Export To → Excel). Old .xls workbooks and OpenDocument spreadsheets aren’t read directly.
-
A plain list of names
Type or paste one name per line in the Paste list tab. That’s enough for a set of simple name tags.
What happens to your data
Your file is read in your browser and is not uploaded. Attendee data is only stored on our server if you sign in, which saves the project to your account. We do log anonymous design settings (never names) to improve the tool.
- Every cell is read as text, so leading zeros in IDs and accents in names are kept.
- Formulas and macros never run. If a cell holds a formula instead of its result, or an Excel error like #N/A, we point to the row.
- We guess the mapping from the headers and you confirm it. We never guess which part of a full name is the first name.
- ALL CAPS names get an optional Title Case suggestion that you preview first. Your original spelling is kept.
- Problems are reported by row, in plain words, and nothing is fixed silently.
Limits
- People per project
- 2,000
- File size
- 5 MB
- Rows read
- 5,000
- Columns read
- 60
Bigger event? Split the list by day or ticket type and make a project for each.
Update the list and reprint only the changes
Registrations keep coming after the first print. Import the new version of the spreadsheet and you see who was added, who changed and who was removed, before anything is applied. People are matched by registration ID, then email, then name and company. Removed people are marked, not deleted, so you know which badge to pull.
Print just the changes: export only the new and changed badges, on a fresh or partly used sheet.
Excel import or Word mail merge?
Word’s mail merge works, and it’s free if you already have Word. It just leaves the checking to you. Our mail merge guide walks through it if you prefer that route.
| Topic | Import here | Word mail merge |
|---|---|---|
| Cost | Free during launch. Exports will cost $10 later. | Free if you already have Word. |
| Setup for each event | Upload the list and confirm the columns. | Start a label merge, pick the label product, insert merge fields, update all labels. |
| Long names | Fitted to a readable size; names that still don’t fit are flagged. | No fit check: you look through every label. |
| Logo and colors | Part of every template, set once. | Placed by hand in the first label and copied across. |
| QR code per person | From a column, with a quiet zone. | Possible with a MERGEBARCODE field you set up by hand. |
| Roles | Role word and color from a column. | IF fields or a separate merge per role. |
| List changes | See added, changed and removed; print just the changes. | Edit the list and run the merge again. |
Microsoft Word and Excel are trademarks of the Microsoft group of companies. Google Sheets is a trademark of Google LLC. Avery is a trademark of Avery Products Corporation. We are not affiliated with any of them.