No app, no account for field staff

Scan QR codes directly into Google Sheets — no app, no account.

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.

  1. 1Sign in with Google
  2. 2Pick or create a Sheet
  3. 3Scan with your phone
Works on any phone, no app install
Keeps scans if signal drops
You control the spreadsheet
ScannerLive
SKU-48172saved to your Sheet

Sheet sync

Today 42
SKU-48172
LOT-8841
REF-5530
ASSET-119

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

Deploy in minutes. Your team starts scanning immediately.

Staff need nothing but a URL

Workers open the scanner link in any phone browser — Android, iOS, or desktop. No app store, no shared accounts, no IT ticket needed.

Scans survive connectivity gaps

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.

Data flows straight into Google Sheets

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

Rather watch than read?

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

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.

4-minute walkthrough

Want every feature explained? Watch this.

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

QR code generator 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.

End-to-end in one tool

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

Admin sets up. Staff just scan.

No developer setup, no IT rollout. From sign-in to deployed scanner link in under five minutes.

01

Admin: create a scanner link

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.

02

Admin: share the URL

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.

03

Staff: open link, scan, done

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

From warehouses to events — any team, any workflow.

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 Sheets

Site 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 Sheets

Warehouse 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 scanning

Event 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 codes

Maintenance 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 logs

Patrol 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 logs

Deliveries 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 scans

Visitor 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-in

Field 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 capture

Also included

Capture a lead, and it is in your CRM before they close the tab.

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.

  • Real-time webhook on every submission: route a lead into your CRM, fire a Slack alert, start an email sequence, or trigger anything a no-code tool can reach.
  • Every field arrives keyed by both id and visible label, dropdown choices included, so a Zap shows readable names instead of raw ids.
  • A delivery that fails is tried again, so a brief outage on your side delays the event rather than losing the lead.
  • A live CMS, not a one-time build: add, reorder, rename or hide fields on a form that is already collecting, and the change is live immediately. No republishing, no new URL, and the embed on your landing page updates itself.
  • Editing never rewrites history. Every response keeps the fields exactly as they were when it was submitted, so old rows stay readable after you change the form.
  • Starts with name, phone with a country code, email and message.
  • Design it in your own colours, or start from one of eight ready palettes — also editable while live.
  • Embed it on Instapage, Wix, Squarespace, WordPress or Webflow with one snippet.
See how registration and check-in fit together

Registration and check-in, one place

  1. 1They sign upSomeone fills in your form on their phone, from your landing page or a link.
  2. 2They get a QR codeIt appears on screen and in their confirmation email, styled the way you want.
  3. 3You scan them inAny phone camera reads it at the door. One tap records the arrival, once, in QR to Sheets.

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.

Free tool · no signup

Need the QR codes first? Make and print them free.

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.

Open the free QR tool Free forever, on every plan. Included with Free and Premium.

For a class list, three more free tools, also with no signup:

Pricing

Simple, per-phone 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.

What counts as a device? Each phone that scans counts as one device. Free covers one phone; Premium is $7 per phone per month. People being scanned never open the link and need nothing. On Premium, one link can run on several phones at once, and you can scale up or down each month. Examples: 3 phones: $21/month or $210/year. 6 phones: $42/month or $420/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.

Free

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.

$0
  • 1 scanning phone
  • 1 active scanner link
  • 300 scans total
  • 1 Google Sheet connection
  • 1 form with 10 trial submissions
  • Device-local CSV backup
  • QR code generator (PNG, watermarked)
  • Bulk QR codes + printable label sheets (free, no signup)
For several phones

Premium

Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month.

$7/phone/month

or $70 per phone per year (2 months free), paid by card

  • Several phones scanning at the same time, one licence per phone
  • Unlimited scanner links
  • Unlimited scans
  • Unlimited Google Sheet connections
  • 2 live forms per device, embeddable anywhere
  • Edit a form while it is live: change fields, wording and colours without republishing
  • Unlimited submissions with confirmation emails off
  • Real-time webhooks: every submission into Zapier, Make, n8n or your CRM
  • 2,000 confirmation emails a month, +500 per extra device
  • Each link gets its own Sheet destination
  • Scan history & cloud backup
  • Customisable dashboard widgets
  • QR code generator (watermark-free PNG + SVG)
  • Bulk QR codes + printable Avery label sheets

Enterprise

For large distributed teams, multi-site deployments, and high-volume field operations. Custom pricing, dedicated onboarding, and SLA support.

Custom
  • Everything in Premium
  • Custom device count
  • Volume pricing
  • Dedicated onboarding
  • SLA and priority support
  • Custom branding options
  • Invoice billing available

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

Running an event? Send QR invitations and scan guests in at the door.

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 Events

Why a scanner link

Faster than a form, simpler than an app

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.

Nothing to install

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.

A real scanner, not typing

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.

Nothing to build or fix

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

How scanning into Google Sheets actually works

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

Common questions

How do I scan QR codes into Google Sheets?

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.

Can QR to Sheets also make the QR codes?

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.

Is QR to Sheets safe to use with student data?

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.

Is QR to Sheets free, and what does it cost?

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.

How do I take daily class attendance in Google Sheets with QR codes?

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.

How do I stop duplicate QR scans in a Google Sheet?

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.

What is the best way to scan barcodes into Google Sheets from a phone?

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.

Scanning in five minutes. No app install, no training.

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