Free download
A clean, ready-to-use bulk ID card spreadsheet template. Fill it with your list, name your photo files to match the photo column, and upload it to StencilID to generate a print-ready batch of cards in one go.
CSV file, opens in Excel, Google Sheets or Numbers.
The template has a header row plus a handful of realistic example rows so you can see the shape of the data. The columns are generic enough for staff, students, members or event attendees. Keep the header, swap in your own rows.
| Column | What it is for | Example |
|---|---|---|
| name | The full name printed on the card. | Jane Doe |
| title | Job title, role or grade. Shown under the name. | Software Engineer |
| department | Team, class or group. Handy for color-coding or filtering. | Engineering |
| employee_id | A unique ID for each person. Doubles as a staff or student number. | EMP-1001 |
| photo | The filename of the person’s photo, matched automatically on upload. | jane-doe.jpg |
| qr_value | The text or URL encoded into the QR code on each card. | EMP-1001 |
The columns are only a starting point. Keep the photo column so photos are matched by filename, then add, remove or rename anything else to fit your cards.
Download the template. Grab the CSV below. It opens in Excel, Google Sheets, Numbers or any spreadsheet app.
Fill it with your list. Replace the example rows with your own people. Add a row per card and keep the header row as is.
Name your photo files to match. Put each photo filename in the photo column (for example jane-doe.jpg) and name the real image files the same way. That is how StencilID puts the right face on the right card.
Upload the CSV plus your photo folder. In StencilID, design one card, then upload this CSV and the folder of photos. Photos are matched by filename, so there is no pasting images into cells.
Map columns and generate. Map each column to a field on your card, then generate the whole batch as a print-ready PDF with cut lines, plus a ZIP of images.
The trick that saves the most time: photos are matched by filename. Whatever you put in the photo column (like jane-doe.jpg) must be the exact name of the image file you upload. No pasting pictures into cells, no hosting images anywhere.
It is a ready-to-use bulk ID card spreadsheet template: a header row with sensible columns (name, title, department, employee_id, photo, qr_value) and a few example rows. Fill it with your list, upload it to StencilID, and generate every card at once.
Photos are matched by filename. Put each photo file name in the photo column (for example jane-doe.jpg), name the actual image files the same way, and upload the folder alongside the CSV. Each photo lands on the right card automatically. No pasting images into spreadsheet cells.
Yes. The columns are only examples. Keep the photo column so photos are matched, then add, remove or rename anything else to fit your cards. You map each column to a field when you upload.
Yes, the CSV template is free to download and use. You can design and preview in StencilID for free too. Generating and downloading the full print-ready batch is on the paid plans.
Download the template, fill it in, and let StencilID do the rest. See the bulk ID card maker or browse card templates.