All guides
Complete 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.

By the QR to Sheets team 10 min readUpdated

Short answer

The easiest way to scan QR codes into Google Sheets, with no code to write and no app to install, is a browser scanner link such as QR to Sheets: open the link on a phone, scan, and each code becomes a timestamped row.

The other routes are a phone scanner app such as Scan to Sheets or Sheetify, which each person installs, and Google AppSheet, whose scanning works only in its mobile app on the Core or Enterprise plan.

The free routes are a Google Form, which has no camera scanner of its own, and an Apps Script web app you maintain yourself; QR to Sheets is free for 300 scans on one phone, then 7 USD per phone per month.

Looking for the other direction, making a QR code for every row of a sheet? The section on making the codes, further down this page, covers the IMAGE formula and the free QR to Sheets bulk QR code generator, and the two halves meet when you scan those printed codes back into the same Sheet.

The short answer: a QR code by itself does not write anywhere. Something has to read the code and then append a row. There are five established ways to do that with Google Sheets, and the right one depends almost entirely on who is holding the phone.

Which method is easiest?

With no code to write and nothing to install, the easiest way is a scanner link: in QR to Sheets you connect a Google Sheet, create a link and open it in any phone browser, and each code scanned becomes a timestamped row. Free for 300 scans on one phone. A Google Form has no scanner of its own, and AppSheet scans only in its mobile app on AppSheet Core or Enterprise.

We make QR to Sheets, so weigh this with that in mind. The table states each route as its maker documents it, read in November 2026, except two notes of ours: the phone-app row was read in October 2026, and the Apps Script camera note comes from our own check of public deployments. The sections below say where each one breaks. If one person scans alone, a phone app is fine; at one fixed desk, a USB scanner is hard to beat.

Six ways to scan QR codes into Google Sheets, as each maker's own documentation stated them on 2026-11-21 (the phone-app row on 2026-10-15; the Apps Script camera note is our own check of public deployments). QR to Sheets is our product.
RouteCost, as statedWhat each person scanning needsCamera scannerWhere it stops
Google Form linked to a SheetFreeA phone browserNone: Google Forms has no scan question type, so the code is read with the camera app and pasted inA paste per code, and a submission made with no signal is lost
Google Apps Script web appFreeA phone browser; no Google account if you deploy it for anyoneOnly the one you build, with a library such as Html5-QRCode; since February 2026 some deployments cannot open the camera inside Google's pageYou write and maintain it, within quotas of 30 simultaneous executions per user
Google AppSheet appScanning is on the Core plan, 10 USD per user per month, or Enterprise; Core is included in most paid Google Workspace editionsThe AppSheet mobile app and a Core or User Pass licenceYes, in the AppSheet mobile app only, not in a web browserYou design the app, and every user, or every device on an app without sign-in, counts as a licensed user
Phone scanner app such as Scan to Sheets or SheetifyFree download with in-app purchases (read 2026-10-15)The app installed on each phone, usually with a Google sign-inYesEvery person scanning installs the app
USB or Bluetooth barcode scannerHardware bought onceA computer with the Sheet openThe scanner itself; QR codes and codes on phone screens need a 2D imagerOne desk, and no timestamp unless a formula or script adds it
QR to Sheets scanner link (our product)Free for 300 scans on one phone, then 7 USD per phone per monthA phone browser; no app and no accountYes, in the phone browserSeveral phones at once, or a link per class or event, need Premium
Six ways to scan QR codes into Google Sheets, as each maker's own documentation stated them on 2026-11-21 (the phone-app row on 2026-10-15; the Apps Script camera note is our own check of public deployments). QR to Sheets is our product.

Method 1: a dedicated mobile scanner app

Install an app built for scanning into spreadsheets, link it to your Google account or a sheet, and scan. Several exist, and the names overlap: The Mobile-First Company sells Scan to Sheets - QR & Barcode on the App Store and the same app as Sheetify: Scan to Google Sheets on Google Play, while a different developer, MinhKha, publishes Scan to Sheets: QR & Barcode on Google Play, now with team plans. Others include Scan to Sheet - QR Scanner by Networklabs and Scan-IT to Office. How a browser scanner link compares with the Scan to Sheets app sets out where each one wins.

  • Good raw scanning ergonomics, since the app owns the camera.
  • Usually the fastest option for one person scanning a lot of items.
  • The cost: every person who scans must install the app, and most apps either link a Google account or write to a sheet anyone with the link can open. On shared devices a linked account can drop and need re-establishing.

Method 2: a Google Form linked to a sheet

Create a form with a field per column, link it to a sheet under Responses, and open the form on a phone. Free, no setup beyond the form, and it genuinely works.

  • Completely free and nothing to maintain.
  • A form has no camera scanner of its own, so you scan with the phone camera or another app and paste the value in. That is fine for fifty items and painful for five hundred.
  • No offline buffer. A submission attempted with no signal fails and is lost rather than queued.
  • Self-reported, so for attendance or anything with a consequence attached, anyone with the link can submit for anyone else. Google Forms versus a scanner link goes deeper on when a form is enough.

Method 3: a Google Apps Script web app

Apps Script can serve a small web app from your Google account that appends a row to your sheet for every scan, with a JavaScript library such as Html5-QRCode reading the camera. It is free, fully yours, and any number of phones can open the same URL: deploy it as a web app that runs as you, with access open to anyone including people who are not signed in, and the people scanning need no Google account. Good public tutorials walk through it, including a bpwebs template you copy and deploy from the sheet's Extensions menu.

  • You control every field, every validation rule, and the whole layout.
  • No third party holds your data or your credentials.
  • Test the camera on the phones you will use. Since February 2026 developers have reported Apps Script web apps that can no longer open the camera inside Google's own page ("camera is not allowed in this document"); current tutorials open the scanner in a pop-up window, or host the scanner page on another site that sends each scan to the script.
  • Every scan is a call to the script, so a scan made with no signal fails unless you build a queue on the phone.
  • The rest is maintenance: iOS Safari quirks, in-app browsers, duplicate suppression, simultaneous writes, and Apps Script quotas of 30 simultaneous executions per user and 6 minutes per execution, which Google can change without notice. None of it is hard alone; together it is a small project, and it usually surfaces on the day you need it.

QR to Sheets is a ready-made web app for this: a hosted scanner where you connect a Google Sheet once, create a scanner link, and the phone that opens the link in Safari or Chrome scans QR codes and barcodes straight into that Sheet, with nothing to build or deploy. We make it, so treat this section as interested but specific.

You connect a Google Sheet, create a scanner link, and send the URL to whoever is scanning. They open it in a phone browser, allow the camera once, and scan. Every scan appends a timestamped row. Nobody installs an app or creates an account, which is the whole point when the people scanning are students, temporary staff, or a crew you will not see again next month.

The QR to Sheets scanner link open in a phone browser, showing the workspace name, a viewfinder framing the code, the hint 'Center the code in the box', and a manual entry field with a Submit button below it
What a member of staff sees after opening the scanner link. No app, no sign-in, and a manual entry field for the times a code will not read.
Scan QR Codes to Google Sheets with Any Phone (No App) (4:06, narrated). It shows method 4 end to end in QR to Sheets: connecting a Sheet, creating the link, scanning from a phone's browser, and what each row records.Watch on YouTube Chapters and transcript

Method 5: a Google AppSheet app

AppSheet is Google's no-code app builder: you build an app on top of your Sheet, turn on scanning for a column, and the phone camera fills that column with the code it reads. It reads QR codes and the common barcodes, and it is the right tool when you want a full custom app with forms, photos and signatures, not only a log of scans. As of November 2026, AppSheet's own help sets three conditions on scanning.

  • A paid plan. AppSheet's help states that barcode scanning is supported for the Core and Enterprise plans only. Core is listed at 10 USD per user per month, and Google includes AppSheet Core in most paid Google Workspace editions, so check yours before you buy anything.
  • The mobile app. Scanning works only when the app runs on a phone or tablet; in a web browser the Scan button is not shown, so each person scanning installs the AppSheet app.
  • A licence per user. Users of an app built by an AppSheet Core creator need an AppSheet Core or User Pass licence, and for an app without sign-in AppSheet counts every device that opens it as a separate user. That is worth pricing before you hand phones to temporary staff or volunteers.

So AppSheet fits an organisation whose staff already have Workspace accounts and want a custom app around the Sheet. QR to Sheets, which we make, fits temporary staff, volunteers and door crews who should open a link in the phone browser with no install and no account.

What about a USB or Bluetooth barcode scanner?

A hardware scanner acts as a keyboard: click a cell, scan, and the value appears and the cursor moves down. Nothing writes to the sheet except that typing, so the sheet must be open with the right cell selected, but at a fixed desk it is genuinely excellent and people overlook it.

  • Very fast and very reliable for high volume at one desk.
  • No app, no account and no browser involved.
  • Tethered to a computer, so it cannot walk the aisles or work a door.
  • One scanner, one station: it does not scale to a team spread across a site, and it records no timestamp unless you add one with a formula or a script.

Scanner link versus the do-it-yourself routes

Scanner apps, Google Forms, Apps Script compared with QR to Sheets
CapabilityScanner apps, Google Forms, Apps ScriptQR to Sheets
CostApps: usually in-app purchases (Sheetify on Google Play lists $1.49-$78.90 per item). Form and Apps Script: freeFree for 300 scans on one phone, then $7 per phone per month
Built-in camera scannerApp: yes. Form: no. Apps Script: if you build it, and some deployments cannot open the cameraYes
Scanners need an installApp: yes. Form and Apps Script: noNo
Scanners need an accountApp: often a Google sign-in, or a public sheet anyone can open. Form: noNo
Keeps scans when the signal dropsApp: sometimes. Form: noYes, while the scanner is open; sent when signal is back
Who maintains itApp: vendor. Apps Script: youHosted
Where the data livesYour Google SheetYour Google Sheet

Need to make the QR codes first?

Scanning and making codes are separate jobs, and many projects need both. To make a code for every row inside Google Sheets, put the value in A2, enter =IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="&ENCODEURL(A2)) in B2 and fill it down; that sends each value to a third-party service, so keep it to IDs that are not sensitive. For printable label sheets, the free bulk QR code generator makes up to 500 codes in the browser with no signup, and how to make QR codes in Google Sheets covers the formula, Workspace add-ons, Apps Script and printing.

A straight recommendation

  • Scanning a few dozen items yourself, occasionally: use a Google Form and keep the money.
  • One person scanning high volume regularly: a dedicated mobile app is likely the most comfortable.
  • One fixed desk, high volume: a USB scanner typing into a cell.
  • You want to own the code, or policy forbids third-party services: build the Apps Script version.
  • Your Google Workspace already includes AppSheet Core and you want a full custom app, with forms, photos or approvals, rather than a log of scans: build it in AppSheet, and check that everyone scanning has a licence and the AppSheet mobile app.
  • Several people scan, they should not need accounts or installs, and connectivity is unreliable: a scanner link is the fit.

Whichever you choose: store barcode values as text rather than numbers. Long numeric codes lose leading zeros and can hit float precision problems, which produces mismatches that waste an afternoon.

Three things that go wrong whichever method you pick

Overwriting instead of appending

Append one row per scan and derive totals with a formula or a pivot table. A single overwritten quantity column cannot tell you when a discrepancy appeared, who counted a shelf, or whether something was counted twice.

Timestamps in the wrong timezone

Many tools write UTC. If your team works six hours behind UTC, every row is six hours off and every daily report straddles the wrong boundary. Check what timezone your tool writes, and whether you can change it, before you build reports on it; the guide to why Google Sheets timestamps show the wrong timezone, listed under related guides, walks through each cause.

Timestamps stored as text

A timestamp written by an app or integration is often stored as text, and date filters and date formulas quietly fail on text. Test with =ISTEXT(A2): TRUE means it is text. A format like 2026-08-22 10:01:54, which is what QR to Sheets writes, is stored as text too, but it sorts in time order and =VALUE(A2) turns it into a real date-time, so wrap it in VALUE() before any date arithmetic or MINIFS, MAXIFS or COUNTIFS date criteria. A raw ISO string with a T and a trailing Z is harder: it is in UTC and needs extra conversion first.

Step by step

  1. 1

    Decide who is doing the scanning

    If it is only you, almost any method works and you should pick the free one. If other people scan — staff, students, volunteers, contractors — then whether they need an app or an account becomes the deciding factor.

  2. 2

    Prepare the destination sheet

    One column per field, exactly one header row, no merged cells. Format the code column as plain text so long numeric barcodes keep their leading zeros.

  3. 3

    Pick a method from the five below

    They differ mainly on who can scan, whether it survives a dropped connection, and how much you maintain yourself.

  4. 4

    Test with five real items before you rely on it

    Check the values land in the right columns, that a repeat scan behaves the way you expect, and that the timestamp is in a timezone you can read.

Frequently asked questions

What is the easiest way to scan QR codes into Google Sheets?+

With nothing to build or install, a scanner link: in QR to Sheets you open a link in any phone browser and each scan becomes a timestamped row in your Sheet, free for 300 scans on one phone. One person can use a scanner app, one desk a USB scanner; the free routes are a Google Form or Apps Script.

Can Google Sheets scan a QR code by itself?+

No. The Google Sheets mobile app has no barcode or QR scanner. Something else must read the code and append the row: a scanner app such as Scan to Sheets, a form you paste into, an Apps Script web app, or a browser scanner link such as QR to Sheets.

How do I scan QR codes into Google Sheets for free?+

Two routes cost nothing: a Google Form linked to the Sheet, where people scan with the phone camera and paste or type the value, and a Google Apps Script web app with a camera library such as Html5-QRCode that you deploy and maintain. QR to Sheets is free for 300 scans on one phone if you would rather not build one.

Can I build my own QR scanner for Google Sheets with Apps Script?+

Yes: a free Apps Script web app with a camera library such as Html5-QRCode appends a row per scan, and any number of phones can open its URL. Since February 2026 some cannot open the camera inside Google's page, so tutorials use a pop-up window or a page hosted elsewhere. QR to Sheets is the ready-made, no-code version.

Can AppSheet scan QR codes into Google Sheets?+

Yes, within limits AppSheet's own help states (read November 2026): barcode and QR scanning is supported on the Core and Enterprise plans only, and only in the AppSheet mobile app, not in a web browser. Core is 10 USD per user per month and is included in most paid Google Workspace editions; every app user needs a licence.

Is AppSheet or QR to Sheets easier for scanning into Google Sheets?+

For scanning alone, QR to Sheets: there is no app to design, and the people scanning open a link in the phone browser with no install, account or per-person licence. AppSheet fits better for a full custom app on your Sheet, with forms, photos and signatures, and your Google Workspace already includes AppSheet Core. We make QR to Sheets.

Can I scan QR codes into Google Sheets without installing an app?+

Yes. QR to Sheets is a scanner that opens as a link in Safari or Chrome, so the phone uses its camera with nothing installed from an app store and no account for the person scanning; each scan becomes a new row in your Google Sheet. An Apps Script web app also runs in the browser, but you build it yourself.

Is scanning QR codes into Google Sheets the same as generating QR codes in Google Sheets?+

No, they are opposite directions. Scanning reads existing codes and adds a row per scan, with an app, a form, Apps Script or QR to Sheets; generating makes a code for each row, with the IMAGE formula, an add-on or the free QR to Sheets bulk generator. Many setups need both: print codes from the sheet, then scan them back in.

How do I make a QR scan appear in Google Sheets automatically?+

Use a tool that writes to the sheet for you rather than one that only decodes the code. A dedicated mobile app, an Apps Script web app, or a shareable scanner link all append rows automatically. Scanning with the plain phone camera does not, because it only shows you the value.

Do the people scanning need to install an app?+

It depends on the method. Dedicated mobile apps require an install for every scanner, and many link a Google account. Google Forms, Apps Script web apps, and hosted scanner links all run in a browser with nothing to install.

Can several people scan into the same Google Sheet at once?+

Yes. A Google Form or an Apps Script web app takes any number of phones free. A QR to Sheets scanner link works on several phones at once, and every row lands in the same Sheet with the link's name. Free covers one phone; Premium is 7 USD per phone per month, so two phones cost 14 USD.

What happens to scans when the phone loses signal?+

A Google Form submission fails and the data is lost. Tools that save each scan to the device first keep working through dead zones and sync when the connection returns. Ask about this specifically — in a warehouse or a basement venue it is the difference between a delay and a lost count.

Which barcode formats can a phone camera read?+

QR codes plus the common 1D formats: Code 128, Code 39, EAN-13, EAN-8, UPC-A, UPC-E and ITF. 1D barcodes are more sensitive to focus and lighting than QR codes, so a good scanner confirms a 1D read across consecutive frames before accepting it.

Is there a scan to Google Sheets app, or can it work in the browser?+

Both exist. App Store products such as Scan to Sheets from Mobile First require an install — their listing states 130.6 MB and iOS 15.0 or later, read on 2026-10-15 — which suits a phone you own and use daily. A scanner link runs in the phone browser instead, so temporary staff and volunteers scan without installing anything or making an account. Pick the install if you need long offline stretches or Bluetooth hardware; pick the browser if the people scanning are temporary or numerous.

What is the fastest way to scan into Google Sheets?+

For a fixed desk, a USB barcode scanner typing straight into a cell is hard to beat. For people moving around, a browser-based scanner link is fastest because there is no field to tap before each scan and nothing to install.

Try it on your own Google Sheet

Connect Google, create a scanner link, and open it on the phone that will scan. Have that phone at hand: setup takes a few minutes and ends with your first row in the Sheet. Free covers 300 scans on one phone, and the people you scan never install anything.

Start for free

No credit card required

A second door, booth or classroom is a second phone

Free covers one phone and one scanner link. Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month. Running several classes, events or lists from one phone? Premium on that one phone is $7 a month, with a separate scanner link for each. Paid yearly, it is $70 per phone per year (2 months free).

How many phones will scan at the same time?

$7 x 2 = $14 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.

Keep reading