All You Need to Know About Barcode in Excel

Barcodes are a bunch of lines and spaces representing some machine-readable information. Barcodes have a more comprehensive range of applications, starting from your products in a grocery store to something confidential. This tutorial on Barcode in Excel is all about understanding barcodes in detail and generating a couple of barcodes in a step-by-step manner.

What Is Barcode in Excel?

A barcode, in general, is a digital code storing machine-readable information that looks like a collection of black bars and white spaces. Microsoft excel has incorporated the addition of Barcode with some minor add-ons, like a new font.

Now that you know what a barcode is in general and what a barcode is in Excel, you will try to create a barcode using Microsoft excel.

Post Graduate Program in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
Post Graduate Program in Business Analysis

How to Generate Barcode in Excel?

Before creating a barcode in excel, you need to make sure that you have some related barcode fonts in Microsoft excel as they won't come as default. So, it’s best to walk through the procedure in a step-by-step manner.

First, check for the barcode font in Excel, and if unavailable, then an excellent suggestion would be to get one for free. Now, go ahead and try to install a barcode font in Excel using the explanation below.

Install Font for Barcode in Excel

There are a bunch of websites providing both paid and open-source barcode fonts software. 3 of 9 Barcode TrueType is one of the highly recommended ones.

Download the font package as shown below.

Barcode-in-Excel/Barcode-in-Excel-font

Unzip the downloaded package and run the setup file to install the font, as shown below.

Barcode-in-Excel-font-install.

Barcode in Excel

Now open Microsoft Excel and create an empty table as shown below.

Barcode-in-Excel/Barcode-in-Excel-1

Going ahead, try to enter the data in the first column. By default, the data type will be general. According to the input you provide, Excel will convert the data implicitly. For example, if you enter float data, then excel will implicitly convert the data type from general to float.

It is best to be on the safer side; so, manually assign the data type to the column as text data type, as this helps you create barcodes.

Barcode-in-Excel/Barcode-in-Excel-2.

The next step is writing a formula to generate a barcode.

FREE Business Analytics With Excel Course

Start your Business Analytics Learning for FREEStart Learning
FREE Business Analytics With Excel Course

The Formula for Barcode in Excel

There are various ways to write down a formula for generating a barcode in Excel. You will explore the two most straightforward ways as follows.

Select the cell adjacent to your input and write the formula as shown below. Here, my input column is 'A.'

You can write it down as follows:

"*" &A2&"*" or "("&A2&")"

Barcode-in-Excel-formula

After you write the formula, you can drag down the formula to apply the same formula to all the cells below, as shown in the following image.

Barcode-in-Excel-font-before.

Next, select the resultant column, in my case, column 'B,' and choose the barcode font from the fonts menu dropdown as shown below.

Barcode-in-Excel-font-added.

Free Course: Introduction to MS Excel

Master the Fundamentals of MS ExcelEnroll Now
Free Course: Introduction to MS Excel

The resultant final table will look like the following image below.

Barcode-in-Excel-font-final.

With this, you have come to an end of this tutorial on Barcode in Excel.

Looking forward to a career as a Business Analyst? Check out the Business Analytics Certification Training with Excel and get certified toda

Wrapping up

Slicers in Excel can be your next step in learning data analytics. Slicers play a vital role as a real-time data filter. Slicers can run the filter function on real-time data and provide expected results in a fraction of seconds while generating real-time interactive reports, crucial in real-time data visualization and analytics.

Interested to learn more about Business Analytics? Or wish to get trained and certified to become a successful Business Analyst? Then feel free to reach out to the Business Analytics certification course from Simplilearn. Ranked among the five topmost business analytics courses. This Simplilearn program is offered in partnership with Purdue University is an outcome-driven training and certification program that helps you master the fundamental concepts of statistics and data analytics. 

Have any questions for us on this tutorial on "Barcode in Excel"? If you do, or maybe you have doubts about our certification course, do reach out to us by sharing them as comments below. Our team of experts will address them and will be happy to answer them at the earliest. 

About the Author

SimplilearnSimplilearn

Simplilearn is one of the world’s leading providers of online training for Digital Marketing, Cloud Computing, Project Management, Data Science, IT, Software Development, and many other emerging technologies.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.