A QR code attendance system for schools, with no student app
QR to Sheets lets you print one QR code per student, then scan the class in from your own phone as you walk the room. Every scan writes a timestamped row to your own Google Sheet. No app to install, no student accounts and nothing for students to download. If your school's Google admin restricts outside apps, they allow QR to Sheets once: here is what to send them.
Free for your first 300 scans on one phone, no card. After that, $7 a month covers the phone you scan with, with unlimited scans, so a class of thirty costs the same as a class of three.
Free for your first 300 scans on one phone, no card needed.
Updated
Short answer
You can track school attendance with QR codes and Google Sheets two ways: a free Google Form behind a QR code that students scan themselves, or a scanner link that a teacher uses to scan a printed code on each student's card.
The Forms route costs nothing and suits an occasional register, but it needs every student to hold a phone and it loses a submission attempted with no signal.
QR to Sheets is free for the first 300 scans on one phone and then 7 USD per phone per month, which fits a class where only the teacher holds a phone.
The register that fills itself — in Google Sheets
Scan the class in under a minute. No new system to learn and no app to manage.
Scan from the phone you already have, no app
The teacher opens the scanner link in the phone's browser: no app store and no account for scanning. Each phone that scans counts as one device; Free covers one phone. Works in Chrome and Safari on iPhone and Android.
Attendance lands in Google Sheets
Every scan creates a row: the code, the time (date and time in one column) and the link's name, for example the class. Your Google Sheet becomes the attendance register, with no separate attendance system to maintain.
Library books, IT assets, and equipment
Track book loans, laptop check-outs, and equipment borrowing with QR codes on each item. Scan out, scan back in — the log writes itself to Google Sheets.
Automatic timestamp on every scan
No teacher needs to write the time. Every scan is recorded to the second — useful for late arrivals, early departures, and asset check-in/check-out logs.
QR codes on student cards or class lists
Print QR codes for student IDs, lesson timetables, or library books from the built-in QR generator. Attach them to existing cards — no new badge printing system needed.
Students never access your Google account
Staff connect Google Sheets once in the admin. Students only see the scanner screen — no access to the spreadsheet, other records, or any admin settings.
Step-by-step guides for the jobs on these cards: late arrivals and tardies, library book loans and Chromebook and laptop check-outs.
Set up your QR attendance register in minutes
Connect Google and make a scan sheet
Sign in with Google, approve Google once more for only the spreadsheets you pick, then let QR to Sheets create a new sheet. Scans arrive as new rows, so keep them out of your existing register grid; the free attendance sheet generator builds a register that reads from them.
Create a scanner link
On the free plan, one link and one sheet: name it after the class, and every row carries that name. Several links need Premium, which adds a link per class, the library or the IT store, each of which can write to its own tab.
Print QR codes for students or assets
Generate QR codes for student IDs or asset tags from the admin panel, or with the free bulk QR code generator. Print and attach them to existing ID cards, timetable sheets, or equipment labels.
Scan, and the register fills itself
The teacher opens the scanner link on the phone that scans and scans each student's card as they arrive. Every scan becomes a row in your Google Sheet within seconds, so a class register takes about a minute.
Watch it: QR attendance in Google Sheets
Is there a free QR code attendance system for schools?
Yes, two. The first costs nothing at all: a Google Form behind a QR code, with responses collected in a Google Sheet. The second is the QR to Sheets free plan, which covers 300 scans in total, one scanner link, one Google Sheet and one phone, with no time limit and no card. That is enough for a once-a-day register in a class of thirty for about two weeks, to see whether the workflow fits before anyone pays.
After that, QR to Sheets costs $7 per phone per month with unlimited scans, because a daily register will pass 300 scans quickly. A free plan of a paid product is not the same as free, so if your budget is genuinely zero, the Google Form is the honest answer and the comparison below shows where it holds up and where it does not. For the general case beyond schools, see our overview of QR code attendance.
A school can also pay yearly: $70 per phone per year (2 months free), paid by card on the billing page. For example, 3 phones cost $21/month or $210/year, and 6 phones cost $42/month or $420/year. Students are never counted, because only the phones that scan are.
Do students need an app or an account?
No. Students never install anything and never sign in. The teacher holds the phone and scans the printed code on each student's ID card or lanyard, so a student with no phone, or a phone the school does not allow in class, is not left out. The teacher does not need an account either: the scanner link opens in the phone's browser. The only person who signs in is the admin who connects the Google Sheet, once.
To print the codes, paste your class list into the free bulk QR code generator for label sheets, or the free QR ID card maker for credit-card size student cards. Neither needs an account, and both make one code per student. Need the grid itself? The free attendance sheet generator turns the same class list into a printable register and a Google Sheets register that marks P from each scan.
The Google Forms route is different on this point. Every student needs a phone to open the form, and if you restrict the form to your school's domain to stop outside submissions, every student also has to be signed in to a school Google account on that phone.
How do students carry their QR code?
Whatever the teacher can scan quickly. Most schools pick one of four: a credit-card size ID card, a badge on a lanyard, a label inside the student planner, or the barcode already printed on the school ID card. QR to Sheets reads QR codes and the common card barcodes, including Code 128, Code 39 and PDF417, but not Codabar, so test one real card before printing anything new; our guide to scanning the ID cards students already carry covers which cards work. For younger children who lose cards, a class code sheet on the teacher's clipboard, one code beside each name, works too.
Put a student ID in the code rather than a name: the code holds only the text you put in it, and a lookup tab in your sheet turns the ID back into a name. The same card then works for leaving the room as well: the free hall pass generator prints passes and a sign-out sheet, and builds a Google Sheets log that works out minutes out from a scan on the way out and one on the way back.
Google Forms or a scanner link: which suits a class register?
The free route is a Google Form behind a QR code. You make the form, link its responses to a sheet, turn the form URL into a QR code and put it on the board. Every student scans it, types a name or ID and submits. It costs nothing, it is genuinely the right answer for an occasional register, and you should try it first.
Where it breaks is a daily register in a room of thirty. It needs every student to be holding a charged phone, it takes as long as the slowest typist, a submission attempted on weak school wifi is lost rather than queued, and nothing stops one student submitting three times. We build the paid alternative, so read the table with that in mind — the honest split is that Forms wins on cost and a scanner link wins on speed and on what happens when something goes wrong.
| Capability | Google Forms QR code (DIY) | QR to Sheets |
|---|---|---|
| Who needs a phone | Every student, to open and submit the form | Only the member of staff scanning |
| Who needs an account | Nobody, unless you restrict the form to your school domain | The admin who connects the sheet. Never the students |
| Cost | Free | Free for 300 lifetime scans on one phone, then 7 USD per phone per month |
| Time to take a register of 30 | As long as the slowest student takes to type and submit | As long as it takes to walk the room |
| No signal in the classroom | The submission fails and is lost | The open scanner keeps scans on the phone and sends them when signal is back |
| Repeat scan of the same student | Silently creates a second row | Saved and flagged with an amber repeat badge by default, or refused if the link is set to Once a day or Once ever |
| Timestamp | Time of submission, in the form owner's timezone | Time of scan, in the workspace timezone you set |
| Student sees other students' data | No, but they do reach a Google-hosted form | No. The scanner screen shows nothing but the scan result |
For named systems side by side, including attendance apps and Google Sheets add-ons, see QR code attendance systems compared.
Several classes, periods and teachers
A homeroom register and period-by-period attendance use the same rows, because every row carries the scan time and the name of the scanner link it came through. On the free plan there is one scanner link, one sheet and one phone: name the link after the class or the teacher, and tell periods apart by the time in the sheet. Several links need Premium, which has unlimited links, so each class, period or room can have its own link and its own tab.
Several teachers can scan with the same link at the same time, and their rows arrive in the same sheet. Each phone that scans counts as one device. Free covers one phone; Premium is $7 per phone per month. Students being scanned never open the link and need nothing. Our guide to several phones scanning into one Google Sheet covers how a department sets that up.
Reports: attendance percentage, absences and late marks
The scan rows are a log, and the report is a formula on a second tab of the same sheet. The free attendance sheet generator builds that tab for you: a register with P for each day a student was scanned, A for a past class day with no scan, and Present, Absent and Attendance % columns per student. To list the students with no scan on one day, see who is absent today.
Late marks compare each scan time with the bell. The time is written as text, so the formula wraps it in VALUE() first; our guide to tardy and late arrival sign-in shows the formulas. The QR to Sheets dashboard counts scans per link; the attendance report itself lives in your Google Sheet, where you can shape it for a report card or your student information system.
What happens when a student is scanned twice?
By default, both rows are written. The scanner shows an amber badge naming how many times that code has been seen in the last twelve hours and says the scan was saved anyway. It is deliberately not an error: a register that quietly discards a scan because it decided the scan was a mistake is worse than one that records too much, and a second scan is often intentional, such as signing a student out at the end of the day.
Each scanner link also has a setting called Accept duplicate scans, with three choices. Always, the default, records every scan as above. Once a day records each student's code once per calendar day in your workspace time zone: a second scan the same day is refused, the scanner tells the teacher the code was already scanned, and the next morning the same card records again, so a daily register runs on one link, free on every plan. Once ever records each code once, for good, which suits a one-off event such as an exam check-in.
Keep Always wherever the same card is meant to be scanned twice in a day: signing students in and out, a library loan and its return, and a trip. Keep Always for a round trip, or the return scan would be refused: our field trip roll call guide shows how to list who is missing at each stop instead.
On Always, de-duplication is a decision you make in your own sheet, where you can see the data. A UNIQUE or QUERY formula on a second tab gives one row per student per day and leaves the raw log intact. Keeping the raw log matters when a parent disputes a mark: the original scans are still there with their times.
Students without phones, and the buddy-scanning problem
The teacher-scans-students model exists mainly because of these two problems. When the teacher holds the only device and scans a printed code on each student's ID card, a student with no phone, a flat battery or a locked-down device is not excluded, and there is no scenario where a student needs to be trusted with the register.
On proxy attendance, be skeptical of any product that claims to solve it. A QR code proves a code was presented; it cannot prove who presented it. No camera-based system can, and the honest control is procedural rather than technical: a member of staff holds the device and sees the face in front of them as they scan. If a student hands over a friend's card in a corridor, no software will catch it.
Patchy school wifi, and why the timestamp matters
If the signal drops, the open scanner keeps saving scans on the phone and sends them when the signal is back, each with its original scan time. A teacher in a sports hall or a mobile classroom who opened the scanner before the signal went keeps scanning, and a scan that happens to be sent twice still produces one row rather than two.
Set your workspace timezone in admin settings before the first real register. Times are written as YYYY-MM-DD HH:MM:SS in that zone, so they sort in time order. Google Sheets stores that value as text, so wrap the column in VALUE() before a date filter or a late-mark formula. A raw UTC ISO timestamp of the kind a hand-built script usually produces is worse: it is off by your offset and needs extra conversion, a failure that is easy to miss until somebody needs a report at the end of term.
Beyond the classroom: open days, parents' evenings and trips
The same scanner link works wherever a member of staff needs to know who arrived. At an open day or a parents' evening, families who registered in advance show a QR pass that staff scan at the desk, and walk-in families fill in a short form on a tablet, so one Google Sheet becomes both the attendance list and the follow-up list. Our guide to school open day check-in with QR codes covers the two queues and when a visitor system is the better fit. For a graduation or a gala with a guest list, see QR code event check-in.
For a trip, scan each student's card onto the coach at every stop, and a formula on a second tab lists anyone not scanned since that stop began. One link covers the whole trip on the free plan; a separate link per leg needs Premium. Our guide to a field trip roll call in Google Sheets has the formula. A fire drill works the same way at the assembly point, as a record of the drill alongside your paper roster, never in place of it: see fire drill headcount in Google Sheets.
A graduation needs each guest ticket to work once: see graduation guest check-in with QR codes. A school store or student bank runs on the same ID cards: see the school store and student bank log. Students logging service hours can scan in and out of each session: track volunteer hours with QR codes.
Staff training and INSET days are attendance too: see QR attendance for seminars, conferences and training sessions for signing staff in and out of a training day.
After the bell, an after-school club needs to know who is still on site: after-school sign-in and sign-out in Google Sheets uses one link for arrivals and one for departures. To list the students with no scan on a given day, see finding who is absent.
What QR to Sheets does not do
It is a fast way to get a register into a Google Sheet, not a student information system, so it is worth being plain about the gaps before you start:
- It does not message parents about absences or late arrivals.
- It does not sync with your student information system. You export the sheet as a CSV file and import it, which our guide to exporting QR attendance to a SIS walks through. Your SIS stays the official record.
- It does not decide who is late or excused. Those are formulas and notes in your sheet.
- It does not prove identity: a scan proves a card was presented, not who presented it.
Where the attendance data goes, and who can see it
Each scan stores the scanned value, the scan time, the scanner link it came through, the device type and a random identifier for the phone, and writes the code, the time and the link name to your school's own Google Sheet. No name or email is stored for a teacher scanning with a scanner link, and students give nothing at all. Scans are private to your workspace: never sold, never shared with other customers or advertisers, and used only to run and support the service.
Reset workspace in Settings deletes the scan records QR to Sheets holds; the rows in your Google Sheet stay yours. Encode a student ID rather than a name. For the questions a school usually asks, see Is QR to Sheets safe for student data?; the privacy policy has the full detail.
Buying for a school
How does a school pay for QR to Sheets?+
By card on the Billing page, monthly or yearly. Premium is $7 per scanning phone per month, or $70 per phone per year, which is two months free, so five phones cost $35 a month or $350 a year. You pay for the phones that scan, never per student. Every workspace starts free for 300 scans on one phone, with no card.
Can the invoice show the school's name and tax ID?+
Yes. At checkout, open the business details and add the school's name, address and tax ID. Paddle, our reseller and merchant of record, issues the invoice in that name, and every payment is listed in the payment history on the Billing page.
Our school is tax exempt. How does that work?+
Paddle, our reseller and merchant of record, handles sales tax. A tax-exempt school requests the exemption from Paddle at paddle.net, with its exemption certificate and the details of the purchase.
Common questions
Do teachers need to install an app?+
No. The teacher opens the scanner link in Safari or Chrome on an iPhone or Android phone. Nothing to install and no account needed for scanning. Each phone that scans counts as one device, and the free plan covers one phone.
Does QR to Sheets work with a school Google account?+
Yes, unless your school's Google admin restricts outside apps. In that case the teacher sees Google's "Access blocked" page when connecting, and a Google Workspace admin allows QR to Sheets once in the Admin console; the steps are at qrtosheets.com/google-workspace-admin. Students never sign in or open the scanner link, so the app does not need to be allowed for student accounts.
Can I track both attendance and asset loans?+
Yes, with separate scanner links for each purpose: one for class registers, one for library loans, one for IT equipment, each of which can write to its own Google Sheets tab. Free has one active scanner link; several links need Premium at $7 per phone per month, with unlimited links.
Can I use this for clubs and after-school activities too?+
Yes. On the free plan, use the one link and tell sessions apart by date and time. Premium adds a scanner link for each club or activity, so every row names its club. Works for any situation where you need to track who attended and when.
Can parents or external people see the attendance records?+
Only if you share a view-only link to the Google Sheet. The scanner link itself gives no access to the spreadsheet — only the admin can view the data.
Does it work if the school WiFi is patchy?+
If the signal drops, the open scanner keeps saving scans on the phone and sends them when the signal is back, each with its original scan time, so the teacher keeps scanning without waiting for the signal.
What happens if a student is scanned twice?+
By default both scans are saved and an amber badge tells the teacher it is a repeat, showing how many times that code has been seen within a 12-hour window, so a genuine second scan at the end of a lesson is still recorded. For a daily register, set the link's Accept duplicate scans to Once a day: each student is recorded once per calendar day in your workspace time zone, a second scan the same day shows "Already scanned" and is not added, and the next day the card records again. Once ever records each code once, for a one-off exam check-in; keep Always for signing in and out or a round trip, where the same card is scanned twice in a day.
What about students who do not have a phone?+
Nothing is required of the student. The teacher holds the only phone and scans a printed code on the student's ID card, lanyard or a class code sheet. This is the main reason the teacher-scans-students model suits schools better than asking each student to scan a code on the board.
Can a student scan a friend's code to mark them present?+
A QR code proves a code was presented, not who presented it. No QR system can tell you otherwise, and any product claiming it can is overstating. The practical control is that a member of staff holds the scanning device and sees the person in front of them.
Can a school pay yearly?+
Yes. QR to Sheets Premium is $70 per phone per year (2 months free), paid by card on the billing page, or $7 per phone per month. For example, 3 phones cost $21/month or $210/year, and 6 phones cost $42/month or $420/year. Students are never counted, only the phones that scan.
Can two teachers scan at the same time?+
Yes. One scanner link serves any number of phones simultaneously, and rows arrive in the same sheet. The device limit is per workspace rather than per link, so two phones scanning at once needs two device slots at $7 each per month.
Are the timestamps in our school's local time?+
Yes, once you set the workspace timezone in admin settings. Times are written as YYYY-MM-DD HH:MM:SS in that zone, so they sort in time order. Google Sheets stores them as text, so wrap the column in VALUE() before date filters or late-mark formulas; a raw UTC ISO timestamp would be off by your offset as well.
How do I get the register into our SIS or MIS?+
Export the Google Sheet as CSV and import it, which is what most school systems accept. Because the data is in your own spreadsheet rather than locked inside a vendor database, you can reshape it with a formula first to match whatever column order your system expects.
Also included
No code to scan? Collect it with a form instead.
Attendance is a scan, but the sign-ups around it are not: trip consent, after-school clubs, parent evening slots and new-student registration all arrive as answers rather than barcodes.
Build a form, share the link or embed it on your own page, and every submission lands as a row in the same Google Sheet and fires a webhook the moment it arrives, so Zapier, Make, n8n or your CRM picks it up in real time. Each person can get their own QR code by email, which you scan to record their arrival. Included with the paid plan; the free plan covers one form and ten submissions.
How forms and check-in fit togetherRelated guides
- Daily classroom attendance for teachers, with QR codes and Google SheetsHow a teacher takes daily class attendance with QR codes: print one card per student, scan the room from your phone, read absences in Google Sheets.Read the guide
- 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 code sign-in sheet: replace the paper clipboard with Google SheetsMake a QR code sign-in sheet in minutes: a free printable poster that opens a Google Form linked to a Sheet, plus sign-out and who is still in.Read the guide
- Export QR attendance from Google Sheets to a SISThe sheet captures, the SIS is the record. Match the student ID, turn scans into one mark per student per session, export a CSV, and keep the raw scan log.Read the guide
Start your QR code attendance register today
Free to start. No credit card. No app for staff.
Start for free