How to Use Barcode Scanner in Excel (2 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

The Barcode is a system to represent data in terms of bars. To read barcodes, you need a dedicated scanner. After that, you can extract that information into Excel. We will discuss how to use the barcode scanner in Excel.


What Is Barcode?

Barcode is an encoding process. It encodes information and represents it in the form of machine-readable black lines and white spaces with varying widths depending on the information. Barcodes are commonly used in packed products, super shops, and other modern shops.


How to Use Barcode Scanner in Excel: 2 Suitable Ways

There are two options to scan a barcode in Excel. One is to use a scanner to scan the barcode, other is to use an add-in Excel. Both ways are discussed below.

1. Use a Barcode Scanner and Show Scanned Code in Excel Cell

In this method, we will need a barcode scanner. Then applying the following steps, we can get the output codes in our Excel worksheets.

📌 Steps:

  • First, you need to manage a barcode scanner. Then turn off the computer and plug in the scanner on the exact port on the computer.
  • Now, turn on the computer and the scanner.
  • Open the desired Excel file. Point the cursor to the desired place of the sheet. We want to view the scanned date here.
  • Now, pick the barcode scanner and place it 6 inches away from a barcode. Or adjust the distance between the barcode and the scanner so that it can perform accurately.
  • Now, push the button of the scanner to activate that. After that, place the light on the barcode to scan.
  • Afterward, we will see that data is scanned and viewed on the selected cell of the worksheet.

Read More: How to Use Barcode Scanner for Inventory in Excel


2. Extract Data from Barcodes Created with Excel Code 39 Fonts

If you have some barcodes in an Excel sheet created with Excel Code 39 barcode fonts, you can use Excel fonts as if they were barcode scanners! Apply the following steps.

📌 Steps:

  • Say, we have the following barcodes for IDs in Column C.

  • Now, we will retrieve the alpha-numeric value from the barcode. Copy barcodes into the Result column.

Extract data from Scanned Barcode Created with Excel Code 39 Fonts

  • Choose cells from the Result column.
  • Go to the Font section. We choose Calibri font. You can choose other fonts as well.

Extract data from Scanned Barcode Created with Excel Code 39 Fonts

  • Barcodes are converted to alphanumeric values.

Read More: Barcode Scanner Entry to Excel Database with Timestamp


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, we described 2 ways to use a barcode scanner in Excel or use Excel as a barcode scanner. I hope this will satisfy your needs.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel projects.
Alok Paul
Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo