How to Make ID Cards in Excel (and Faster in Bulk)

Yes, but not in Excel alone. Excel is the right place to keep the list of people. The card layout is best done in Word using mail merge, which reads your Excel rows and fills one card per row.

You can technically draw a card in Excel by resizing cells, adding borders and typing each person's details. It falls apart quickly: cell sizes do not map cleanly to millimeters, every card has to be copied and edited by hand, and photos have to be inserted one at a time. For anything more than a handful of cards, that is slow and error-prone.

The three ways people make ID cards from a spreadsheet

1. Excel plus Word mail merge. Free if you already have Microsoft Office. Good for text-only cards in small numbers.
2. Excel plus a design tool with data merge. Some desktop publishing tools can merge a CSV into a layout. Powerful, but they need design skills and a license.
3. Excel plus a batch ID card generator. You upload the sheet, map columns to a template and get print-ready cards with photos and unique codes. This is what the CardDeck batch generator does.

This guide walks through the first method honestly, including where it breaks, then shows the batch route. Whichever you choose, the spreadsheet preparation in the next section is the same, and it is where most mistakes start.

Set up the sheet as a simple table: one header row, one row per person, one column per field. Keep it plain, with no merged cells, blank rows or formatting that carries meaning.

Recommended columns

• id: a unique employee, student or member number, such as NWL-0428. This is the most important column. It matches photos, prevents duplicates and lets you update cards later.
• first_name and last_name: separate columns give you more layout options.
• title or class: job title for staff, class and section for students.
• department: or house, programme or team.
• valid_until: an expiry date in one consistent format, such as 2027-06-30.
• photo: the photo filename, ideally the same as the ID (NWL-0428.jpg).
• emergency_contact: optional, for the back of the card.

Data hygiene before you merge

• Trim stray spaces at the start and end of names. Excel's TRIM function helps.
• Check for duplicate IDs with conditional formatting (Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values).
• Use consistent capitalization: "Priya Nair", not "PRIYA nair".
• Keep dates as text in your chosen format if your merge tool reformats them unexpectedly.
• Save a CSV copy as CSV UTF-8 so accented and non-Latin names, such as Tomás or Zoë, are not garbled.

A worked example

A 40-person office exports staff from its HR system. Before merging, the admin finds two staff sharing an ID because of a re-hire, three names in all caps and one missing photo. Fixing these in the sheet takes ten minutes; fixing them after printing would mean reprinting cards.

Word mail merge treats each ID card as a "label". You define a label the size of an ID card, connect your Excel file and insert merge fields into the first label. Word then repeats it for every row.

Steps (desktop Word)

1. Open a blank document and go to Mailings > Start Mail Merge > Labels.
2. Click New Label and create a custom label: width 8.56 cm, height 5.4 cm (the CR80 ID card size), 2 labels across and 5 down on A4. Set the side and top margins and the gaps between labels so the total fits the page. This gives ten cards per sheet with little room to spare, so check your printer's minimum margins.
3. Go to Select Recipients > Use an Existing List and choose your Excel file and the sheet that holds the data.
4. In the first label, design the card: your logo (inserted as a normal image), then Insert Merge Field for first_name, last_name, title, department, id and valid_until. Format text with large, bold names.
5. Click Update Labels so every label on the page copies the first one's layout.
6. Click Preview Results and step through a few records to check long names and missing values.
7. Click Finish & Merge > Edit Individual Documents to create the final document with all the cards.
8. Print one page on plain paper first and hold it against your card stock or perforated ID sheets to check alignment.

What this gets you

A clean, text-only ID card for every row, printable on A4 card stock or perforated card sheets. For a small team that only needs name, title and logo, this can be enough.

Word can merge photos, but only through a field code called INCLUDEPICTURE with a merge field nested inside it. It works, but it is the most fragile part of the process.

The basic method

1. Put all photos in one folder, named exactly as they appear in your photo column (for example NWL-0428.jpg).
2. In the first label, press Ctrl+F9 to insert field braces. Inside them type INCLUDEPICTURE followed by the folder path in quotes, with backslashes doubled, and then a nested MERGEFIELD for your photo column (insert the inner braces with Ctrl+F9 as well).
3. Press Alt+F9 to toggle between field codes and results.
4. Update labels, then finish and merge.
5. In the merged document, select all (Ctrl+A) and press F9 to refresh the fields so each card shows the right photo.

Why photo merges go wrong

• Paths break when the folder moves, is on a network drive or is synced to the cloud.
• Every card shows the same photo until fields are refreshed.
• Photos come in at different sizes unless every source image has the same aspect ratio and resolution.
• Filename mismatches such as .JPG versus .jpg or a trailing space produce blank boxes with no clear error.
• Behavior differs between Word versions and between Windows and Mac.

Prepare photos properly either way

Use recent, front-facing photos on a plain background, cropped head and shoulders in the same aspect ratio (a 3:4 portrait crop is common), and at least about 300 pixels wide so they print sharply at ID size.

Not easily. Excel has no built-in QR code or barcode function, and Word's support is limited and version-dependent. This is where the spreadsheet method usually hits a wall.

Options in Office

• Word's MERGEBARCODE field. Recent desktop versions of Word for Windows include a MERGEBARCODE field that can turn a merge field into a QR code or some 1D barcodes. Support and options vary by version, so test it before you plan around it.
• Barcode fonts. You can install a barcode font and format the ID column with it. Code 39 fonts are simplest, because the data only needs asterisks at the start and end. Code 128 fonts need start, stop and check characters calculated first, usually with a formula or add-in; typing the raw number in a Code 128 font produces a barcode that will not scan.
• Add-ins and external images. Third-party add-ins or online generators can create one image per row, which you then merge as pictures using INCLUDEPICTURE, with all the fragility described above.

What a static code cannot do

Even when it works, a QR code made in Office is static. It cannot tell a security guard whether the card is still active. When someone leaves, their printed card still carries a code that looks valid.

With CardDeck, every row gets a unique QR code that opens a verification page showing active or inactive in real time, plus an optional Code 128 barcode for existing access or library readers.

The Excel and Word method is fine for a one-off batch of simple cards. It struggles with photos, codes, double-sided layouts, updates and anything that needs to be secure.

Where it breaks down

• Scale. Merging and checking 30 cards is manageable. Checking 300 cards for photo mismatches and overflowing names is not.
• Double-sided cards. Aligning a back side (emergency contact, return address, terms) so it lines up with the front during duplex printing takes trial and error.
• Alignment drift. Small errors in label margins compound down the page, so the bottom row of cards prints off-center.
• Long names. Mail merge does not shrink text to fit, so long names wrap or get cut off.
• Updates. When one person changes department, you re-merge and reprint, and there is no record of which version is current.
• Verification and revocation. A printed mail-merge card cannot be deactivated. If it is lost or the person leaves, it looks valid forever.
• Digital copies. Remote staff and contractors cannot carry the card on their phone.

When the spreadsheet method is still the right call

• You need fewer than about 20 cards, once.
• The cards are text only, such as visitor or volunteer passes.
• You already have Office and no budget for anything else.

If that is not you, keep the spreadsheet and change the tool.

Upload the same Excel sheet to the batch generator, map its columns to an ID card template, attach photos by filename and export print-ready cards. Every card gets a unique QR code, and problem rows are flagged before anything is issued.

Steps

1. Choose a template. Start from an ID card template and add your logo, colors and fields. Lock it so every card matches.
2. Upload your sheet. XLSX or CSV, straight from Excel or your HR or student information system.
3. Map columns. CardDeck suggests a mapping from your headers to template fields. Check it and save it for next time.
4. Add photos. Upload a ZIP of photos named after the ID column. They are matched automatically.
5. Fix flagged rows. Missing photos, duplicate IDs, empty required fields and names too long for the layout are flagged in the preview.
6. Issue or export. Export a print-ready PDF for a CR80 card printer or A4 sheets, or issue digital IDs people can open on their phones.

Plan limits

Batch rows per job are 25 on Free, 500 on Pro, 2,000 on Team and 25,000 on Business. Employee IDs are included from the Team plan, and student IDs are on Business. For staff cards, see the employee ID card maker; for schools, the student ID card maker.

Updating later

Re-import the sheet with the same ID column and only changed rows are updated. A new hire gets a new card; nobody else's card is regenerated.

Most ID cards use the CR80 size: 85.6 × 54 mm (3.375 × 2.125 in), the same as a bank card, defined as ID-1 in ISO/IEC 7810. Design at that size whether you print on PVC or paper.

Printing options

• PVC card printer. Prints directly onto blank CR80 PVC cards, usually 0.76 mm (30 mil) thick. The most durable option, and some printers can encode magnetic stripes or RFID chips.
• Print service. Send a print-ready PDF to a local or online card printer.
• A4 or Letter perforated card sheets. Print on an office printer, then snap out the cards and use a sleeve or laminate. Fine for events and short-term passes.

Print settings that matter

• Export at 300 dpi or as vector PDF.
• Add bleed (usually about 2 to 3 mm beyond the trim edge) if colors run to the edge, and keep text inside a safe zone a few millimeters from the edge.
• Use a portrait or landscape orientation consistently for the whole batch.
• If you add a slot punch for a lanyard or clip, keep photos and codes clear of the hole.

Checklist before printing the batch

• Print five sample cards and check them at actual size.
• Hold a card at arm's length: can you read the name?
• Scan the QR code and barcode with the devices staff will use.
• Check the longest name and the shortest name in the list.
• Confirm the expiry date and the back side line up.

Most ID card problems start in the spreadsheet, not the printer. Avoid these and either method goes more smoothly.

Data mistakes

• No unique ID column. Without it you cannot match photos reliably or update a single card later.
• Duplicate IDs from re-hires or copy-paste errors.
• Merged cells and blank rows that confuse the merge.
• Saving as plain CSV instead of CSV UTF-8, which turns accented names into strange characters.
• Inconsistent dates that print as 06/07/2026 for some people and 2026-07-06 for others.

Design mistakes

• Names too small to read at a glance. Make the name the biggest text on the card.
• Too many fields on the front. Keep the front for photo, name, role and ID, and use the back for the rest.
• Low-contrast text over a photo or background pattern.
• A QR code too small or too close to the edge. Keep it at least 2 × 2 cm with a clear margin.

Process mistakes

• Printing the whole batch before proofing a sample.
• No plan for lost cards, leavers and new starters.
• Keeping the only copy of the sheet on one person's laptop.

If you are issuing staff IDs, our guide on how to make employee ID cards covers fields, photos and offboarding in more depth.