The free QR to Sheets ID card maker turns a list of names and IDs into printable QR code ID cards and badges, made in your browser with no signup. Scan the cards at the door with a QR to Sheets scanner link and each scan becomes a timestamped row in your Google Sheet, free for your first 300 scans.
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.
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 any phone and point it at each card. 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.
New to this? How QR code attendance works, start to finish.
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.
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 300 scans. No credit card required.
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.
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.
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.
Yes. No account, no email and no watermark. The cards are made in your browser, so your list is never uploaded. Recording the scans into a Google Sheet is the part QR to Sheets charges for, and the first 300 scans are free.
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 never loses a record and the person scanning can see it happened.
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.
