How to Use Barcode Scanners to Enter Excel Data

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Scanning bar codes is a great way to reduce human error and speed up data entry tasks in your business. Scanners are reasonably affordable, and they work with any computer program, including Excel. From the perspective of your operating system (and application), a scanned bar code is just text, and it will insert the text wherever there's an active cursor.


Step 1

Connect your barcode scanner to your computer.

Video of the Day

Step 2

Install any scanner software (such as a serial driver) supplied by your scanner manufacturer. If your scanner plugs into the USB port, the driver should load automatically.


Step 3

Start Excel. Click on the cell you want the scanned data to appear in.


Step 4

Scan a bar code; the data (numbers in most cases) will appear in the cell selected in Step 3. Your scanner may also have a pre-defined "Tab" or "Enter" bar code. Otherwise, you'll need to scan and press a key on the keyboard before scanning the next item.




Report an Issue

screenshot of the current page

Screenshot loading...