ScanSheet
Guides

Barcode scanning guides & tutorials

Practical, step-by-step guides for turning your phone into a barcode scanner that feeds a desktop spreadsheet. From inventory counts to Google Sheets sync, Excel export, and more.

Start scanning free Browse all guides
  • 18detailed guides
  • Freeup to 1,000 rows
  • No appworks in your browser
Phone barcode scanner Barcode scanner to spreadsheet, no app to install ScanSheet turns a phone camera into a short-lived scanner session for your desktop table. It is built for inventory counts, event check-in, and quick asset lists where installing a native app is overkill.
  • Pair your phone in 10 seconds with a QR code
  • Up to 1,000 unique barcode rows on the free plan
  • CSV and XLSX export ready for Google Sheets or Excel
Read the guide Excel-ready export Use your phone as a barcode scanner for Excel ScanSheet pairs your phone camera with a desktop browser, lets you edit quantities and notes as you go, and exports a clean XLSX file that opens in Microsoft Excel, Google Sheets, and Apple Numbers without reformatting.
  • XLSX export with proper barcode, quantity, note, and timestamp columns
  • Editable quantity and note cells before you export
  • Free local storage up to 1,000 rows, no account needed
Read the guide Inventory workflow A browser-first inventory barcode scanner ScanSheet keeps the inventory workflow simple: pair, scan, edit, export. No native apps, no per-user licenses, no IT setup. Open the URL on a laptop, scan a QR with the team phone, and start counting.
  • Inventory template with barcode, quantity, bin, and note columns
  • Tokenized QR pairing — sessions auto-expire after 60 minutes
  • Free local sheets up to 1,000 unique barcode rows
Read the guide Google Sheets + phone camera How to scan barcodes into Google Sheets using your phone You can scan a barcode with your phone camera and have the row appear in Google Sheets in under a second — no native app, no Zapier, no Google Apps Script. ScanSheet pairs your phone to a browser tab and pushes every scan into a sheet you control.
  • 60-second setup: open the URL, scan a QR, point the camera
  • Free plan covers up to 1,000 unique barcodes per month
  • Pro plan adds one-click direct export to a new Google Sheet
Read the guide Inventory use case Run an inventory count with just your phone (no scanner needed) You can finish a 500-item inventory count in under 90 minutes using a phone camera and a laptop browser. This guide walks through the exact workflow used by small retail shops, churches, and school supply rooms.
  • Average scan rate: one barcode every 1.2 seconds after a 5-minute warm-up
  • Inventory template with barcode, quantity, bin, and note columns
  • Free for counts under 1,000 unique barcodes
Read the guide Comparison: 5 methods 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.
  • Methods compared: phone camera, Google Lens, ScanSheet, Sheets mobile, Zapier
  • Free options covered for under 1,000 unique barcodes per session
  • Privacy score for each method based on where scan data is stored
Read the guide Library use case Scan ISBN barcodes into a library spreadsheet Whether you are cataloging a classroom library, a church book corner, or your home shelf, ScanSheet's Library template turns the phone camera into an ISBN scanner. Each book appears as a row with the ISBN, scan time, and an editable note field.
  • Library template with ISBN, title placeholder, shelf, and note columns
  • Free for libraries up to 1,000 unique books
  • CSV / XLSX export ready for LibraryThing, Goodreads, or a custom catalog
Read the guide Event use case Run event check-in with your phone (free, no app) For events under 1,000 attendees, ScanSheet's Event template turns the door volunteer into a one-person check-in station. The phone scans QR or Code 128 tickets, the laptop table updates in real time, and you can export a final attendance list in two clicks.
  • Event template with ticket code, attendee name placeholder, time, and note
  • Same barcode cannot be scanned twice (de-dup is automatic)
  • Free for events under 1,000 unique tickets
Read the guide Export how-to How to export ScanSheet data to Excel (XLSX) ScanSheet writes a clean .xlsx file with five columns: barcode, quantity, note, first scan time, and last scan time. The file opens in Excel, Google Sheets, and Apple Numbers without reformatting.
  • Standard XLSX (Office Open XML) format, opens in Excel 2007+
  • Quantity as a real number, not text — pivot tables and VLOOKUP work directly
  • Formula injection protection on CSV export (=, +, -, @ prefixes escaped)
Read the guide Privacy & trust Is browser-based barcode scanning safe? Browser-based barcode scanners ask for camera access and run code in your browser. Whether that is safe depends on three things: where the scan data is stored, who can see it in transit, and whether the code is auditable. ScanSheet's answers are below.
  • Scan data lives in your browser's local storage by default
  • Phone-to-laptop WebSocket is end-to-end tokenized, no third-party relay
  • Optional Google Drive backup is the only outbound data path (Pro, opt-in)
Read the guide Decision guide Phone barcode scanner vs dedicated scanner: which should you use? The right tool depends on how often you scan, the barcodes you read, and how much you want to spend. This guide covers the trade-offs in plain language so you can pick the option that fits your workflow.
  • Phone wins for under 5,000 scans/month and varied barcode types
  • Dedicated scanner wins for daily cash-register or warehouse use
  • Hybrid: use a phone for occasional counts, a scanner for daily workflows
Read the guide PWA install guide Install ScanSheet as a PWA and use it offline ScanSheet is a Progressive Web App. You can install it on your phone or laptop home screen, launch it full-screen like a native app, and use the manual entry path even when offline. The phone-camera scanner needs a connection, but the rest of the app keeps working.
  • Install on iPhone, iPad, Android, and desktop browsers
  • Manual entry works offline — type barcodes into the laptop table without a network
  • Home-screen icon, full-screen mode, no browser chrome
Read the guide CSV import how-to How to import an existing CSV into ScanSheet Already have a list of barcodes in a CSV from another tool, a vendor spreadsheet, or an old scanner export? ScanSheet's Import CSV button reads the file, adds each barcode as a row, and respects the existing quantity if you have one.
  • Drop in a CSV with a barcode column and optional quantity and note columns
  • Duplicates are merged automatically — quantities add up
  • Imports above the row limit are truncated with a clear warning
Read the guide Competitor comparison ScanSheet vs Scan to Web Sheet vs Barcodes to Sheet If you are choosing between ScanSheet, Scan to Web Sheet, and Barcodes to Sheet, the right pick depends on three things: how many barcodes you scan per month, whether you need offline mode, and where your scan data is allowed to live. This page compares all three on the criteria small teams actually weigh before they commit.
  • Three tools compared on 12 criteria — pricing, row limits, privacy, exports, PWA, offline
  • Best-fit recommendation for inventory, event check-in, and library use cases
  • No marketing fluff — every claim is sourced from each tool's published feature list
Read the guide 2026 roundup Best barcode inventory apps for small business in 2026 Choosing a barcode inventory app in 2026 is harder than it should be — most lists recycle the same five names without telling you the free tier caps at 50 items. This page lists seven apps with the actual free row limit, the actual paid price, and the actual workflow fit, so you can pick one in ten minutes instead of an afternoon.
  • Seven apps compared: ScanSheet, Sortly, Boxstorm, Zoho Inventory, Inventory Now, StockX, Barcodes to Sheet
  • Free tier row limits and paid upgrade prices verified August 2026
  • Best-fit recommendation by use case: retail, warehouse, library, event, asset
Read the guide Warehouse operations Run a warehouse cycle count without buying scanners A warehouse cycle count does not require $300 laser scanners, a custom WMS, or a six-week IT rollout. With two phones, a laptop, and a free PWA, a 1,000-SKU count is doable in a single afternoon. This guide walks through the exact process a 5-person team can run on a slow Friday.
  • 4-phase cycle count process: prep, scan, reconcile, report
  • Works with any phone camera — iPhone 7+ or Android 8+
  • Free tool stack: ScanSheet (1,000 items) + Google Sheets for reconciliation
Read the guide Shopify integration Barcode scanner for Shopify stores: 4 methods compared Shopify store owners hit the same wall around 100 SKUs: typing stock counts into the Shopify admin is slow and error-prone. This page compares four barcode scanning workflows that plug into Shopify, with the actual cost and setup time for each so you can pick one without a free-trial marathon.
  • Four methods compared: Shopify mobile app, ScanSheet PWA, USB scanner, Shopify POS
  • Each method's cost, setup time, scan speed, and Shopify sync path
  • Best-fit recommendation by store size: under 100, 100–1,000, 1,000+ SKUs
Read the guide Workflow replacement Replace Excel manual entry with phone barcode scanning If your team is still typing barcodes into Excel cells by hand, you are losing 4–6 hours per week to typos, duplicate rows, and missed scans. This page walks through four ways to replace manual entry with phone-based scanning, the migration path from your current Excel sheet, and the break-even cost analysis.
  • Four replacement methods compared: PWA, mobile app, USB scanner, browser extension
  • Step-by-step migration from an existing Excel sheet to a scanning workflow
  • Cost-benefit analysis: when the switch pays for itself
Read the guide

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