Tap a cell, tap the barcode key, point at the code. The value is typed in, and the sheet syncs like any other edit.
Google Sheets is where a lot of real stock counts, asset registers and goods-in logs actually live — shared with the team, open on a phone, edited by whoever is standing in front of the shelf. The awkward part has always been getting the barcode into the cell without reading the digits aloud.
Because this is a keyboard rather than a separate scanning app, there is no copy and paste step. Sheets receives the decoded value as typed characters, puts it in the selected cell, and syncs it to everyone else on the sheet exactly as it would an edit made by hand.
That also means it works wherever Sheets works — the Android app or the browser — and it needs no Apps Script, no add-on and no access to your Google account.
Install Barcode & QR Scanner Keyboard from Google Play, enable it in Android’s keyboard settings, and make it the active keyboard.
In the Google Sheets app or in a mobile browser, tap the cell you want to fill so the keyboard appears.
Point the camera at the code. The decoded value is typed into the cell and syncs to the rest of the team like any other edit.
An Enter suffix drops to the next row after each scan and a Tab suffix moves across — set it once in the keyboard settings and a long count runs hands-free between items.
Values arrive as typed input, so revision history, comments and simultaneous editing behave exactly as they always do. Two people can count different aisles into the same sheet.
The suffix setting decides which. Pick whichever matches how your sheet is laid out and the count stops needing a free hand.
Set the column to plain text under Format → Number, otherwise Sheets may strip a leading zero or reformat a long numeric barcode.
Every scan is stored with its format and time, and exports as CSV — so a mis-tapped cell does not mean a lost count.
Install a scanning keyboard, enable it in Android’s keyboard settings, then tap the cell you want to fill and tap the barcode key. The camera decodes the code and the value is typed into the cell.
No. The keyboard types the value in the same way you would, so Sheets needs no add-on, no script and no access to your Google account.
Yes. The scan arrives as an ordinary cell edit, so it syncs, appears in revision history and works alongside other people editing at the same time.
Sheets is interpreting the digits as a number. Set the column to plain text under Format → Number before you scan into it and the value is kept exactly as decoded.
Yes — select the first cell of that column and use an Enter suffix. Each scan fills the cell and moves down to the next one, so the whole column fills in order.
Free on Google Play. No hardware to buy, and nothing to connect to whatever you are scanning into.