What badge size should I use?
Match the insert size of the holders you bought — 4 × 3 in and 3.5 × 2.25 in are the common ones. You set the finished size in inches or millimetres, so any holder size works.
Use cases
Event badge generator
Badge production, from registration list to print run.
The badge itself is the easy part — printing four hundred of them, at the right size, in time for the doors opening, is not. Batch, Please takes your attendee export and produces sheets of badges sized to your holders, plus one-off reprints for the walk-ins who register at the desk.
Conference producers
Trade show teams
Registration desk staff
What it solves
Replace manual personalization with a repeatable CSV flow.
- Badges that do not line up with the holders you already bought
- Wasting card stock on sheets with one badge per page
- No quick way to print a badge for someone who turns up unregistered
Example CSV columns
Bring the fields you already track.
attendee_nameorganizationticket_typebadge_numbertrack
Each column can become a text field on your design. You decide where it appears, how it is styled, and how overflow is handled before export.
Starting point
Getting your list out of Excel or Google Sheets.
The upload accepts CSV files. Both Excel and Google Sheets save one in a couple of clicks — the details below are the parts that usually trip people up.
From Microsoft Excel
- One attendee per row, headers in row 1, no title row above them.
- Filtered-out rows still export, so delete the rows you do not want on badges.
- File → Save As → CSV UTF-8 (Comma delimited) to keep accented names intact.
From Google Sheets
- Registration exports usually open in Sheets already — check that row 1 is headers.
- File → Download → Comma-separated values (.csv), which exports the active tab.
- For per-track badge runs, duplicate the tab and delete the other tracks before downloading.
Workflow
From spreadsheet to finished PDFs.
The same process works whether you start with a built-in design or upload your own PNG/JPG artwork.
- 1
Download the attendee list from your registration tool, Excel, or Google Sheets as CSV.
- 2
Set the badge size to match your holders — 4 × 3 in and 3.5 × 2.25 in are common.
- 3
Place name, organization, ticket type, and track fields on the badge design.
- 4
Export several badges per sheet with crop marks, and print.
Export options
Download the format that fits the job.
Badge sheets sized to your holders
Crop marks for clean trimming
Single-badge PDFs for walk-in reprints
Questions
Answers for this use case.
Can I print a badge for someone who registers at the door?
Yes. Make a CSV with just that person, or a handful of them, and export a single badge. A one-row export downloads as a plain PDF rather than a ZIP.
Can different ticket types have different badge designs?
Run one batch per design. Filter the attendee list by ticket type in your spreadsheet, export each filtered list as its own CSV, and pair it with that design.
More use cases
Related CSV-to-PDF workflows
Spreadsheet to event badges
Event badges from spreadsheet
Generate conference badges, meetup badges, and attendee passes from spreadsheet rows. Upload a CSV, map badge fields, and export printable PDFs.
ID card generator
ID card generator
Make membership, staff, student, and event ID-style cards from an Excel, Google Sheets, or CSV list. Print at CR80 card size or several per sheet.
Spreadsheet workshop passes
Workshop passes from spreadsheet
Create workshop passes, class passes, and simple session tickets from spreadsheet rows. Upload a design, map fields, and export PDFs.