How to create barcodes in Google Sheets with Barcode Fonts
Learn how to create barcodes in Google Sheets or Excel using formatting with Barcode Fonts like Libre Barcode.
TLDR (Too long, didn’t read)
Barcodes are just fonts in Google Sheets or Excel. Use font ‘Libre Barcode 39‘ in Google Sheets to convert a number to barcode. You can scan barcodes to Google Sheets using this FREE Glide App.
What are barcodes in Google Sheets?
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 to be able to create barcodes in Google Sheets.
Creating barcodes in Google Sheets
Simply select the column of values that you want to convert to a barcode. Then, head to the font section in your toolbar to select the right font.
If you can’t find the barcode font in the list of fonts, click the ‘More fonts‘ button in the Font menu.
Search for 39 in the list of fonts and select the fonts you’d like to use
How to print barcodes in Excel or Google Sheets
You can download this file as an Excel spreadsheet (.xlsx extension). You will have to install a barcode font on 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.
How to scan barcodes to Google Sheets
With Glide Apps, there is an easy way to scan barcodes to a Google Sheets workbook.
You can do this for a list of existing items, and also scan it when adding new items on the fly.
You can preview and get this Barcode Scanner app for FREE here: Barcode Scanner in Glide Apps.