88-second tour
In a hurry? Watch this.
Every feature in under a minute and a half. On-screen text, no narration, so it works with the sound off.
QR to Sheets is a no-app QR code and barcode scanner for Google Sheets that runs as a web app in any phone browser, for attendance, check-in, inventory and event entry: open the scanner link on the phone that does the scanning, and every badge, ticket or label it scans lands as a row in your Google Sheet. The people being scanned need nothing: no app, no account.
Free for your first 300 scans on one phone, no card needed. More phones scanning at the same time: $7 per phone per month.
Sheet sync
Keeps scans if signal drops
The open scanner saves scans on the phone and sends them when the signal is back. CSV export available.
Admin controlled
Admins choose the Sheet. Operators only scan and confirm.
Why it works
Workers open the scanner link in any phone browser — Android, iOS, or desktop. No app store, no shared accounts, no IT ticket needed.
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.
Connect the spreadsheet your ops team already uses. Each QR scan appends a timestamped row to Google Sheets — no formulas, no imports, no middleware.
Watch instead
See QR to Sheets do its job: a phone scans a QR code and the row lands in your Google Sheet. Pick the video that fits your time.
88-second tour
Every feature in under a minute and a half. On-screen text, no narration, so it works with the sound off.
4-minute walkthrough
A narrated four-minute walkthrough, from connecting your Google Sheet to your first scan. Captions included.
More on the videos page: Pip's walkthrough, a barcode tour and two Shorts, each with a transcript.
Also included
Create QR codes for your scanner URLs, asset tags, or any other content right inside the admin. Customise dot shapes and colours, then download and print for signs, lanyards, or equipment labels.
Print QR codes from the admin, deploy scanner links to field staff, and watch every scan arrive in Google Sheets. The entire workflow — from label creation to live data — stays in one place.
How it works
No developer setup, no IT rollout. From sign-in to deployed scanner link in under five minutes.
Sign in with Google, then approve a second, separate permission for the one sheet you pick — we never see the rest of your Drive. Choose the tab that receives scans and you are done in under a minute.
Open the scanner URL on the phone that will do the scanning: send it by WhatsApp or email, or scan the link's own QR code from your screen. No account or app needed on that phone.
Workers open the URL in any phone browser, allow camera access once, and start scanning. Every scan writes a timestamped row to your Sheet instantly.
Example workflows
School attendance and assets
A teacher opens one link and scans student IDs or equipment tags. Clean records in Google Sheets, and students need nothing.
Class attendance, library books, IT assets, lab equipment.
School attendance in Google SheetsSite attendance
Log who's on site in real time. Workers tap a URL and scan their badge — every entry writes a timestamped row straight to Google Sheets, no sign-up, no app, no morning queue.
Job sites, shift logs, subcontractor sign-in, safety inductions.
Site attendance in Google SheetsWarehouse inventory
Count stock on any spare phone. Every scan lands in Google Sheets instantly — no handheld scanners, no software licences.
Bin counts, goods-in, dispatch checks, cycle counts.
Warehouse inventory scanningEvent check-in
Share one link with door staff before gates open. Each guest scan goes directly into Google Sheets — no App Store, no shared accounts.
Guest lists, VIP entry, seminar attendance, ticket validation.
Event check-in with QR codesMaintenance and inspections
Send each technician a scanner link. They scan asset tags on-site and the log writes itself to Google Sheets.
Equipment tags, inspection rounds, fault reports, service logs.
Maintenance and inspection logsPatrol and job logs
Create one link per route. Staff scan checkpoints as they go — every checkpoint scan writes to Google Sheets live, with no manual entry.
Guard rounds, cleaning checks, contractor visits, site walkthroughs.
Patrol checkpoint logsDeliveries and receiving
Scan delivery barcodes straight into Google Sheets. If the signal drops in the loading bay, the open scanner keeps saving scans on the phone and sends them when the signal is back.
Inbound deliveries, dispatch points, manifests, returns.
Delivery and receiving scansVisitor and contractor logs
One scanner link per entry point. Every visit is timestamped and appended to Google Sheets — no receptionist software needed.
Building access, restricted rooms, multi-site offices.
Visitor and contractor sign-inField team data capture
Give field crews a link and they start scanning immediately. Every scan goes straight into Google Sheets — the same spreadsheet the ops team already uses.
Route scans, proof of delivery, field surveys, meter reads.
Field team data captureAlso included
Build a form, share the link or embed it on your own landing page. Every submission lands as a row in the same Google Sheet your scans go to and fires a webhook the moment it arrives, so Zapier, Make, n8n or your CRM picks it up in real time. No export, no nightly sync, no copy and paste.
Registration and check-in, one place
QR to Sheets Forms is part of the paid plan. The free plan includes one form and ten trial submissions, so you can watch a row, a QR code and an email all arrive before you pay anything.
Paste a class list, an asset register, or a column straight out of Google Sheets and get a printable QR code for every row. No account, no watermark, no expiry, and nothing is uploaded — the codes are generated in your browser. Prefer to stay inside Google Sheets? =IMAGE() with a QR image service makes one code per row (it sends each value to that service), and the formula guide has the version that still works.
Up to 500 codes at once
One per line, or paste a spreadsheet column.
Avery-compatible label sheets
L7159 and L7165 on A4, 5160 and 5163 on Letter, or plain paper.
Print or download a ZIP of PNGs
Sized so printed codes stay scannable.
For a class list, three more free tools, also with no signup:
Pricing
Free to try. No credit card. Start with 300 scans on one phone. When more than one phone needs to scan at the same time, add a phone for each: $7 per phone per month, or $70 per phone per year.
Work out your team's price
Free covers one phone. Premium is $7 per phone per month, or $70 per phone per year (2 months free), for each phone that scans.
How many phones will scan?
$7 x 3 = $21 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.
Try the whole workflow on one phone: create a scanner link, open it on the phone that scans, and see scans arrive in Google Sheets.
Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month.
or $70 per phone per year (2 months free), paid by card
For large distributed teams, multi-site deployments, and high-volume field operations. Custom pricing, dedicated onboarding, and SLA support.
Scans go into your own Google Sheet. QR to Sheets opens only the spreadsheets you pick or create, and your scans are private to your workspace: never sold, and never shared with other customers or advertisers. No credit card required for the free tier.
New add-on
The Events add-on imports your RSVP list from Google Sheets, sends personalized QR invitations, and writes check-in timestamps back to your spreadsheet automatically.
Learn about EventsWhy a scanner link
QR to Sheets is built for one job: getting a scan from a phone into your Google Sheet with nothing for the person scanning to install, type or learn.
Staff open the scanner link in Safari or Chrome on the phone they already have. No app on every phone, and no account for the person scanning.
The phone camera reads QR codes and barcodes, and every scan becomes a new timestamped row in your Google Sheet. Nobody types a name or an ID.
No script to write or keep working. 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.
Guides
Step-by-step setups for attendance, check-in and inventory, with the Sheet formulas that turn your scan rows into answers.
QR code attendance (free, no app)
Take attendance into your own Google Sheet from a phone browser. Nobody being scanned needs an app, and the first 300 scans are free.
How to take QR attendance in Google Sheets, free
Why having staff scan students beats having students scan a shared code, and what it costs.
QR code sign-in sheet in Google Sheets
Reception, contractors and members. Why sign-out needs two links rather than one in-or-out dropdown.
Daily classroom attendance with QR codes in Google Sheets
One card per student, the teacher scans the room from a phone, and absences are read straight from the Sheet.
Who is absent? List missing names in Google Sheets
Formulas that compare a roster with today's scan rows, for any date or session.
After-school sign-in and sign-out sheet in Google Sheets
A QR card per child, a staff phone at the door, and a live list of who is still here.
Can several phones scan into one Google Sheet at once?
Yes: one scanner link on several staff phones, how the rows are told apart, and what each phone costs.
Scan student ID cards for attendance in Google Sheets
Which barcodes a phone reads on the cards students already carry, straight into the Sheet.
Handle duplicate QR scans in Google Sheets
Record every scan, one per day, or one per code ever, and what the scanner shows when a code comes back.
QR code check in and check out in Google Sheets
People and equipment, both directions, and the formula that shows who is still in.
Scan a QR code straight into Google Sheets
Point a phone at a code and a timestamped row appears: the setup, the columns, and what each row holds.
Generate QR codes from a Google Sheet
Turn a column of IDs into printable QR labels with the free QR to Sheets bulk generator.
FAQ
Open a QR to Sheets scanner link on the phone that scans. You connect a Google Sheet, create a scanner link and open it in Safari or Chrome: every QR code or barcode it reads becomes a new timestamped row, with no app and no account for the person scanning. It is free for 300 scans on one phone, then $7 per phone per month. Unlike a scanning app there is nothing to install on each phone, and unlike a form or a script nobody types and nothing needs building.
Yes. Copy a column from your Google Sheet and paste it into the free QR to Sheets bulk generator at qrtosheets.com/tools/bulk-qr-codes: it makes up to 500 printable codes in the browser with no signup, no watermark and no expiry, and a QR to Sheets scanner link then scans them back into the same Sheet.
A QR to Sheets scan records the scanned code, the time, the scanner link name, the device type and a random device ID. Students get no account. Rows go to your school's own Google Sheet; QR to Sheets keeps a copy in the United States until you reset or delete the workspace. Encode student ID numbers, not names.
Yes, free to start: 300 scans in total on one phone, no card. Free includes 1 scanner link, and each phone that scans counts as one device. Premium is $7 per phone per month, so several staff can scan into the same Sheet at once, with unlimited scanner links and unlimited scans; paying yearly is $70 per phone per year (2 months free), paid by card. People being scanned never open the link and need nothing.
With QR to Sheets, the teacher prints one QR code per student and scans each one with a phone browser, and every scan adds a timestamped row to the class Google Sheet. A class of thirty takes under a minute, the first 300 scans are free, and with the link's Accept duplicate scans set to Once a day a student scanned twice in one day is recorded once. Students need no phone of their own.
Each QR to Sheets scanner link has an Accept duplicate scans setting with three choices: Always, the default, records every scan and shows an amber Saved anyway badge when a code repeats within 12 hours; Once a day records each code once per calendar day in your workspace time zone, which suits a daily register; and Once ever records each code once, which suits a one-time ticket. Keep Always for check in and check out, where the same code is meant to be scanned again the same day.
Use a QR to Sheets scanner link: workers open it in Safari or Chrome and scan barcodes with the phone camera, with no app and no account, free for 300 scans and then $7 per phone per month. Each scan becomes a timestamped row in your Google Sheet, and the same link works on every phone you add.
Create a scanner link, share the URL, and watch the data flow into Google Sheets. No app install, no IT rollout, no training required.
Page updated