Guides & Industry Examples

How to Scan Barcodes Into Excel

Get scans into an Excel or CSV file without typing a single number. Column setup, quantities, and timestamped exports.

Use Your iPhone as an Inventory Barcode Scanner

What a phone camera can and cannot replace, the five scan modes, and how to set up the export once.

Scan Barcodes to Google Sheets

Land scans in a Google Sheet with a CSV import, plus an optional email step for teams that run their own automation.

Scan Serial Numbers to a Spreadsheet

Audit laptops and IT equipment by scanning serial labels: Code 128 labels, Continuous mode, condition notes, and deduping in Excel.

Offline Barcode Scanning

Scan in basements, metal racking, and field sites with zero signal. Everything stores locally and exports when you are back online.

Cycle Counting With a Phone

Run rolling ABC cycle counts without a warehouse management system. Count with your phone, reconcile in Excel.

Stocktake With an iPhone

Plan and run a full stocktake with the phones your team already carries: zones, parallel counting, the year-end count, merging and reconciliation.

Free Inventory Count Sheet Template

Free count sheet for Excel and CSV: paste every counter's scans, SUMIF totals counted stock per EAN and shows the difference to book stock.

JTL-Wawi: Import a Stocktake CSV

Import counted stock into JTL-Wawi with JTL-Ameise: DataScan CSV settings, matching by EAN, overwriting stock, dry run first.

Get Barcode Scans Into SAP or QuickBooks

Bridge mobile scanning and SAP, QuickBooks, or any ERP that imports CSV. Field mapping and clean file-based workflows.

Retail Stock Audits

Shelf-level stock audits with a phone: price verification, gap scans, and shrinkage checks between full counts.

Warehouse Receiving With a Phone

Verify inbound deliveries against the packing list before the driver leaves, and export a receiving record.

Equipment Inspections With QR/Barcode

Field inspections with QR or barcode labels, notes, and GPS location per asset. Documentation your office can file.

Pack & Track Items Into Boxes

Pack and track items into boxes, pallets, or containers with One-to-Many scanning. Know what went where.

QR Code Event Check-In to a Spreadsheet

Check attendees in by scanning QR tickets or badges, then export the attendance list as a spreadsheet.

Verify Scans Against a Product Database

Import your product list and use Lookup mode to verify scans against it on the spot: pick checks, price checks, recalls.

Industry examples

Warehouse Location Tracking

Scan a bin, then every item placed there, and import the moves into your stock list.

Delivery Verification

Scan every box of a delivery and get a file with counts next to the ordered quantities.

Retail Cycle Counting

Count one section at a time with barcode and quantity, then compare with your stock list.

Year-End Stocktake

Count with several phones, export one file each and combine them in a spreadsheet.

Shopify Inventory Count

Count shelf stock by barcode and update Shopify through its inventory CSV import.

IT Asset Tracking

Record device handovers and count asset tags on site with your register on the phone.

Handyman Tool Tracking

Scan the truck or job, then each tool you load. A daily record of which tools went where.

Equipment Rental Tracking

Link each machine to the job ticket it went out on, and scan returns back in at the yard.

Inspection Rounds

Scan each tag, type what you found, add GPS and weather with a tap.

Manufacturing Parts Inventory

Look up part specifications at the bin and count stock with part data in the export.

Medical Supply Count

Count the supply room by barcode and send purchasing a list with names and quantities.

Lab Sample Tube Inventory

Scan the freezer box, then each tube. Know which box holds every sample.

Specialty Retail Ordering

Scan the products you need, type the order quantity and email the file to your supplier.

Cheese Aging Location Tracking

Scan a ripening section, then each wheel placed there. Every move ends up in a spreadsheet.

Kanban Bin Replenishment

Scan empty bins, see the part name, and email the list to your supplier.

Tire Storage Tracking

Scan the rack slot and the tire set label, so every stored set can be found again.

University Attendance Tracking

Scan student ID cards at the door and get a spreadsheet of who came and when.

Event Check-In

Scan tickets at the door, see the attendee's name, and export a check-in list.

Library Shelf Inventory

Scan the shelves and compare with your library system's item list to find missing books.

School Device Collection

Scan each cart, then the Chromebooks or iPads in it, with the student name shown for every device.