• Amit Sarda

How to create barcodes in Google Sheets

Updated: Jun 10

You can generate barcodes in Google Sheets using existing plain-text data in the Google Sheets document. Barcodes in Google Sheets are essentially a font and all you have to do is change the font of the column to a barcode font.

NOTE: If you love Google Sheets, you should check out the kind of apps you can build on top of Google Sheets using Glide Apps.

Creating Barcodes using fonts in Google Sheets
Barcodes in Google Sheets

If you can't find the barcode font in the list of fonts, click the More fonts button in the Font menu.

More fonts in Fonts menu
Click More fonts

Search for 39 in the list of fonts and select the fonts you'd like to use.

List of barcode fonts
List of barcode fonts

You can download this file as an Excel spreadsheet (.xlsx extension). You will have to install a barcode font on to your computer to see barcodes in Excel, and then repeat the process of changing the font of the barcode column to the newly installed barcode font.

If you want to print these codes, you can print them straight out of the Google Sheets document to a printer or to a PDF.

#googlesheets #barcodes #spreadsheets #excel

1,035 views0 comments