See all How-To Articles

How to Create / Generate Barcodes in Excel & Google Sheets

This tutorial demonstrates how to create barcodes in Excel and Google Sheets.

 

create barcodes 12

 

Add Barcode Font in Excel

In Excel, you can format cells as barcodes which can be very useful, especially in inventory management. For example, you can create a product catalog with all barcodes, print product UPC codes, or track items easily. To use barcodes in Excel, you need to have a barcode font installed. Code 39 is the most frequently used font. To download it, follow these steps:

1. You can download Code 39 from several sources. Try this one.

2. After opening this link, choose Code 39 on the page and click the Download button.

 

create barcodes 1

 

3. The font is downloaded as a ZIP folder to your Downloads. Unzip it to get the .TTF (true to font) file.

 

create barcodes 2

 

4. Then, double-click on the .TTF file. You will see a preview of the font.

 

create barcodes 3

 

5. To install the barcode font, in the Font Preview window, click on Install.

 

create barcodes 4

 

As a result, the barcode font is installed on your computer. To see it listed in your fonts, you may need to reopen Excel.

Create Barcodes in Excel

1. Once you have a barcode font installed, you are ready to create barcodes from a list of numbers. For example, see the list below in Column A. Let’s create barcodes from those numbers in Column B. First, be sure that all values from Column A are formatted as text, in order to avoid numbers shortening.

 

create barcodes 5

 

2. To format values from Column A, select those cells and in the Ribbon, go to Home > General > Text.

If you skip this step, Excel will omit leading zeros, or shorten large numbers.

 

create barcodes 6 new

 

3. Now, copy the values from Column A to Column B. To do that, in cell B2 enter =A2 and then, drag the formula down to the last populated cell in the column (B6).

 

create barcodes 10 new

 

4. After that, select all cells with values in Column B (B2:B6) and in the Ribbon, go to Home > Font Menu > Code 39

 

create barcodes 11 new

 

5. Now all values in Column B are formatted as barcodes. Make barcodes more visible by increasing the font size.

 

create barcodes 12

 

You may already have the values you need for your barcodes. If not, consider using the RAND Function or Rnd in VBA.

Create Barcodes in Google Sheets

In Google Sheets, you can create barcodes exactly the same way. Once you install the font, it’s also available in Google Sheets under the name Libre Barcode 39.