How to Scan Barcodes Into Excel (Phone or USB Scanner)

Scan barcodes straight into Excel with a USB scanner or your phone camera. Covers free methods, keyboard mode, next-row setup, and leading zero fixes.

A barcode scanner can put data into Excel the same way a keyboard does, with no plugin, no macro, and no copy-pasting required for most setups. The trick is understanding that from Excel's point of view, a scan is just very fast typing. Here is how to set it up with a USB scanner, a phone, or nothing but a browser.

Can I Scan a Barcode Directly Into Excel?

Yes. A USB or Bluetooth barcode scanner set to keyboard mode types each scanned number straight into the active cell, with no extra software or import step. You click a cell, scan the barcode, and the data appears as if you had typed it, usually followed by an automatic Enter that moves to the next row.

This works because almost every handheld USB barcode scanner ships configured as a HID (human interface device), the same class of device as a keyboard. Windows and macOS recognize it automatically with no driver install. To confirm a scanner is working correctly before trusting it with a real spreadsheet, open Notepad or TextEdit, click into the document, and scan a barcode. You should see the encoded number appear, followed by the cursor jumping to a new line, according to a setup guide from The Bricks. Once that test works, the exact same behavior carries over into any Excel cell.

The one exception is a scanner that connects through a serial or COM port instead of acting as a keyboard. Those scanners send data over a connection Excel can't read on its own, so they need a separate data-logging program to capture the output and write it into cells, as explained in Aggsoft's guide to barcode-to-Excel scanners. Unless you already own older industrial hardware, this almost never applies. Standard retail USB scanners sold today are keyboard-mode by default.

How Can I Scan Barcodes Into Excel for Free?

Most USB barcode scanners already work for free, since they act like a keyboard the moment you plug them in. If you don't own a scanner, free phone apps and browser-based tools can read a barcode with your camera and send the result into a spreadsheet or a file you open in Excel, without buying hardware.

If you're buying a scanner for the first time, even budget USB models in keyboard mode need no paid software to function with Excel. The cost, if any, is the hardware itself, not a subscription. If you'd rather not buy anything, our own web-based barcode scanner reads a barcode through your computer's or phone's camera for free, right in the browser, and you can copy the decoded number into a cell manually or pair it with one of the phone workflows below for less manual work.

For a one-off batch of codes rather than ongoing scanning, it's often faster to skip physical scanning altogether. See our barcode generator and lookup tools if you're creating the codes yourself rather than reading ones already printed.

Can I Use My Phone to Scan Barcodes Into a Spreadsheet?

Yes. Several free apps use your phone's camera to read a barcode and add a row to a connected spreadsheet, either directly to Google Sheets or by exporting a CSV or Excel file you open later. A web-based scanner that pairs with your browser can do the same without installing anything.

A few patterns show up across the free apps available on iOS and Android. Some, like Barcode Sender, write scans directly into a Google Sheet over the cloud with no computer involved. Others, like Scan to Spreadsheet, build a CSV or Excel file on the phone that you then share to Google Drive or email to yourself before opening it in Excel, per their app store listings. A separate category of tool runs entirely in a browser: you open a page on your computer, scan a pairing QR code with your phone, and each subsequent phone scan appears as a new row on the computer screen in real time, no app install needed. If you'd rather scan with your phone's own camera without any third-party app, our guide on scanning a barcode with your phone covers the built-in options on iOS and Android.

Whichever app you pick, check its star rating and read a few recent reviews before relying on it for business data, since quality varies widely among free scanning apps and not all of them are actively maintained.

How Do I Make Excel Move to the Next Row After Each Scan?

Most scanners are factory-configured to send an Enter keystroke after every scan, which moves the active cell down a row automatically. If your cursor stays put after scanning, check the scanner's configuration guide for a "suffix" or "carriage return" setting, since that behavior comes from the scanner, not from Excel.

This Enter-after-scan behavior is usually called a "suffix" in scanner manuals, and it's on by default for most consumer scanners sold today. If scans are landing in the right cell but the cursor never advances, the fix lives in the scanner's settings, often set by scanning a special configuration barcode printed in its manual, rather than in any Excel option, according to ExcelDemy's troubleshooting guide. There is no Excel setting that controls this behavior directly, because Excel only sees keystrokes arriving, not which device sent them.

If you need something more elaborate, like a timestamp added automatically next to each scanned row, that requires a small VBA macro tied to a Worksheet_Change event, which is a more advanced step beyond plugging in a scanner.

How Do I Keep Barcode Numbers From Getting Mangled in Excel?

Format the destination column as Text before you scan anything, since Excel's default General format strips leading zeros from numbers and converts very long digit strings into scientific notation. A barcode like 00123456 can silently become 123456, which breaks inventory matching later.

To set this up, select the column, right-click, choose Format Cells, and pick Text, then scan into that column from the first empty row. This single step prevents the two most common complaints with barcode scanning in Excel: disappearing leading zeros and numbers displayed as something like 1.23E+11 instead of the actual code. For a broader look at building out a full scan-based tracking sheet rather than a single column, see our guide on using a barcode scanner for inventory.

Sources

Frequently Asked Questions

Can I scan a barcode directly into Excel?
Yes. A USB or Bluetooth barcode scanner set to keyboard mode types each scanned number straight into the active cell, with no extra software or import step. You click a cell, scan the barcode, and the data appears as if you had typed it, usually followed by an automatic Enter that moves to the next row.
How can I scan barcodes into Excel for free?
Most USB barcode scanners already work for free, since they act like a keyboard the moment you plug them in. If you don't own a scanner, free phone apps and browser-based tools can read a barcode with your camera and send the result into a spreadsheet or a file you open in Excel, without buying hardware.
Can I use my phone to scan barcodes into a spreadsheet?
Yes. Several free apps use your phone's camera to read a barcode and add a row to a connected spreadsheet, either directly to Google Sheets or by exporting a CSV or Excel file you open later. A web-based scanner that pairs with your browser can do the same without installing anything.
How do I make Excel move to the next row after each scan?
Most scanners are factory-configured to send an Enter keystroke after every scan, which moves the active cell down a row automatically. If your cursor stays put after scanning, check the scanner's configuration guide for a 'suffix' or 'carriage return' setting, since that behavior comes from the scanner, not from Excel.