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


<< Go Back to Barcode in Excel | Learn Excel

What is ExcelDemy?

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

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

2 Comments
  1. Hello Alok Paul,
    Thank you for your helpful instruction. I don’t quite understand why mine wouldn’t work. I had the same code as your example, but it wouldn’t work. I cut and pasted your example into my spreadsheet, changed the information, and it worked. I don’t get it but thank you just the same!

    • Hello David Rascati,

      You are most welcome. If you want you can share your code here so that we can debug it to find out the reason.

      Regards
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo