1. Paste names and IDs
One person per line, two columns: name, then ID. Copy the two columns straight out of Google Sheets or Excel (they arrive tab separated), or type them as Ava Thompson | 1001. Commas never split a line, so "Smith, Jane" stays one name. A header row such as Name / ID is skipped, and a line with only one value becomes an ID with no name.
0 cards ready
ID only keeps names off the code: a scan records the ID, and one lookup column in your Sheet turns it back into a name.
How do you take attendance with QR ID cards?
1. Paste your list and print
Copy the name and ID columns from your roster, choose ID only for the code, and print on card stock. Cut along the guides; laminate if the cards will live in a pocket for a term.
2. Create a scanner link
Sign up free, connect the Google Sheet you want the attendance in, and create a scanner link. It is a web address, not an app.
3. Scan the cards at the door
Open the link in the browser on the staff phone that takes attendance and point it at each card. The people being scanned never open the link and need nothing. Every scan becomes a timestamped row in your Google Sheet with the ID that was on the card.
4. Turn IDs back into names
Keep your roster on a second tab and add one lookup column beside the scans, so each ID shows its name. The names stay in your Sheet instead of on the cards. Or start from a register that marks itself.
New to this? How QR code attendance works, start to finish. Cards printed? Next: how to take QR code attendance in Google Sheets. Cards that already carry a barcode? Scan the ID cards people already have. Printing lanyard badges for an event? See QR code event check-in: scanning badges at the door and what each door phone costs.
What can a QR ID card prove, and what can it not?
A scanned card proves that the card was presented at that time. It does not prove who was holding it: a friend can carry a second card through the door. For a class register or a training session that is usually fine, because the person scanning can see the room. Where identity matters, scan each card only with its holder in front of you, or check faces against a photo list.
Keep names out of the code if privacy matters. Anyone can read a QR code with a phone camera, so a card that encodes "Name | ID" tells whoever finds it who it belongs to. An ID-only code reads as a number, and your Sheet does the lookup.
The codes are static: they hold the ID directly, with no redirect, so they never expire. A lost card is fixed by printing that one card again.
Can you make QR ID cards without this tool?
Yes. Generate a QR code for each row of your roster inside Google Sheets, then lay the cards out with a mail merge in Google Slides, Docs or a word processor. Our guide to generating QR codes from Google Sheets covers the formula. It works, and it is free; where it breaks is the layout: card sizes, margins and getting every code to land inside its card on the printed page take a while to set up. We make QR to Sheets, so weigh that, but this page does the layout part for free and you need nothing from us to use it.
Either way, a printed code does not record anything by itself. Something has to scan it and write the row down, which is what a QR to Sheets scanner link does: no app to install and no accounts for the people scanning.
Scan these cards into a Google SheetFree for your first 300 scans on one phone, no card needed.
A second door, booth or classroom is a second phone
Free covers one phone and one scanner link. Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month. Running several classes, events or lists from one phone? Premium on that one phone is $7 a month, with a separate scanner link for each. Paid yearly, it is $70 per phone per year (2 months free).
How many phones will scan at the same time?
$7 x 2 = $14 a month
Sign in with Google and, on the free plan, the billing page opens with this choice. Nothing is charged until you confirm the card checkout, and you can change the number of phones later.
Questions
Should the QR code hold the name or the ID?+
The ID. A scan writes exactly what the code holds, so an ID-only card still gives you a complete record once your Sheet looks the ID up in your roster, and anyone who points a phone camera at a lost card learns nothing about the holder.
How do I paste names and IDs from Google Sheets?+
Select the two columns in Google Sheets, copy, and paste them into the box. The cells arrive separated by tabs, which the maker reads as two columns. To type a list instead, write one person per line as Name | ID.
What sizes do the cards print at?+
Credit-card size, 85.6 x 54 mm, which fits standard badge holders: 10 per A4 sheet or 8 per US Letter sheet. The upright badge layouts print 9 per sheet on either paper size for lanyards.
Is it really free, with no signup?+
Yes. No account, no email and no watermark. The cards are made in your browser, so your list is never uploaded. Scanning the cards into a Google Sheet with QR to Sheets is free for the first 300 scans on one phone, then $7 per phone per month.
How do I scan QR code ID cards into a Google Sheet?+
Open a QR to Sheets scanner link in the browser of the phone at the door and point it at each card. Each scan becomes a row in your Google Sheet with the ID and the time, and the people being scanned need nothing. A phone camera on its own can read the code but only shows it: something has to write the row. It is free for your first 300 scans on one phone.
Can I make staff or employee ID cards for attendance?+
Yes. The cards hold a name and an ID, so they work as staff and employee badges as well as student cards. Staff scan in at the door with a QR to Sheets scanner link on one phone, and each scan becomes a timestamped row in your Google Sheet, free for the first 300 scans on one phone, then $7 per phone per month. It records which card was scanned and when, not payroll hours.
Can the cards carry a barcode instead of a QR code?+
Yes. Choose Barcode (Code 128) under Code type and each card prints a Code 128 barcode of the ID, which a QR to Sheets scanner link and most handheld barcode scanners read. A phone camera reads a QR code more easily, so pick the barcode when your system expects one. Cards that already carry Code 128, Code 39 or most other common barcodes can be scanned as they are, but not Codabar.
What happens if someone scans the same card twice?+
By default the second scan is saved anyway, and the scanner shows an amber badge with the repeat count, so a double tap at the door still leaves a record and the person scanning can see it happened.
Can a QR ID card prove who attended?+
No. It proves that a card was presented, not who was holding it. If identity matters, have staff scan each card only with its holder in front of them, or check faces against a photo list.
Guides for running attendance with the cards
- How to take QR code attendance in Google Sheets for freeFree QR code attendance tracking with a Google Form and a Sheet, step by step. Where it breaks for schools and clubs, and the no-app staff-scan fix.Read the guide
- QR attendance for seminars, conferences and training sessionsRecord who attended each seminar, conference session or training workshop: one scanner per room, one Google Sheet, a per-session report and CPD minutes.Read the guide
- How to run school open day check-in with QR codes and a Google SheetCheck families in at a school open day with QR passes and Google Sheets: registered and walk-in queues, the follow-up list, and when a visitor system fits.Read the guide