Have you ever wondered how those barcode numbers magically appear on products? Barcodes are visual representations of numbers and strings that hold valuable information about a product. They are everywhere – in stores, warehouses, and more. Now, you can create barcodes in Google Sheets with just a few steps.
Step 1: Download Barcode Fonts
Google Sheets offers three barcode font families:
- Libre Barcode 39 for Code 39 barcodes. These barcodes are commonly used for identification badges, inventories, and applications.
- Libre Barcode 128 for Code 128 barcodes. These barcodes are widely used in the packaging and transportation industry.
- Libre Barcode EAN13 for EAN barcodes. These barcodes are commonly used in the retail industry.
To add these fonts to your Google Sheets, simply go to the font menu on your toolbar and click on “More Fonts”. In the font window, search for “Libre Barcode”. Select all the Libre Barcode fonts (39, 39 extended, text 39, text extended 39, 128, and EAN13) and click OK.
Step 2: Format Values as Barcodes in Google Sheets
Select the number you want to convert into a barcode and apply one of the downloaded Libre Barcode fonts.
Note: To use Code 39, surround your number with asterisks (*). You can easily do this with a simple formula. However, Code 128 and EAN13 do not require any modifications. The number can be directly formatted as a barcode.
Code 39 Barcodes in Google Sheets
Libre Barcode 39 transforms values into simple Code 39 barcodes.
Libre Barcode 39 Text transforms values into barcodes with the identification number printed below.
Code 128 Barcode Examples
Libre Barcode 128 transforms values into Code 128 barcodes.
Unfortunately, Libre Barcode 128 Text does not seem to be available in the Google Sheets font library.
EAN13 Barcode Examples
Multiple barcodes are available with the Libre Barcode EAN13 font.
You can scan or print these barcodes and use them in the real world.
Amazing, right?
Barcode Template in Google Sheets
Click here to open a read-only copy of the barcode template.
Feel free to make a copy: File > Make a copy…
If you are unable to access the template, it may be due to your organization’s settings for Google Workspace. In that case, right-click the link to open it in a private browsing window.
Conclusion
Creating barcodes in Google Sheets is now quick and easy. Impress your friends with your newfound barcode skills and make mundane tasks a breeze.
Related Articles:
