Converting CSV and Excel attendee lists into printable badges
Event organizers frequently receive guest exports from registration desks as spreadsheets or plain-text rosters. Using a free printable name badge maker with no sign-up lets you turn Name | Role | Company lines or a spreadsheet into a print-ready PDF grid without retyping individual cards.
Mapping columns from Eventbrite, CSV, and Excel exports
The importer accepts .csv files formatted under the IETF RFC 4180 CSV Format Specification as well as .xlsx workbooks up to 20 MB. It treats row 1 as column headers, reads columns A through C, and replaces any literal pipe characters inside cells with slashes so three-field parsing never breaks.
Before clicking Import CSV or Excel, verify that your export places the full name first, job title second, and company third. Organizers who also hand out speaker contact cards can produce matching pocket contact cards with the business card maker using the same event branding.
Keeping attendee PII inside your browser tab
Registration lists contain personally identifiable information such as full names, employers, and executive titles. Unlike cloud badge portals that require uploading spreadsheets to remote renderers, this tool parses rows and builds the PDF inside a local browser Web Worker.
Zero bytes leave your device during previewing or export, and the workspace enforces a 500-row cap per batch so large conferences stay responsive. Once you download the PDF, closing the tab clears the attendee roster from memory.
Should you choose 8 or 10 name badges per sheet?
Pick 10 badges per sheet (2 x 5) for a compact 10-up name badge template that fits business-card-sized lanyard inserts, and choose 8 badges per sheet (2 x 4) when attendees wear larger conference pouches or carry multi-word job titles. Both layouts keep a 30 pt margin on all four edges of A4 or US Letter paper.
Spreadsheets exported from Excel or Eventbrite follow the ECMA-376 Office Open XML Standard, and both grid densities accept up to 500 imported attendees across consecutive pages. Check your physical plastic pouch dimensions before committing a full print run.
| Grid setting | Columns and rows | Badges per page | Best badge pouch use case | Trim line style |
|---|---|---|---|---|
| 10 per sheet | 2 columns by 5 rows | 10 | Standard 90 x 54 mm visitor inserts | 0.5 pt grey rectangle |
| 8 larger badges | 2 columns by 4 rows | 8 | Wide conference lanyards and multi-line roles | 0.5 pt grey rectangle |
| A4 paper | 595 x 842 pt canvas | 8 or 10 | International conferences and EU offices | 30 pt outer margin |
| US Letter paper | 612 x 792 pt canvas | 8 or 10 | North American workshops and trade shows | 30 pt outer margin |
| Batch ceiling | Multi-page PDF | Up to 500 total | Full-day summit rosters without splitting | Continuous pagination |
For events that pair registration check-in with prize draws or door giveaways, you can print sequentially numbered raffle tickets with detachable stubs on the same card stock.
Badge styles, typography scaling, and trim border geometry
Visual hierarchy determines how quickly attendees read a name across a crowded room. Under Badge style, three monochrome layouts balance event branding against legibility while keeping every slot aligned inside a crisp 0.5 pt border.
Comparing Classic rule, Dark header band, and Centered conference
Classic rule left-aligns the event heading at 9 pt above a thin horizontal divider, giving a clean editorial look for workshops. Dark header band fills a 28 pt solid ink bar across the top edge with 9.5 pt white text so the event title stands out from ten feet away.
Centered conference aligns the heading, attendee name, role, and company along the vertical axis for symmetrical lanyard sleeves. Retail pop-up organizers running merchandise booths alongside a conference can also switch to the printable shelf price tag maker for matching monochrome counter cards.
Automatic font scaling and character encoding limits
The PDF builder sets attendee names at 25 pt bold, roles at 12 pt, and companies at 10 pt using standard WinAnsi PDF fonts per the Library of Congress PDF 1.7 Format Description. If a long surname or title exceeds the slot width minus 28 pt of horizontal padding, the engine scales that line down incrementally to a 7 pt minimum.
Because standard embedded PDF fonts use Western European WinAnsi encoding, characters outside that range trigger a clear warning before export. Removing unsupported emojis or non-Latin glyphs lets the worker generate clean vector text across every page.
Cut-out lanyard inserts vs pre-cut adhesive Avery labels
Cut-out inserts and peel-and-stick adhesive badges solve different check-in workflows and require different PDF geometry. Cut-out sheets maximize printable area with zero wasted gutters, whereas adhesive sheets rely on exact die-cut margins.
Printing at 100% scale on card stock for pouch holders
Always select Actual size or 100% scale in your printer dialog instead of Fit to page so the 30 pt outer margins remain exact. Test-print page 1 on plain paper first to check alignment for double-sided printing or single-sided card stock, then feed 160 to 220 gsm sheets.
Tip: Print the first sheet on plain office paper and stack it behind a blank card stock sheet against a window to verify front-margin alignment before feeding your full batch.
When to switch to adhesive label sheets or event stationery
If guests stick badges directly onto jackets without plastic sleeves, pre-cut Avery sticker sheets save trimming time and require a dedicated label generator with die-cut gutters. When your registration desk also hands out welcome packets or speaker agreements, prepare matching event stationery without uploading attendee data to keep every printed handout visually consistent.