Guide
How to print name tags from Excel or CSV
Turn a spreadsheet roster into a complete sheet of printable name tags without Word, mail merge, copied text boxes, or one-at-a-time editing.
- Prepare the roster
- Save Excel or Google Sheets as CSV
- Import and map columns
- Choose an Avery-compatible badge layout
- Print a plain-paper alignment test
Quick answer
Put one person on each spreadsheet row, save the sheet as a CSV file, then open the free online Name Tag Maker. Switch to Text mode, select Import CSV, choose which columns should appear on the badge, and import the labels. Pick the badge preset that matches your paper, download the PDF, and print at 100% scale.
Have the roster ready? Open the MakeMyStickers Name Tag Maker. Your CSV is processed in the browser and is not uploaded to a server.
1. Prepare the spreadsheet
Use one row per person and one column per type of information. Clear column headings help the importer and make the file easier to reuse. A simple event roster could look like this:
| Name | Company | Role |
|---|---|---|
| Alex Morgan | North Studio | Speaker |
| Jordan Lee | Maple School | Teacher |
| Taylor Rivera | River Market | Vendor |
The first row should contain headings, not a person's name. Useful columns include Name, Company, Role, Grade, Homeroom, Table, Team, or Pronouns. You do not need to include every spreadsheet column on the final badge.
2. Save or download the roster as CSV
Microsoft Excel
- Open the worksheet containing the roster.
- Choose File > Save As.
- Select CSV UTF-8 (Comma delimited) (.csv) when available.
- If Excel warns that only the active sheet will be saved, confirm that the roster sheet is active.
Google Sheets
- Open the roster sheet.
- Choose File > Download > Comma Separated Values (.csv).
- Google Sheets downloads the current tab as a CSV file.
Keep the original spreadsheet. CSV stores the values from one sheet, but it does not preserve colors, formulas, multiple tabs, or formatting. Export a copy instead of replacing the original workbook.
3. Import the CSV into the Name Tag Maker
- Open MakeMyStickers Name Tag Maker.
- Choose Text mode. The CSV import controls appear with the text input.
- Select Import CSV and choose the file exported from Excel or Google Sheets.
- Leave “First row contains headers” checked when the first row contains Name, Company, Role, or similar headings.
- Map the lines. Choose Name for Line 1, Company for Line 2, Role for Line 3, or any arrangement that suits the badge.
- Check the preview. The importer previews several labels before changing the sheet.
- Select Import labels. Each spreadsheet row becomes one separate name tag.
The generic importer accepts up to six mapped lines per label. Most badges are easiest to read with one to three: a large name, then a smaller company, role, grade, or table line.
4. Choose the correct name-tag layout
| Preset | Badge size | Per Letter sheet | Typical use |
|---|---|---|---|
| Avery 5395-compatible | 2.33 x 3.38 inches | 8 | Adhesive event and conference badges |
| Avery 5390-compatible | 2.25 x 3.5 inches | 8 | Badge inserts and holders |
| Avery 5392/5384-compatible | 3 x 4 inches | 6 | Large, highly readable badges |
| Avery 5163-compatible | 2 x 4 inches | 10 | Wide classroom and organization labels |
| Custom name tags | Adjustable | Varies | Cardstock, full-sheet paper, or custom holders |
Use the exact preset printed on the package. Even similar-looking badge products can have different margins or gaps. Exact Avery-compatible presets lock the sheet geometry so an accidental slider change cannot move the badges off the die cuts.
5. Make the names easy to read
- Use the person's name as the largest line.
- Choose bold or medium weight for rooms where people will read badges from several feet away.
- Keep company, role, table, or grade information smaller than the name.
- Use high contrast: dark type on a light background or light type on a dark background.
- Check the longest name in the roster, not only the first previewed name.
- Use auto-fit when the roster contains names of very different lengths.
6. Print an alignment test
- Download the PDF from MakeMyStickers.
- Print it on ordinary copy paper.
- Set the paper size to US Letter and the scale to 100% or Actual Size.
- Turn off headers, footers, and fit-to-page.
- Place the test print behind the blank badge sheet and hold both against a light.
- Only load the badge stock when every name falls inside its die-cut area.
If the first row aligns but later rows drift, the print dialog is probably scaling the page. If the entire sheet is shifted by the same amount, use the printer-alignment nudge available with exact Avery presets and run another plain-paper test.
Common CSV problems
| Problem | Cause | Fix |
|---|---|---|
| The headers print as a badge | The first-row option was turned off | Re-import and check “First row contains headers.” |
| All information appears on one line | Multiple values were combined into one spreadsheet column | Keep Name, Company, and Role in separate columns. |
| Accented characters look wrong | The CSV used an older encoding | Export as CSV UTF-8. |
| Blank badges appear | The spreadsheet contains empty rows | Delete unused rows before exporting. |
| Long names are too small | One fixed font size must fit every name | Use auto-fit or shorten secondary information. |
Frequently asked questions
Can I print name tags from Excel without Word?
Yes. Save the Excel sheet as CSV, import it directly into MakeMyStickers Name Tag Maker, map the columns, and download a printable PDF. Word and mail merge are not required.
Can each name tag include a company or role?
Yes. Keep Name, Company, Role, Grade, Table, or other details in separate spreadsheet columns, then map each selected column to a separate line on the badge.
Which Avery name badge formats are supported?
The Name Tag Maker includes exact presets for Avery 5395 adhesive badges, Avery 5390 inserts, Avery 5392 or 5384 large inserts, and Avery 5163-compatible name labels, plus adjustable custom layouts.
Is the roster uploaded to a server?
No. The CSV is read inside the browser. Names and spreadsheet data are not uploaded to MakeMyStickers and no account is required.
What to read next
Preparing for a classroom? Read how to make school supply name labels. For postal mail instead of badges, use the Excel address-label guide. General printing and scale settings are covered in how to print stickers at home.