Barcode scanner to Excel

A barcode scanner to Excel is a collection workflow

A normal scanner answers one question: what text is inside this symbol? An inventory pass asks a different question: which codes did I encounter, in what order, how many times, and what table can I hand to somebody else? This page keeps the camera running after a successful read and adds each result to a visible table instead of replacing the previous answer.

You can also choose a saved photo or screenshot one at a time. That is useful for codes received in email, photographed earlier or displayed on the same phone. The source image is decoded locally and discarded after the row is made. For a one-off square code where you want typed URL, Wi-Fi or contact details, the QR code scanner gives a more detailed single-result receipt.

Five formats, one explicit table

The reader accepts QR Code, Data Matrix, Code 128, EAN-13 and UPC-A. The Format column records which decoder succeeded, while Value preserves the exact returned text. QR and Data Matrix can contain Unicode. Code 128 and retail symbols follow their own narrower data rules. The page never converts a leading zero to a number.

That format boundary matters when the same digits could be drawn in several symbols. The receiving system may require UPC-A even when a phone can also read QR. If you need to create labels rather than collect existing ones, use the bulk barcode generator for a CSV-to-ZIP batch or the single barcode generator for one inspected symbol.

Repeated frames do not become accidental stock

A camera sees several frames per second. Without a cooldown, holding one box still would create dozens of rows before you could move to the next one. After a successful decode, the same format and value are ignored briefly. The camera then resumes and can read that value again deliberately later.

Choose Add another row when every scan represents an event or physical item. Choose Increase quantity when identical format-and-value pairs should share one line. The latter updates the quantity and most recent timestamp. Neither option silently deletes a distinct symbol. You can remove an individual row before download and clear the whole table only with an explicit button.

Excel and CSV exports preserve identifiers as text

The Excel button writes a real .xlsx workbook with Sequence, Value, Format, Quantity and Scanned at columns. Values and timestamps are text; sequence and quantity are numeric. That distinction prevents Excel from stripping leading zeroes or formatting a long identifier in scientific notation. The header stays visible when the sheet scrolls.

CSV is the interoperable alternative for databases, scripts and systems that do not need workbook formatting. It includes a UTF-8 marker for spreadsheet compatibility and quotes commas, quotes and line breaks correctly. If a CSV needs types, separators or column widths adjusted before workbook creation, the full CSV to Excel converter exposes those decisions. To move an existing workbook the other way, use Excel to CSV.

A decoded barcode is not a product lookup

EAN-13 and UPC-A commonly identify retail items, but the bars contain only the digits. Product name, price, owner and availability live in external databases whose coverage and licenses differ. This tool does not query one, so it never presents a guessed catalog match as part of the scan. The spreadsheet is an observation log, not proof of ownership or stock.

The same safety rule applies to URLs in QR codes. Contents are added as text and never opened automatically. Review the Value column before copying or acting on a destination. A successful decode proves that pixels form a readable symbol; it does not prove a link is safe or a label is authorized.

Camera permission is temporary and optional

The browser asks for camera access only after you press Start continuous camera. The page requests the rear-facing camera when available, displays the live frame and stops every media track when you press Stop camera or leave the page. If permission is denied, saved images remain available without granting access.

Camera recognition depends on focus, light, glare and the number of pixels covering the narrowest bar or matrix module. Fill a useful portion of the frame but keep the entire symbol and quiet border visible. For glossy packaging, tilt the phone until reflections move away from the bars. A sharp saved photo can work better than a live frame on older devices.

Everything stays on this device

Frames are copied to local pixels and sent only to a worker in this tab. The decoder, row logic, CSV serializer and Excel writer are self-hosted; there is no upload, account or analytics request carrying a decoded value. Downloaded files are created as temporary object URLs and disappear from tab memory after use.

That local design makes this suitable for internal IDs that should not be sent to a public barcode service. It also means the table has no cloud recovery: download it before closing or reloading the page.