ScanSheet
5 ways to scan barcodes into a spreadsheet without an app
You do not need to buy a scanner or install a native app to get barcodes into a spreadsheet. These five methods all work in a browser, and they trade off setup time, row limits, and how much you trust a third party with your data.
Open ScanSheet FreeProduct walkthrough
60-second walkthrough — recording this week.
A short demo of the steps described in this article.
On this page (6 sections)
Method 1 — Phone camera + ScanSheet (recommended)
Pair the phone to a laptop browser via QR code. Scans appear in the laptop table in under a second. Free up to 1,000 unique barcodes, Pro up to 10,000 with direct Google Sheets export. Data lives in the laptop browser — no third-party server sees your scans.
Best for: small-team inventory counts, event check-in, classroom lists.
Method 2 — Google Lens + Google Sheets (free, but manual)
Open Google Lens on the phone, point at a barcode, copy the result, paste into a Google Sheets cell. Repeat. Free, works on any phone with Google Lens, but there is no auto-increment, no quantity tracking, and no scan history. Realistic for under 20 items.
Best for: a one-time scan of a few dozen barcodes where you do not mind manual paste.
Method 3 — Google Sheets mobile app barcode scan
Open a Google Sheet in the Sheets mobile app, tap Insert → Barcode. The phone opens a camera view, scans, and drops the value into the active cell. Free, no signup, but you are stuck on a 5-inch screen for any editing and there is no auto-merge of duplicates.
Best for: a 30-item count on the go where you do not need to edit while scanning.
Method 4 — Dedicated scanner with USB HID input
Buy a $50–$300 USB barcode scanner, plug it in, open Notepad or Sheets, and let the scanner type each barcode like a keyboard. Free software, very fast, but each scanner costs money and quantity-on-re-scan is not built in — you have to count manually.
Best for: cash-register workflows or fixed scanning stations that are used daily.
Method 5 — Zapier or Make (automation, but slow)
Connect a barcode scanner app to Zapier, which then writes to Google Sheets. Powerful for custom workflows, but every scan goes through Zapier's servers (privacy concern), and the per-task cost adds up: 1,000 scans a month can cost $20+ depending on your plan.
Best for: businesses that already use Zapier for other automations and need custom routing.
Side-by-side comparison
| Method | Setup | Cost | Row limit | Privacy |
|---|---|---|---|---|
| Phone + ScanSheet | 1 minute | Free / Pro | 1,000 / 10,000 | Local browser |
| Google Lens | 0 minutes | Free | Unlimited | Google account |
| Sheets mobile | 1 minute | Free | Unlimited | Google account |
| USB scanner | 10 minutes | $50+ | Unlimited | Local machine |
| Zapier | 30+ minutes | $20+/mo | Unlimited | Third-party |
Common use cases
- Choosing the right tool for a one-off count
- Comparing free options before buying hardware
- Evaluating privacy trade-offs of each method
Frequently asked questions
Quick answers to what teams ask before they switch to ScanSheet.
Which method is the fastest for 500 items?
USB scanner and ScanSheet tie for speed at about 1 second per scan. Google Lens and Sheets mobile are slower because of manual paste or screen switching.
Which is the most private?
USB scanner and ScanSheet both keep data on your own machine. Google Lens and Sheets mobile send data through Google. Zapier routes through Zapier's servers.
Can I switch methods mid-count?
Yes. The data is a spreadsheet at the end of the day, so you can use ScanSheet for the bulk count and switch to USB scanner for the slow, damaged barcodes.
Ready to scan your first barcode?
No app to install, no credit card to start. Pair your phone with ScanSheet in 60 seconds.
Open ScanSheet Free