Select a cell, tap the barcode key, point at the code. The value lands in the cell — because the scanner is the keyboard.
Getting barcode data into a spreadsheet is usually one of two bad options. Either somebody reads the number off the label and types it in, which is slow and goes wrong at the eleventh digit, or you buy dedicated scanners and discover they only talk to the software they came with.
A scanning keyboard sidesteps both. Android lets you choose which keyboard is active, and an app that accepts typed text cannot tell the difference between a person typing and a keyboard supplying characters. So when the barcode key hands the decoded value to Excel, Excel treats it exactly like typing — it goes into the selected cell, the formula bar updates, undo works, everything behaves normally.
There is nothing to install inside Excel, no add-in, no connector and no permissions to grant. The spreadsheet does not know anything unusual happened.
Install Barcode & QR Scanner Keyboard from Google Play, then enable it in Android’s keyboard settings and set it as the active input method.
Open the workbook in Excel on your phone or tablet and tap the cell you want the value in, so the keyboard is showing.
The camera opens. Point it at the barcode and the decoded value is typed into the cell.
Set a suffix in the keyboard’s settings and it is appended after every scan — an Enter to drop to the next row, or a Tab to move across. You can then scan a whole shelf without touching the screen between items.
Enter after each scan fills a column downwards; Tab fills a row across. This is the single setting that changes a stock count from fiddly to fast.
Scan a run of items one after another rather than reopening the camera each time — useful when you are working down a pallet or a shelf bay.
Every scan is kept with its format and timestamp, and exports as CSV. If you would rather build the sheet on a computer afterwards, export rather than scan into the phone at all.
Format the column as Text before you start. Excel will otherwise treat a long numeric barcode as a number and may show it in scientific notation or drop a leading zero — that is a spreadsheet behaviour, not a scanning one.
No. An Android phone with a scanning keyboard does the same job for the common formats. The camera decodes the barcode and the keyboard types the value into the cell, so nothing has to be paired, charged or connected.
No. The keyboard supplies characters the way any keyboard does, so Excel receives them as ordinary typing. There is nothing to install inside Excel and no account to connect.
Set a suffix in the keyboard settings. An Enter suffix moves down a column after each scan and a Tab suffix moves across a row, so a long count runs without touching the screen between items.
That is Excel reading a long digit string as a number. Format the column as Text before scanning into it and the value stays exactly as it was decoded, leading zeros included.
Not directly — the keyboard is an Android input method. Scan on the phone and export the history as CSV, or use the REST API to push values into your own system.
Tap a cell, tap the barcode key, point at the code. The value is typed in, and the sheet syncs like any other edit.
Read itInspection reports, job sheets, delivery notes — anywhere a long code has to be recorded accurately into prose rather than a column.
Read itFree on Google Play. No hardware to buy, and nothing to connect to whatever you are scanning into.