How to batch-generate 500 name badges from a CSV in under 5 minutes

You've got a conference in two weeks. The delegate list just landed — 500 names, titles, companies, and badge types. Your designer has created a beautiful badge template in InDesign. Now someone needs to create 500 individual PDFs, each with the right name, in the right font, saved with the right filename, sorted into the right folder.

In most studios, this means one of three things: spending a full day on InDesign Data Merge (and fighting its formatting quirks), hiring a temp to do it manually, or giving up on personalised badges entirely and going with blank "HELLO MY NAME IS" stickers.

There's a faster way. Here's how to do it in under 5 minutes using ArtBatch Merge — no InDesign required.

What you need

A badge template — a single-page PDF of your badge design, with blank space where the personalised text will go. Export it from whatever you designed it in — InDesign, Illustrator, Figma, Canva, anything that outputs PDF.
A delegate list — a CSV or Excel spreadsheet with columns for each variable field. Typically: first name, last name, company, role, badge type.

That's it. No plugins, no InDesign, no account signup.

Step by step

Step 1

Upload your badge template

Open ArtBatch Merge and drop your PDF template onto the upload area. ArtBatch shows a preview with the file dimensions. Single-page or multi-page templates both work — if your badge has a front and back, use a 2-page PDF.

Step 2

Upload your delegate list

Drop your CSV or Excel file. ArtBatch reads the column headers and shows them as available merge fields. Your spreadsheet might look like this:

first_name, last_name, company, role, badge_type Sarah, Chen, Imagination, Creative Director, Speaker Marcus, Reeves, Service Graphics, Studio Manager, Guest Jun, Takahashi, Pentland, Production Lead, Speaker

Step 3

Place your merge fields on the template

Click each column name to add it as a field on the badge. A green tag appears on the template preview — drag it into position. Each field has controls for font (30+ Google Fonts built in, or upload your own), size, weight, and colour.

The field tag shows at the exact size and font you've selected, so you can see precisely where the text will appear on the final badge.

Step 4

Set your filename pattern and folder grouping

In the Generate step, click column names to build a filename pattern. For example, click first_name, type _, click last_name — each badge will be named Sarah_Chen.pdf, Marcus_Reeves.pdf, etc.

If you want speakers in one folder and guests in another, select badge_type as the folder grouping column. The ZIP will contain:

Speaker/Sarah_Chen.pdf Speaker/Jun_Takahashi.pdf Guest/Marcus_Reeves.pdf

Step 5

Generate

Choose your output — separate files (ZIP) for individual PDFs, or single multi-page PDF if your printer wants one file. Hit Generate. ArtBatch creates each badge, preserving the original PDF quality and CMYK colour profile. A 500-badge batch takes about 30 seconds.

Tip: Need to add headshot photos or company logos to each badge? Add an image field instead of a text field — the CSV column should contain the image URL for each delegate.

Why not just use InDesign Data Merge?

InDesign Data Merge is powerful, but it has real friction for this use case:

You need InDesign — not everyone on the team has it, and not every event producer has a Creative Cloud licence.
Formatting is fragile — text overflow, font substitution, and paragraph spacing issues are common with Data Merge. You often end up manually fixing badges after the merge.
Export is slow — generating 500 separate PDFs from Data Merge involves exporting, then splitting, then renaming. ArtBatch does it in one step.
No folder grouping — Data Merge can't automatically sort files into folders by badge type. You'd need a script or do it manually.

ArtBatch Merge won't replace InDesign for complex editorial layouts. But for variable-data production work — badges, signs, cards, labels, certificates — it's significantly faster and doesn't need any installed software.

Other things you can batch-generate this way

The same workflow works for anything that combines a template with variable data:

Door signs — room number, occupant name, department. One template, one CSV, 200 signs.
Retail price cards — product name, SKU, price. Grouped by store or department.
Table seating cards — guest name, table number. Sorted into table folders.
Award certificates — recipient name, award title, date. Each individually named.
Direct mail — personalised postcards, letters, or flyers with name and address fields.
Exhibition labels — artwork title, artist, medium, dimensions. One per piece.
Wristband inserts — attendee name and access level for multi-zone events.
Locker labels — employee name, locker number, department.

If it's a template plus a spreadsheet, ArtBatch can generate it.

Try it with your next event

Upload a badge template, drop in a CSV, generate 500 personalised PDFs. Free for up to 5 files.

Open ArtBatch Merge →

Quick checklist before you start

Badge template exported as a single-page PDF (or 2-page for front/back)
Delegate list as CSV or XLSX with column headers in the first row
Font files uploaded if using a brand font (otherwise choose from 30+ built-in Google Fonts)
Decide on filename pattern — first_last or badge_number?
Decide on folder grouping — by badge type, table, or company?

The whole process takes less time than reading this article. Give it a try →