Producing badges for a conference is mostly a logistics problem with a small design problem inside it. Below is the end-to-end workflow that scales from a 50-person training session up to a 1,000-person trade show: how many to order, how to categorise attendees, how to generate badges in bulk, and how to distribute them on the day.
Planning and quantity
Order 10-15% more badges than your registered attendee count. Walk-up registrations, name spelling corrections, lost badges and damaged sheets all consume your buffer over the course of an event. For a 200-person conference, that means producing at least 220-230 badges; for a 1,000-person trade show, plan for 1,100-1,150.
Lead time matters. Producing badges in batches the day before is fine for events under 300 attendees with a clean spreadsheet; larger events benefit from a 48-72 hour buffer to handle late registrations, reprints and the inevitable spreadsheet errors that surface during proofing.
Categorising attendees
Most events benefit from at least four attendee categories: speakers, staff, sponsors and general attendees. Larger or more complex events add VIPs, press, exhibitors and student or volunteer tiers.
Each category needs visual differentiation, most commonly through a coloured band, border or ribbon attachment. A speaker’s badge with a distinct blue bar and the word “Speaker” underneath helps the wearer be recognised by attendees and respected by staff manning back-of-house areas. Sponsor badges with company-colour accents reinforce the sponsorship deal without overwhelming the wearer’s identification.
Document the colour-to-category mapping in a single shared sheet and circulate it to anyone printing, distributing or scanning badges on the day. Mid-event ad-hoc additions cause registration desk confusion. For the underlying design principles behind each category’s layout, see how to design a professional name badge for events.
Generating from a spreadsheet
For events above 30-40 attendees, manually editing badges one at a time becomes impractical. Mail merge — the process of pulling names from a spreadsheet into a Word badge template — handles bulk generation cleanly.
The spreadsheet needs one row per attendee with separate columns for first name, full name, organisation, role and category. Clean the data before merging: trim whitespace, fix capitalisation (proper nouns, not ALL CAPS), and verify that long names won’t overflow the badge cell. Names like “Jonathan Christopher Beaumont-Smith” routinely break templates designed for “Jane Doe”.
Generate one merged document per category if the visual differentiation is significant — speakers on green-banded sheets, attendees on white. This avoids the registration desk having to sort interleaved badges. For the full step-by-step on Word + Excel and Google Docs alternatives, see the name badge mail merge guide.
Printing logistics
A single Avery 5395 sheet holds 8 badges, so a 200-person event needs 25 sheets. Add buffer sheets and round up to 30. For 1,000 attendees, that’s 125 base sheets plus a 15% buffer — order 145.
Test the printer before committing the full run. Run one sheet, check alignment, then proceed. For runs over 50 sheets, plan for printer cool-down breaks every 20-25 sheets to avoid thermal misregistration. Keep printed sheets flat and dust-free until the event; vertical storage causes curling that interferes with insertion into clear holders.
On-site distribution
Pre-issued badges sorted alphabetically into named pigeonholes or labelled trays speed registration significantly. For events with on-site registration, hold blank badges, a thick black marker and a portable printer (or laptop with USB printer) at the desk to handle walk-ups.
Have a separate stack for “name correction needed” cases — wrong spelling, wrong organisation, wrong category. A second staff member working through corrections in parallel keeps the main queue moving.
Reusable holders
For organisations running monthly or quarterly events, reusable plastic holders pay back within two events. Attendees return holders at the exit; the inserts are recycled and the holders go back in storage. Budget for 20-30% replacement per year — they get dropped, sat on, or walked off with regardless of signage.