Barcode in Excel: Definition, Types, Creation, Font Installation & Uses

We will create and use barcodes in Excel based on the model value of a product.

⏷What Is a Barcode in Excel?
⏷What Is a Barcode Font?
⏷How Many Types of Barcodes and Barcode Fonts Are Available in Excel?
⏵What Are the Differences Between Code 39 and Code 128 Barcode Fonts?
⏷Which Excel Versions Allow to Create Barcodes?
⏷How to Install Barcode Font in Excel?
⏷How to Create Barcode in Excel?
⏵1. Create a Random Barcode in Excel
⏵2. Create a Barcode from Random Numbers
⏵3. Create Barcodes Without Downloading Fonts
⏵4. Create Excel Barcodes with Mac, Android, and iOS
⏷Which Websites Provide Free Barcodes?
⏷How to Use Barcode Scanner in Excel?
⏵How to Use Barcode Scanner for Inventory in Excel?
⏷How to Print Excel Barcodes?
⏷What Are the Advantages and Disadvantages of Creating Barcode in Excel?
⏷What Are QR Codes and How to Create Them in Excel?

What Is a Barcode in Excel?

A barcode is a series of parallel black and white bars of different widths that represent numbers and symbols. Only machines can read barcodes and extract information encoded in them. Barcodes are mainly used in business industries regarding manufacturing, logistics, transportation, healthcare, etc.

What Is a Barcode Font?

A barcode font is a specially customized font to generate a barcode. It directly converts standard text characters into black-and-white bars of different widths. The black and white bars of different widths can encode a huge amount of information within a small space. As a result, it ensures better safety and lessens workloads.

Types of Barcodes and Barcode Fonts Are Available in Excel

Code 39: Code 39 barcode font for Excel can encode both numbers and letters. It also encodes characters like the dash (-), dollar sign ($), percent sign (%), slash (/), plus (+), a space, and the asterisk (*). It doesn’t recognize lowercase characters. So there is an alternative Code 39 font. It is the IDAHC39M Code 39 barcode font. We use it mostly to create barcodes.
Barcode: This is another popular font. It is the same as the Code 39 font.
Code 128: Code 128 barcode font for Excel is mostly used in shipping and supply change labels. It can encode the same characters as Code 39.
UPC/EAN: We use this as a product barcode. Here, UPC is Universal Product Code and EAN is European Article Numbering. It is also called as UPC-A. This is restricted to 12 characters.
I2of5: This means industrial 2 of 5 or interleaved 2 of 5. It can encode numeric characters only.
UPC-E: This is another UPC barcode. It omits certain characters like leading zeros. It can encode six-digit codes only.
QR: QR means Quick Response. This is a 2D barcode. We can use it to open a website or app after scanning with a mobile phone camera.
Postnet: The U.S. Postal Service used this. It can encode numeric characters.
Intelligent Mail: The U.S. Postal Service uses this now. It can encode up to 65 characters.

What Are the Differences Between Code 39 and Code 128 Barcode Fonts?

Features	Code 39	Code 128
Data Capacity	Limited, up to 43 characters	Entire ASCII character set
Information Density	Low	High
Error Handling	Poor	Advanced
Compactness	Low	High

Which Excel Versions Allow to Create Barcodes?

There is no built-in font to create barcode in Excel. But Excel provides limited capabilities to create one-dimensional barcodes such as Code 39 and Code 128 from the Excel 2007 version to the later ones. In order to create more sophisticated two-dimensional barcodes like QR Code, install third-party add-ins or external barcode generator software or websites.

How to Install a Barcode Font in Excel?

Go to the Dafont site to download the IDAHC39M Code 39 barcode font. The font is named IDAutomationHC39M.

Click here to enlarge the image.

Right-click on the downloaded file and click on Extract Here to unzip the font file at the same location.

Open the file with the .ttf extension.

Click on Install to install the font.

Restart Excel to have the font in Excel.
Similarly, you can download other barcode fonts like Code 128, Barcode Font, etc.

How to Create a Barcode in Excel

To explain all the barcode generation methods, we will consider the following dataset. The dataset contains the product information in the ‘Model’, ‘Device’, ‘Brand’, and ‘Price’ columns. We will use the values in the ‘Model’ column to generate barcodes.

Method 1 – Create a Random Barcode in Excel

Apply the following formula in cell F6 to get the model number of cell B6 in text format.

="("&B6&")"

Use the Fill Handle tool to apply the formula down to cell F15.

We have model numbers of all products in text format in the ‘Barcode’ column.

Select all the cells in ‘Barcode’.
Choose the IDAHC39M Code 39 font from the Font group under the Home tab.

We get barcodes from the model numbers.

Method 2 – Create a Barcode from Random Numbers

Use the following formula in cell F6 to generate a random number between 1000000 and 9999999.

=RANDBETWEEN(1000000,9999999)

Drag the Fill Handle to autofill to cell F15.

Select all the random numbers.
Copy the numbers by clicking on Copy from the Home tab.

Select cell F6 and paste the copied numbers as values from the Home tab.

Apply the following formula in cell G6 to get the number from cell F6 in text format.

="("&F6&")"

Use the Fill Handle to apply the formula to cell G15.

Select all the cells in ‘Barcode’ and choose the Code 128 font from the Font group under the Home tab.

This converts numbers to barcodes in Excel.

Note

The numbers generated from the RANDBETWEEN function get automatically changed. We have applied Copy-Paste at the same location to stop the change.

Method 3 – Create Barcodes Without Downloading Fonts

We can use the barcode generator websites (i.e. Barcodeapi) to create barcodes without font in Excel.

Insert the following formula in cell F6 and drag till F15 to auto-generate barcodes.

=IMAGE("https://barcodeapi.org/api/auto/"&B6)

Method 4 – Create Excel Barcodes with Mac, Android, and iOS

For Macs, we can generate barcodes in Excel just like a normal PC. Android supports barcode fonts. So, you can generate barcodes quite easily. You can also get help from barcode generator apps and websites. Due to security issues, iOS does not support random apps and websites to generate barcodes. You can download authorized barcode generator apps from the Apple Store and create barcodes.

Which Websites Provide Free Barcodes?

How to Use a Barcode Scanner in Excel?

Choose a barcode scanner that is appropriate for your computer.
Connect the scanner to your computer through Bluetooth or USB connectivity. In most cases, there is no need to install any additional software or add-ins to connect them. Read the manufacturer’s instructions carefully if there is any need for any special configuration steps.
Put the cursor on an Excel cell and scan the barcode of a product. You will have all the related information with the barcode in the Excel cells.
Repeat the scanning procedure to store data in an Excel worksheet.

How to Use Barcode Scanner for Inventory in Excel?

Connect the barcode scanner to your computer through USB or Bluetooth.
To have a trial of scanning, open a text editor (i.e. Notepad) and scan a barcode with the barcode scanner. We will have the related information with the barcode in the text editor as if it is typed manually.

Create a dataset with the column headers according to the information that we have in the trial portion in the text editor.
Put the cursor in a cell and scan the barcode with a scanner.

All the related information will be inserted in the Excel cells automatically.

Repeat the same procedures for all the products.

How to Print Excel Barcodes

Go to the File tab.

Click on the Print tab to have the print preview in a small window.
Click on the Print option to print the Excel barcodes.

Click here to enlarge the image.

Advantages and Disadvantages of Creating Barcode in Excel

The advantages of barcodes in Excel are:

Barcodes reduce data entry errors as entering data manually in spreadsheets is prone to errors.
They enable quick and efficient data collection.
They improve data security.
They are cost-effective.
You can easily customize them.
Barcode scanners can quickly read them.

The disadvantages of barcodes in Excel are:

You have to download the barcode fonts from other sites.
It is time-consuming. You can’t generate a lot of barcodes quickly.
Sometimes, you need to use some add-ins to create a barcode.
We need to implement a barcode scanner to read barcodes which requires a significant amount of initial cost.
Barcodes need proper physical maintenance to ensure their readability.

What Are QR Codes and How to Create Them in Excel?

To create QR codes in Excel, apply the following formula in cell D6 and drag to cell D10.

=IMAGE(“https://api.qrserver.com/v1/create-qr-code/?size=100×100&data=”&C6)

Download the Practice Workbook

Barcode in Excel.xlsx

Barcode in Excel: Knowledge Hub

<< Go Back to Learn Excel

Get FREE Advanced Excel Exercises with Solutions!