How to create Barcodes in Google Sheets

← Prev

Using Libre Barcode 39 Text font, you can easily create Barcodes in Google Sheets. Just follow these simple steps.

1) Sign in to your Google account.

2) Go go Google Sheets and create a new spreadsheet, or you can open an exisiting spreadsheet.

3) Assuming, I have few columns in my spreedsheet. I want to create barcodes based on values in the fourth (D) column.

create barcodes in google sheets

4) Write a formula to write all the numbers in the "D" column into the "E" (Barcode) column. So, it will show the numbers with asterisks (*) as suffix and prefix.

="*"&D2&"*"

add formulas in google sheets

5) Next, you need to select Libre Barcode 39 Text, which you can find in the fonts library.

Select the first cell in the "barcode" column. Click the font bar and choose "More fonts". It will open the "Fonts" dialog box. Type "Libre barcode 39 text" in the "search" box. Select the font and click "OK".

select libre barcode 39 text font in google spreadsheet

6) Finaly, drag the column down to convert all the numbers in the barcode column into barcodes.

That's it. 🙂

Articles you don't want to miss.

How to import XML data from URL into Google spreadsheet using a custom function?
How to make Google Donut (Pie) Chart using Dynamic data and Web API
How to create Column Charts using Highcharts API using data from external JSON file

← Previous