How to scan barcodes into Excel on Android

With ScanKeys as your keyboard, the Excel app on your phone works like a spreadsheet connected to a barcode scanner: each scan fills the selected cell and moves to the next row.

Updated 2026-11-22

Step by step

  1. Enable ScanKeys and make it the active keyboard.
  2. Open your workbook in the Microsoft Excel app. Add headers in row 1, such as Barcode, Qty, Location.
  3. Format column A as Text (see below) so leading zeros survive.
  4. Tap cell A2, then tap the formula bar or double-tap the cell so the keyboard opens.
  5. Tap Scan and aim at the first barcode. The code fills A2 and, with Press Enter after a scan on, Excel moves to A3.
  6. For long lists, switch the scanner to Continuous and keep scanning down the column.
ScanKeys after-scan settings: Enter, smart submit, prefix and suffix

Keep leading zeros and long numbers intact

Excel converts anything that looks like a number. A UPC such as 036000291452 becomes 36000291452, and a 13-digit EAN may show as 4.00638E+12. Once that happens, the digits are gone. Prevent it before scanning:

  • Format as Text: select the column, tap the format (Home) menu → Number Format → Text.
  • Or use an apostrophe prefix: in ScanKeys settings set Prefix to '. Excel stores the cell as text and does not display the apostrophe.

Fill across columns with Tab

To scan a row of codes (for example a product barcode, then a bin label), set ScanKeys’ Suffix to \t and switch Press Enter after a scan off. Each scan types the code and presses Tab, moving one cell to the right. When the row is done, press Enter on the keyboard to go to the next row. With Pro, save this as a per-app profile for Excel so other apps keep their own settings.

Handy Excel formulas for scanned data

  • Quantity per barcode: in another sheet, =UNIQUE(Sheet1!A2:A1000) in A2 and =COUNTIF(Sheet1!A:A, A2) beside it.
  • Product name lookup: =XLOOKUP(A2, Products!A:A, Products!B:B, "unknown").
  • Check digit test for 13-digit EANs (should return TRUE): =MOD(10-MOD(SUMPRODUCT(MID(A2,ROW($1:$12),1)*{1;3;1;3;1;3;1;3;1;3;1;3}),10),10)=--RIGHT(A2)

If you count stock this way often, ScanKeys Pro’s inventory count mode does the tally for you and exports a CSV that opens straight in Excel.

A ready-made stock sheet layout

For a simple stock list, use four columns: Barcode (formatted as Text), Description, Qty and Location. Scan barcodes down column A with Enter after scan on. Fill Description with an XLOOKUP against your product list, so you can see at a glance which item each code belongs to and spot codes that are not in your catalogue at all. Type quantities in column C afterwards, or scan each unit and let a COUNTIF summary count them for you. Save a copy of the empty sheet as a template for the next count.

Troubleshooting

  • Excel jumps two rows: you have both a \n suffix and Press Enter after a scan on. Use one or the other.
  • Nothing happens after a scan: the cell was not in edit mode. Double-tap the cell or tap the formula bar first.
  • Codes go into one cell: Enter after scan is off and there is no suffix; turn one on.

Frequently asked questions

Does Excel for Android have a barcode scanner?
Excel for Android has no built-in barcode scanning into cells. ScanKeys adds it by acting as the keyboard, so Excel simply receives typed text.
Why does Excel show 3.6E+11 instead of my barcode?
Excel treats long digit strings as numbers. Format the column as Text before scanning, or set ScanKeys’ prefix to an apostrophe so every code is stored as text.
Does this work with Excel on a PC?
ScanKeys types on the phone it runs on. To fill a workbook that lives on a PC, open the same workbook from OneDrive in the Excel app on the phone; it syncs. Or export your scans as CSV (Pro) and open the file on the PC.
Get ScanKeys on Google Play