Making ID cards for a whole school by hand is slow and error-prone. If you already keep student records in a spreadsheet, you can turn that same data into hundreds of finished, print-ready cards in one pass. This guide walks through the process from start to finish.

Before You Start: What You Need

You need three things: a clean spreadsheet of student data, a set of student photos, and a template to drop the data into. Get those right and the rest is mostly automatic.

A browser-based school ID card maker handles the heavy lifting. You upload a spreadsheet, map each column to a spot on the card, and get one personalized card per row. There is nothing to install, you work entirely in the browser.

Step 1: Prepare Your Student Spreadsheet

Your spreadsheet (CSV or Excel) is the single source of truth. Each row becomes one card, and each column becomes a field you can place on the design.

Useful columns to include:

Full name: exactly as it should print
Student ID: the number you may also encode in a QR code or barcode
Grade or class: e.g. “Grade 9” or “Year 11”
Department or homeroom: if your school groups students that way
Photo: the filename of each student’s photo, e.g. alice.jpg (more on this below)
Expiry or school year: handy for cards that need to be reissued annually

A few tips that save headaches later:

Put clear, consistent headers in the first row.
Keep one piece of information per column, don’t combine name and grade.
Use the same format throughout (for example, always “Grade 7”, never sometimes “7th”).
Remove blank rows so you don’t generate empty cards.

Step 2: Handle the Photos

Photos are simpler than you might expect, you do not need to host them anywhere. Put each student’s photo filename (for example alice.jpg) in a column, then upload the photo files when you generate. StencilID matches each photo to the right student by filename, so there are no public links to create. (If your photos already live online with direct public links, for example in your student information system, you can use a column of image URLs instead.)

For a consistent, professional result:

Use the same aspect ratio for every photo (portrait crops work best for ID cards).
Aim for a plain or uniform background where possible.
Keep resolution high enough to stay sharp at print size, small thumbnails will look blurry.
Name files predictably so it’s easy to match them to the right student row.

Consistency matters more than perfection. A set of evenly cropped, similar-sized photos looks far better on a printed sheet than a mix of zoomed-in and zoomed-out shots.

Step 3: Choose a Template

Start from a template rather than a blank canvas. Pick one that has space for a photo, the student name, the ID number, and your school logo. Cards are built at CR80 size: the standard credit-card dimensions, so they fit any badge holder, lanyard, or wallet.

Using the drag-and-drop editor, you can move fields around, swap in your school colors, and add your logo once. Every card in the batch inherits that layout.

Step 4: Map Your Columns to the Card

This is where the spreadsheet meets the design. You tell the editor which column fills which element:

The name column to the name text field
The Student ID column to the ID field
The photo column (filenames) to the photo placeholder
The grade or department column to the relevant label

You map the fields once, and the tool applies that mapping to every row automatically.

Step 5: Add QR Codes or Barcodes

If your school uses ID scanning for attendance, library checkout, or building access, encode the Student ID (or another column) into a QR code or barcode. Drop the QR/barcode element onto the card, point it at the right column, and each student gets a unique, scannable code. No need to generate codes one at a time.

Step 6: Generate the Batch

With the mapping set, generate the full batch. You get:

A ZIP of individual card images: one 300-DPI PNG per student, ready to share digitally or print individually.
A print-ready PDF with multiple cards laid out per page, complete with cut lines so you (or a print shop) can trim them cleanly.

The 300-DPI output is what keeps text crisp and photos sharp on physical cards.

Step 7: Print the Cards

You have two practical options:

Office printer + cutter: Print the PDF on heavier card stock and trim along the cut lines. This is the cheapest route and fine for short runs, though edges and durability depend on your equipment.
Local print shop: Hand off the print-ready PDF for proper card stock, lamination, or PVC cards. Best for full-school runs that need to survive a year of daily use.

Because the PDF already includes cut lines and correct CR80 sizing, a print shop can usually run it as-is.

A Note for Bigger Projects

The same workflow scales beyond student cards. The employee ID card maker handles staff badges from a staff roster, and if you’re producing award or completion documents, the bulk certificate maker generates personalized certificates from a spreadsheet in exactly the same way.

Try It

You can start free and build a template today, bulk generation is available on a paid plan when you’re ready to run the whole school at once. Give it a try and see how a single spreadsheet becomes a stack of finished cards.

How to Make Student ID Cards in Bulk: A Step-by-Step Guide