Getting scan data into Google Sheets
Practical, complete guides from QR to Sheets for the workflows people actually run. Each one covers the free do-it-yourself route first, then where it stops working.
Find the guides for your work
Narrow 41 guides down to the ones written for your situation.
Showing all 41 guides
Comparison
QR code attendance systems compared: which fits a school, a club or a workplace
Google Forms, Jotform, Sheets add-ons, Clappia, AttendMe, Jibble and QR to Sheets compared on cost, apps, proxy check-ins and where the data goes.
10 min readReadData quality
How to handle duplicate QR scans in Google Sheets
Record every scan, flag the repeat, dedupe in the sheet: UNIQUE, COUNTIFS and QUERY formulas for a clean tab, and why refusing a repeat scan loses data.
8 min readReadTime and presence
Can QR code attendance stop buddy punching?
No, not on its own. What a QR scan proves, how proxy sign-in happens, which workflow changes make it harder, and when you need a supervised time clock.
8 min readReadAttendance guide
QR attendance for people without smartphones
Nobody being counted needs a phone. Printed QR cards, one staff scanner, a shared tablet, and typed entry for a forgotten card, all into Google Sheets.
7 min readReadCheck-in guide
QR check-in kiosk on a shared tablet or phone
One tablet at the door, everyone scanning, one billed device. How to set up a shared QR check-in station for Google Sheets, and what it cannot tell you.
8 min readReadData quality
Why Google Sheets timestamps show the wrong time
Hours off, or right but will not sort? The spreadsheet time zone, the Apps Script time zone or UTC text is the cause. How to fix each, and the old rows.
8 min readReadAttendance guide
Export QR attendance from Google Sheets to a SIS
The 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.
8 min readReadSecurity guide
QR guard tour checkpoints logged to Google Sheets
QR tags at each checkpoint, guards scan from a phone browser, every visit lands in Google Sheets. How to spot a missed checkpoint, and the honest limits.
8 min readReadComparison
Orca Scan alternative for scanning into Google Sheets
Orca Scan lists Google Sheets on its Business plan; QR to Sheets writes to your sheet from a browser link, per device. Compared, including where Orca wins.
8 min readReadTime and presence
QR code clock in and clock out into Google Sheets
Log staff clock-in and clock-out in your own Google Sheet with two scanner links. The free Google Forms route, where it breaks, and why it is not payroll.
10 min readReadTime and presence
How to calculate hours worked from scan rows in Google Sheets
Turn clock-in and clock-out scan rows into hours per person per day with real Google Sheets formulas, including overnight shifts and missed clock-outs.
9 min readReadTime and presence
How staff can clock in without an app or an account
Record staff arrival with no app and no login: a paper sheet, a Google Form, a shared kiosk or a browser scanner link. What each costs and where it breaks.
8 min readReadTime and presence
QR time clock pricing: per employee versus per device
Most time clocks charge per employee. Where a free plan covers you, where per-device pricing is cheaper, and where it costs more, with worked examples.
8 min readReadMigration guide
AttendMe is shutting down: where to move your QR attendance tracking
AttendMe shuts down on 31 December 2026. What to export first, what Google Forms can replace, and how to move QR attendance into a Google Sheet you own.
10 min readReadLead capture guide
How to send a confirmation email after a form submission
Email people after they submit your form: the Google Forms receipt, Apps Script with MailApp, or a built-in confirmation email. Quotas and deliverability.
10 min readReadRegistration guide
How to give every form submission its own QR code for check-in
Give every form submission its own QR pass: the free Google Forms plus Apps Script route, where it stops, and how to issue, deliver and scan a unique code.
10 min readReadLead capture guide
How to send a form submission to your CRM and a Google Sheet at once
Send each form submission to a CRM and a Google Sheet at once: Google Forms plus Apps Script, Zapier or Make, or a native webhook, and where each breaks.
11 min readReadQR design guide
How to put your brand colours on a QR code without breaking it
Brand colours on a QR code without breaking it: dark modules, light background, enough contrast and a quiet zone. What breaks, and how to test first.
8 min readReadRegistration guide
How to run event registration and QR check-in with a Google Sheet
Sign-ups into a Google Sheet, a QR code per registrant, check-in at the door with any phone camera. The free Google Forms route first, and where it stops.
12 min readReadRemote events guide
How to run event check-in when you are not at the venue
Hand event check-in to venue staff you have never met, from another country: no hardware to ship, no licences to buy, no app install to explain.
11 min readReadCheck in / check out guide
Check in / check out with QR codes and Google Sheets
A check in / check out QR code for people or equipment: two scans, one Google Sheet, and one formula that lists who or what is still out. Free to build.
10 min readReadComparison
SheetLabel alternative: per-device instead of per-user scanning
SheetLabel bills per user; QR to Sheets bills per scanning device and the scanners need no account. An honest comparison, including where SheetLabel wins.
8 min readReadComparison
Scan to Sheets alternative: no app install, no per-person account
Scan to Sheets is a 130 MB phone app; QR to Sheets is a link in the phone browser. An honest comparison, including where the app is the better choice.
8 min readReadSign-in guide
QR code sign-in sheet: replace the paper clipboard with Google Sheets
Make a QR code sign-in sheet that writes to Google Sheets: the free Google Forms way, where it breaks, and a sign-out that actually gets recorded.
10 min readReadQR generation guide
How to generate QR codes from a Google Sheet
Turn a Google Sheets column into QR codes a one-cell IMAGE formula, an Apps Script loop, or a free bulk generator with print-ready label sheets.
9 min readReadInventory guide
Free barcode scanner apps for Google Sheets inventory: what actually works
The free ways to scan stock into Google Sheets (Google Forms, Apps Script, phone apps, scanner links) and where each stops being free enough to trust.
11 min readReadNonprofit guide
Church and nonprofit attendance with QR codes and Google Sheets
Track service attendance, volunteer shifts and children's check-in in a Google Sheet you own, without anyone installing an app or making an account.
10 min readReadMembership guide
Gym, studio and class check-in with QR codes and Google Sheets
Class and membership check-in in a Google Sheet you own: no member app, no per-member licence, and it keeps working when the studio wifi drops.
10 min readReadLibrary guide
Small library book checkout with barcodes and Google Sheets
Run a lending log for a classroom, school, church or community library with existing ISBN barcodes and a Google Sheet, without buying a library system.
10 min readReadHospitality guide
Restaurant delivery and stock intake logging with Google Sheets
Scan every kitchen delivery and stock count into a Google Sheet, so short deliveries and price creep show up in your own data instead of going unnoticed.
10 min readReadComplete answer
How to scan a QR code and have it appear automatically in Google Sheets
Scan QR codes and barcodes to Google Sheets automatically: a Google Form, Apps Script, a phone app or a browser link. What each needs and where it breaks.
8 min readReadTeacher guide
Daily classroom attendance with QR codes and Google Sheets
How 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.
10 min readReadDevice loans guide
Chromebook and device loan checkout with QR codes and Google Sheets
Stop tracking laptop and tablet loans on a sticky note. Scan devices out to a student and back in, with the whole history in a Google Sheet you own.
9 min readReadWarehouse guide
Warehouse cycle counting with a phone and Google Sheets
Replace the annual stock-take with small weekly cycle counts: scan shelf and item codes into a Google Sheet, then read the variance.
9 min readReadAccess control guide
QR code site access control and shift sign-in with Google Sheets
Log who is on site, every shift, with QR codes and a Google Sheet: contractor sign-in, induction checks, and a live roll call for fire safety.
9 min readReadInventory guide
How to scan barcodes into Google Sheets for inventory
Barcode scans into Google Sheets three ways: a free Google Form, an Apps Script web app or a hosted scanner link, and what each costs to set up and run.
9 min readReadAttendance guide
How to take QR code attendance in Google Sheets for free
Free 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.
8 min readReadEvents guide
How to run QR code event check-in from a Google Sheet, starting free
Run QR event check-in from a Google Sheet, starting free: guest codes, scanning at the door, handling the queue, and surviving bad venue wifi.
9 min readReadMobile guide
How to scan barcodes into Google Sheets on iPhone and Android
Phone-only ways to scan barcodes into Google Sheets on iPhone and Android: the camera, Google Forms, browser scanners, and the camera permission traps.
7 min readReadComparison
Google Forms versus a scanner link for collecting field data
Where a free Google Form is the right answer for field data collection, where it breaks down, and what a dedicated scanner link changes, compared honestly.
7 min readReadAsset guide
QR code asset tracking in Google Sheets for equipment and device loans
Track equipment, tools and device loans with QR labels and a Google Sheet: what to encode, how to model check-out and check-in, and how to stay auditable.
8 min readRead
Reference: column mapping
How to split one scanned code into separate spreadsheet columns, when not to bother, and eight ready-made setups with a copy-paste header row. Read the column mapping guide.
Free tool: bulk QR code generator with printable label sheets
Most of these guides start with “print one code per student, per asset, or per shelf.” This does that part for you — paste a list, print the sheet. No account needed. Open the free QR tool.
Ready to try it on your own Sheet?
Free tier covers 300 scans. Your team opens a link and scans — no app install, no accounts for them to create.
Start for freeNo credit card required