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.
Updated
Find the guides for your work
Narrow 61 guides down to the ones written for your situation.
Showing all 61 guides
Events and trade shows
Trade show lead capture: scan visitor badges into a Google Sheet
Scan visitor badges at your stand into a Google Sheet from any phone browser: the free routes, badge formats, which rep scanned, and when a lead app wins.
8 min readReadStudent data facts
Is QR to Sheets safe for student data? What it stores, who sees it, how to delete it
What QR to Sheets stores when staff scan a student code, who can see it, where it is kept, how to delete it, and how a school Google admin allows it.
9 min readReadSchool office guide
How to track tardies in Google Sheets: a late sign-in log the front office can scan
Log late arrivals at the front office in Google Sheets, count tardies per student and flag repeats. Free Google Form route first, then scanning ID cards.
15 min readReadField trip guide
Field trip roll call in Google Sheets: scan students on and off the bus and see who is missing
Take a field trip roll call in Google Sheets: scan each student's QR card every time they board and list who is missing. Free checkbox route first.
14 min readReadSchool drill guide
Fire drill headcount in Google Sheets: who is still missing at the assembly point
Record a fire drill headcount at the assembly point in Google Sheets and list students not yet accounted for. A drill record, not a safety system.
14 min readReadGraduation guide
How to check in graduation guests with QR codes and Google Sheets
Check in graduation guests from a Google Sheet: one QR ticket per guest, a limit per graduate, each ticket scanned once at the door. Free route first.
14 min readReadSchool store guide
How to run a school store or student bank with ID cards and Google Sheets
Run a school store or student bank from Google Sheets: log deposits and purchases by student ID, keep balances with formulas, flag overspending.
13 min readReadBarcode scanner guide
How do I timestamp USB barcode scans in Google Sheets?
Use a USB or Bluetooth barcode scanner with Google Sheets and record the time of every scan, free, with a short Apps Script. Why NOW() is not enough.
10 min readReadVouchers and tokens
How to make single-use QR codes that redeem only once
A QR code cannot limit itself to one use; whatever scans it must check a record. Free Google Sheets checks, their limits, and refusing a second scan.
10 min readReadNonprofit guide
How to track volunteer hours with QR codes in Google Sheets
Log volunteer sign-in and sign-out in Google Sheets and total hours per shift and per month, with formulas that flag a missed sign-out instead of guessing.
11 min readReadAfter-school guide
How to run after-school sign-in and sign-out with QR codes and Google Sheets
Replace the paper after-school sign-in and sign-out sheet: a QR card per child, a staff phone at the door, and a live list of who is still here.
15 min readReadSpreadsheet guide
How to find who is absent: compare a roster with today's sign-ins in Google Sheets
Formulas that list who has not signed in: compare a roster with Google Form responses or scan rows, text timestamps included, for any date or session.
14 min readReadAttendance guide
How to scan student or staff ID cards for attendance into Google Sheets
Scan the ID cards students or staff already carry into Google Sheets: which barcodes a phone reads, plus the free USB scanner and Google Form routes.
13 min readReadTeam scanning guide
Can several phones scan into one Google Sheet at once?
Yes. One scanner link on several staff phones writes to one Google Sheet. How rows are told apart, what each phone costs, and the free routes.
11 min readReadSpreadsheet guide
How to show the name for a scanned ID in Google Sheets
Scan an ID, see the name: XLOOKUP or VLOOKUP from a People tab, a Report tab that covers new rows, Not on the list, and who has not scanned today.
11 min readReadGoogle Sheets guide
Let staff add rows to a Google Sheet without sharing it
Let temps, volunteers and contractors add rows with no edit or view access: Google Forms, protected ranges, an intake sheet, Apps Script or a scanner link.
10 min readReadSchool events guide
How to run school open day check-in with QR codes and a Google Sheet
Check 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.
11 min readReadEvents and training
QR attendance for seminars, conferences and training sessions
Record who attended each seminar, conference session or training workshop: one scanner per room, one Google Sheet, a per-session report and CPD minutes.
11 min readReadComparison
Free event check-in apps for Google Sheets, compared: guest lists, QR tickets and the door
Google Forms, QR Code Ticket Per Row, Jotform, TicketSignup, QRLynx, QRWink and QR to Sheets compared for checking guests in from a Google Sheet.
11 min readReadUniform and PPE guide
Uniform and PPE issue log with QR codes in Google Sheets
Log every uniform and PPE item handed out: who got which item and size, and when. Count allowances and stock on hand in a Google Sheet you own.
11 min readReadComparison
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 phone. 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 phone 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.
9 min readReadSign-in guide
QR code sign-in sheet: replace the paper clipboard with Google Sheets
Make 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.
12 min readReadQR generation guide
How to make QR codes in Google Sheets, with a formula that still works
Generate QR codes in Google Sheets: a one-cell IMAGE formula that still works, an Apps Script loop, an add-on, or a free bulk generator for label sheets.
10 min readReadInventory guide
Free barcode scanner apps for Google Sheets, compared: what actually works
Barcode Sender, Orca Scan, Barcode to PC, GearChain, AppSheet, Google Forms, a USB scanner and a scanner link: what each does free, and where each stops.
12 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 scans wait on the phone if 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 QR codes into Google Sheets automatically
Scan QR codes and barcodes to Google Sheets: a Google Form, Apps Script, AppSheet, a phone app or a browser link. Which is easiest, and where each breaks.
10 min readReadTeacher guide
Daily classroom attendance for teachers, 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.
9 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 readReadEquipment guide
Equipment checkout with QR codes in Google Sheets: tools, kit and assets
Equipment and tool checkout with QR labels and a Google Sheet: scan items out and back in, see who has each one now, and keep a log you can audit.
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