The 4 Best Barcode Scanners for Excel in 2026
(+ How to Scan Into Excel)

If you track stock, assets or orders in Excel, a barcode scanner is the fastest way to get data from the shelf into your spreadsheet. No typos, no squinting at 13-digit numbers.

The good news: almost any USB or Bluetooth barcode scanner works with Excel, with no extra software. The scanner acts like a keyboard, so whatever it scans gets “typed” into the cell you have selected.

So the real question isn’t “will it work with Excel?” It’s which scanner fits the way you work: at a desk, walking around a stockroom, or on a phone or tablet. In this guide I’ll give you 4 picks for those situations, and then show you exactly how to scan into Excel cells (including the Enter vs. Tab setting that trips up most people).

A barcode scanner is just a very fast, very accurate keyboard. If you can type into a cell, you can scan into it.
Kasper Langmann, Microsoft Excel & Copilot MVP

Quick picks (October 2026)

  • Best overall: Zebra DS2208. Corded USB, reads 1D and 2D codes (including QR) and comes with a 5-year warranty. Around $100.
  • Best wireless for inventory: Honeywell Voyager XP 1472g. Up to 100 m (300 ft) of Bluetooth range with its base and up to 100,000 scans per charge. Around $175.
  • Best budget wireless: Tera 8100. Bluetooth, 2.4G dongle or USB cable, a stand and a storage mode for offline scanning. Around $70.
  • Most portable (and best for phones and tablets): Inateck BCST-42. A pocket-size 2D scanner that weighs 84 g and has an inventory mode. Around $35 to $70.

The short answer: any scanner that works in “keyboard” (HID) mode will type straight into Excel. Get a 2D scanner (it reads normal barcodes and QR codes), go corded if you scan at a desk, and go wireless with memory if you count stock away from your computer.

Prices change often, so always check the live price before you buy.

What Matters When You Scan Into Excel

Excel doesn’t have a “barcode scanner” feature, and it doesn’t need one. Here’s what actually matters when you pick a scanner for Excel work.

1. Keyboard-wedge (HID) mode: the reason it “just works”

Almost every scanner sold today can act as a USB HID keyboard (HID stands for Human Interface Device). Older manuals call it “keyboard wedge” mode. Your computer thinks you plugged in a second keyboard, and every scan is typed as keystrokes, usually followed by an Enter key.

That’s why you don’t need drivers, add-ins or special software. It also means:

  • The scan goes wherever your cursor is. If Excel isn’t the active window, the code gets typed into your email or browser instead.
  • The keyboard layout must match. If your computer uses a non-US keyboard layout, set the scanner to the same layout (there’s a setting barcode for it in the manual). Otherwise some characters come out wrong.
  • It works in Excel for Windows, Excel for Mac and Excel for the web, because to Excel it’s just typing.

2. USB vs. 2.4G dongle vs. Bluetooth

  • Corded USB: zero setup, no battery to charge, and nothing to lose. Perfect at a desk or checkout counter.
  • 2.4G wireless dongle: plug the little receiver into a USB port and the scanner behaves like a corded one, just without the cable. The easiest wireless option for a PC.
  • Bluetooth: pairs like a Bluetooth keyboard, so it also works with laptops without a free USB port, phones and tablets.
  • Charging base / cradle: business scanners like the Honeywell 1472g pair with a base that’s plugged into your PC. That gives you much longer range than a laptop’s own Bluetooth.

3. 1D vs. 2D (QR) scanners

1D barcodes are the classic black lines: UPC and EAN codes on retail products, Code 128 and Code 39 on shipping and asset labels. 2D codes are squares or dots: QR codes, Data Matrix (often on small parts and medical products) and PDF417 (on shipping labels and many driver’s licenses).

A 2D “area imager” reads both, plus codes shown on a phone screen. Older 1D laser scanners can’t read QR codes or screens. The price difference is small today, so all 4 picks below are 2D scanners.

4. Memory and inventory (batch) mode

If you count stock in a stockroom or warehouse, you’ll walk out of range sooner or later. Scanners with a storage or inventory mode save the scans in the scanner’s memory, and send them all to your computer later. When they upload, they type the whole list into Excel, one code per row.

If you always scan at your desk, you don’t need memory at all.

5. Durability and comfort

If you scan hundreds of items a day, a proper pistol grip and a real drop rating matter. Business-grade scanners from Zebra and Honeywell list how many drops to concrete they’re designed to survive, and come with longer warranties than budget brands.

1. Zebra DS2208 (best overall)

The Zebra DS2208 is the scanner I’d buy if you scan at a desk, a packing station or a checkout counter. Zebra is one of the biggest names in barcode scanning, and the DS2208 is one of its everyday workhorse models.

It’s a corded USB scanner, so there’s nothing to pair and no battery to charge. It reads both 1D barcodes and 2D codes like QR, Data Matrix and PDF417, so it handles product labels, shipping labels and asset tags.

Zebra DS2208 corded 2D barcode scanner for Excel

Key specs

  • Type: Corded 2D area imager (also reads all common 1D barcodes)
  • Connection: USB (the kit DS2208-SR7U2100AZW includes a shielded USB cable). Also supports keyboard wedge and RS232.
  • Scan range: 0.5 to 14.5 inches for a standard UPC code
  • Durability: Designed to survive multiple 5 ft (1.5 m) drops to concrete, IP52 sealing
  • Warranty: 60 months (5 years) on the corded scanner
  • Setup tool: Zebra’s free 123Scan utility for changing settings and updating firmware

Why it’s great for Excel

  • Plug in and scan. No battery, no pairing, no dongle to lose.
  • Easy to change the suffix. Whether you want Enter or Tab after each scan, you can set it with a programming barcode or with 123Scan.
  • Long warranty. 5 years is far longer than budget scanners.

Downsides: It’s corded, so it only works as far as the cable reaches, and it has no memory for offline scanning. If you need a cordless version, Zebra sells the same scanner as the DS2278.

Format your scan column as Text before the first scan. Otherwise Excel removes leading zeros from codes like 012345678905 and shows long codes in scientific notation.
Kasper Langmann, Microsoft Excel & Copilot MVP

2. Honeywell Voyager XP 1472g (best wireless for inventory)

If you count stock away from your desk, the Honeywell Voyager XP 1472g is my pick. It’s a cordless 2D scanner built for all-day use, and its charge and communication base gives you much more range than a typical Bluetooth scanner.

Plug the base into your PC, put the scanner in the base to pair it, and you can walk around the stockroom while every scan lands in your open Excel sheet.

Honeywell Voyager XP 1472g cordless barcode scanner for Excel inventory

Key specs

  • Type: Cordless 2D area imager (reads 1D, QR, Data Matrix, PDF417 and codes on phone screens)
  • Range: Up to 100 m (300 ft) line of sight with Honeywell’s charge and communication base (Bluetooth 4.2)
  • Battery: Replaceable 2,400 mAh, up to 100,000 scans per charge (at 1 scan per second), up to 28 hours of operation
  • Durability: Engineered for 30 drops from 1.8 m (6 ft) to concrete and 1,000 tumbles, IP52 sealing
  • Interfaces: USB, keyboard wedge and RS-232, with support for 84 international keyboard layouts
  • Warranty: 3 years (battery 1 year)

Why it’s great for Excel

  • Range. Your laptop can stay on the desk while you scan at the far end of the stockroom.
  • Battery. A full count on one charge, and the battery can be replaced when it wears out.
  • Keyboard layouts. Support for 84 international keyboards makes it easy to avoid scrambled characters on non-US computers.

Downsides: It costs more than budget wireless scanners. Also note that the Amazon kit I link to is sold by a third-party seller, so check the seller and what’s in the box before you buy.

Good to know: In August 2026, Honeywell sold its scanner business (Productivity Solutions and Services) to Brady Corporation. The Voyager scanners are still listed and supported on Honeywell’s product site, which now notes the business is part of Brady.

Scan into an Excel Table (select your data and press Ctrl+T). Every new row you scan automatically gets the same formulas and formatting as the rows above it.
Kasper Langmann, Microsoft Excel & Copilot MVP

3. Tera 8100 (best budget wireless)

The Tera 8100 is the budget pick from my old list that I’d still recommend, now in its newer 8100 version. It costs a fraction of the business scanners, and it gives you all three ways to connect: Bluetooth, a 2.4G USB dongle or the USB cable.

It also comes with a stand, so you can use it hands-free at a counter, and it has a storage mode for scanning away from your computer.

Tera 8100 wireless 2D barcode scanner with stand for Excel

Key specs

  • Type: Wireless 2D imager (reads 1D, QR, Data Matrix, PDF417, Aztec and MaxiCode)
  • Connection: Bluetooth, 2.4G USB dongle or USB cable
  • Upload modes: Instant upload, or storage mode (scans are saved and sent to the computer later)
  • Battery: Tera lists 35 hours of continuous scanning and 170 days of standby, with a battery level indicator
  • Durability: Rugged, drop-resistant design that Tera rates IP66
  • In the box: Scanner, stand, USB cable and USB dongle
  • Works with: Windows, macOS, Linux, iOS and Android

Why it’s great for Excel

  • Storage mode for stock counts. Scan the whole shelf, walk back to your PC and upload everything into a column in one go.
  • Data editing per barcode type. Tera says you can set rules for specific symbologies, for example adding Tab characters to Code 39 scans. That can split one scan across several Excel columns.
  • Silent mode. Switch the beep to vibration if you scan in an office or library.

Downsides: Tera doesn’t publish how many scans the memory holds, and the warranty and drop ratings are not in the same league as Zebra and Honeywell. Tera also notes it’s not compatible with Square.

Before you upload stored scans, click the first empty cell in your scan column. The scanner types the whole batch from wherever your cursor is.
Kasper Langmann, Microsoft Excel & Copilot MVP

4. Inateck BCST-42 (most portable)

The Inateck BCST-42 is for people who want a scanner in their pocket rather than a scanner gun on the desk. It’s a small 2D scanner (11.5 x 4.7 x 2.7 cm, 84 g) that connects by Bluetooth, 2.4G dongle or USB-C cable.

It’s my pick if you scan into Excel on a phone or tablet, or if you only scan now and then and don’t want a big device lying around.

Inateck BCST-42 pocket 2D Bluetooth barcode scanner for Excel

Key specs

  • Type: Portable 2D imager (reads 1D, GS1, QR, PDF417, Aztec and Data Matrix, on paper and on screens)
  • Connection: Bluetooth 5.0, 2.4G USB dongle or USB cable
  • Inventory mode: Yes, switched on and off with the shortcut buttons
  • Range: Inateck lists a transmission distance of at least 35 m
  • Battery: 1,200 mAh
  • Works with: Windows, macOS, Linux, Android, iOS and ChromeOS
  • Size and weight: 11.5 x 4.7 x 2.7 cm, 84 g

Why it’s great for Excel

  • Phone and tablet friendly. Over Bluetooth it works like a keyboard, so it can type into a spreadsheet on a phone or tablet.
  • Shortcut buttons. Pairing, inventory mode and battery check are on the device, so you don’t need the manual for everyday use.
  • Cheap enough for a team. You can give one to everyone who does stock counts.

Downsides: No pistol grip and a smaller battery than the bigger scanners, so it’s not the best choice for hundreds of scans per hour. The price also varies a lot between colors and sellers.

Testing a new scanner? Open Notepad (or TextEdit on a Mac) and scan a few codes first. If they look right there, they’ll look right in Excel.
Kasper Langmann, Microsoft Excel & Copilot MVP

How to Scan Barcodes Into Excel (Step by Step)

Here’s the setup I’d use for a simple inventory list. It works with any of the scanners above.

Step 1: Connect and test the scanner

Plug in the USB cable or dongle, or pair the scanner in your Bluetooth settings. Then open Notepad and scan a barcode. You should see the number appear, followed by a new line. If the characters look wrong, set the scanner’s keyboard layout to match your computer (there’s a programming barcode for it in the manual).

Step 2: Format the column as Text

Select the column you’ll scan into, go to Home > Number Format and choose Text. Do this before you scan.

Why? Excel treats a scanned barcode as a number. It drops leading zeros (so 012345678905 becomes 12345678905), shows long codes like 4006381333931 in scientific notation, and only keeps 15 significant digits, so longer codes get changed.

Step 3: Click a cell and scan

Click the first empty cell and scan. The scanner types the code and presses Enter, so Excel moves to the next row, ready for the next scan.

Better yet, turn your list into an Excel Table first (Ctrl+T). Then every scanned row automatically gets the formulas you’ve set up next to it.

Step 4: Choose Enter or Tab after each scan

What happens after each scan depends on the scanner’s suffix, the key it “presses” after the code. Most scanners send Enter by default, and you can change it by scanning a programming barcode from the scanner’s manual (or with the scanner’s setup software).

Suffix What Excel does Use it when
Enter (default) Moves down to the next row You’re building a list of scans in one column
Tab Moves right to the next column You scan a code, then type a quantity or note next to it
None Stays in the cell (in edit mode) Rarely useful in Excel, you’d have to press Enter yourself

Two Excel tricks that help:

  • If you use Tab, type your first code in column A, Tab across the row, and press Enter at the end. Excel jumps back to column A on the next row.
  • You can change where Enter moves in Excel itself: File > Options > Advanced > After pressing Enter, move selection. Set the direction to Right if you want every scan to go across instead of down.

Step 5: Turn scans into an inventory count

The simplest stock count needs two sheets:

  • Scans: one column where you scan every item you count (one scan per item).
  • Products: your product list with columns for Barcode, Name and Expected quantity.

In the Products table, add a Counted column with COUNTIF:

=COUNTIF(Scans!A:A, [@Barcode])

Then add a Difference column (=[@Counted]-[@[Expected quantity]]) and you can see straight away which items are missing.

To see the product name next to each scan, use XLOOKUP in the Scans sheet:

=XLOOKUP(A2, Products[Barcode], Products[Name], "Not found")

Anything that shows “Not found” is a code that isn’t in your product list (or a mis-scan). For a summary of counts per product, a PivotTable on the Scans sheet does the job in a few clicks.

Important: XLOOKUP is strict about text vs. numbers. If your scans are stored as text (Step 2), store the barcodes in your product list as text too, or the lookup won’t find them.

Optional: add a timestamp to every scan with VBA

If you want to know when each item was scanned, this small macro adds the date and time in column B whenever something is entered in column A. Right-click the sheet tab, choose View Code and paste it in (and save the file as .xlsm):

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Intersect(Target, Me.Range("A:A")) Is Nothing Then Exit Sub
    If Target.Value = "" Then Exit Sub
    Application.EnableEvents = False
    Target.Offset(0, 1).Value = Now
    Application.EnableEvents = True
End Sub

New to macros? Here’s my introduction to VBA.

Scanning unique items like assets or serial numbers? Select the column and use conditional formatting (Highlight Cells Rules > Duplicate Values) to spot double scans right away.
Kasper Langmann, Microsoft Excel & Copilot MVP

How to Generate Barcodes in Excel

Scanners read barcodes, but you may also need to create them, for example for your own products, shelves or assets. You can do that with labeling software, an online barcode generator, or right in an Excel spreadsheet.

If you want to generate barcodes in Excel, learn how in my video guide below.

FAQ: Barcode Scanners and Excel

Can you use a barcode scanner with Excel?

Yes. Any scanner that works in USB HID (keyboard) mode types the scanned code into the active cell, just like a keyboard. That covers almost every USB, 2.4G and Bluetooth scanner sold today, including all 4 picks in this guide.

How do barcode scanners work with Excel?

The scanner reads the barcode, turns it into characters and sends them to your computer as keystrokes, usually followed by Enter. Excel doesn’t know (or care) that it came from a scanner. That’s also why you need to click the right cell before you scan.

Do I need special software to scan barcodes into Excel?

No. For basic scanning you don’t need any software at all. Some scanners come with optional setup tools (like Zebra’s 123Scan) for changing settings, but you can also change most settings by scanning programming barcodes in the manual.

How do I make the scanner jump to the next cell?

Set the scanner’s suffix. Enter moves down to the next row, and Tab moves right to the next column. Most scanners send Enter by default. See Step 4 above for when to use which.

Why does Excel change my barcode numbers?

Because it treats them as numbers. Excel removes leading zeros, shows long numbers in scientific notation and only keeps 15 significant digits. Format the column as Text before you scan to keep every code exactly as printed.

What is a barcode scanner with memory?

It’s a wireless scanner that can save scans in its own memory when it’s out of range (often called storage, batch or inventory mode). When you’re back at your computer, you upload the scans and they’re typed into Excel in one go. The Tera 8100 and Inateck BCST-42 both have this.

What’s the best wireless barcode scanner for inventory?

For heavy, daily stock counts I’d pick the Honeywell Voyager XP 1472g, because of its range with the base, battery life and durability. On a budget, the Tera 8100 with its storage mode is a good alternative.

Do you need a cordless scanner for the aisles and a corded one at checkout?

That’s a common setup. A corded scanner (like the Zebra DS2208) is cheaper, never needs charging and suits a fixed checkout. A cordless scanner is what you want for counting stock in the aisles or the stockroom. Many small businesses start with one cordless scanner that can also sit in a stand at the counter.

Should I get a 1D or a 2D barcode scanner?

Get a 2D scanner unless you’re on the tightest budget. It reads normal 1D barcodes too, plus QR codes, Data Matrix, PDF417 and codes on phone screens. The price difference is small today.

Can I scan barcodes into Excel on a phone or tablet?

Yes. Pair a Bluetooth scanner (like the Inateck BCST-42) with your phone or tablet, open your workbook in the Excel app, tap a cell and scan. There are also phone apps that use the camera as a scanner, which is fine for a few scans but much slower than a real scanner for a full stock count.

Does a barcode scanner work with Excel on a Mac?

Yes. In keyboard (HID) mode the scanner works on a Mac the same way it works on Windows. Just check that the scanner’s optional setup software runs on macOS, or use the programming barcodes in the manual instead.

Can I use a barcode scanner with an Excel macro?

Yes. Because a scan is just typed input, you can use a Worksheet_Change macro to react to every scan, for example to add a timestamp or look up a product. See the example in the how-to section above.

Final Thoughts

Any of these 4 scanners will type straight into Excel. The right one depends on where you scan:

Whichever you choose, format your scan column as Text, decide between Enter and Tab, and let COUNTIF and XLOOKUP do the counting. If you export scans from other systems, you may also find my guide to CSV files useful.