This tutorial demonstrates how to create barcodes in Excel and Google Sheets.
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.
3. The font is downloaded as a ZIP folder to your Downloads. Unzip it to get the .TTF (true to font) file.
4. Then, double-click on the .TTF file. You will see a preview of the font.
5. To install the barcode font, in the Font Preview window, click on Install.
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.
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.
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).
4. After that, select all cells with values in Column B (B2:B6) and in the Ribbon, go to Home > Font Menu > Code 39
5. Now all values in Column B are formatted as barcodes. Make barcodes more visible by increasing the font size.
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.