Create Barcodes In Google Sheets In 2 Easy Steps
║█║▌║█║▌│║▌║▌█║

Barcodes are visual representations of numbers and strings.

Typically they represent numbers that link back to records in a database storing valuable information about a product.

They’re easy for machines to scan and are ubiquitous in stores and warehouses around the world.

Learn how to create barcodes in Google Sheets in this post, with a simple 2-step process.

Step 1: Download The Barcode Fonts

There are three families of barcode fonts available in Google Sheets:

  1. Libre Barcode 39 for Code 39 barcodes. These are commonly used as labels in industry, e.g. name badges, inventory, and applications.
  2. Libre Barcode 128 for Code 128 barcodes. These are used extensively in packaging and the shipping industry.
  3. Libre Barcode EAN13 for EAN barcodes. These barcodes are commonly used in retail.

To add these fonts, go to the font menu in your toolbar and click on “More fonts”:

add More Fonts Menu

In the font popup, search for “Libre barcode”.

Select all of the Libre Barcode fonts (39, 39 Extended, 39 Text, 39 Extended Text, 128, and EAN13) and click OK:

Libre Barcodes In Google Sheets

Step 2: Format Values As Barcodes In Google Sheets

Highlight the number and apply one of the new Libre Barcode fonts you downloaded in step 1:

font Barcode Format Google Sheets

Note:

To use Code 39, you need to wrap your number with * asterisks. You can do this easily with this formula:

="*"&A1&"*"

Code 128 and EAN13 do not require any modification. The number can be formatted directly as a barcode.

Code 39 Barcodes in Google Sheets

Libre Barcode 39 turns values into a plain barcode according to Code 39.

And Libre Barcode 39 Text turns values into a barcode with the ID number printed underneath.

Code 39 barcode

Code 128 Barcode Examples

Libre Barcode 128 turns values into barcodes according to Code 128.

Libre Barcode 128 Text does not appear to be available in the Google Sheets font library.

code 128 Example

EAN13 Barcode Examples

There are various barcodes available with the Libre Barcode EAN13 font, shown here:

barcodes in Google Sheets

You can scan or even print these barcodes and use them in the real world.

Nice!

Barcodes in Google Sheets Template

Click here to open a view-only copy >>

Feel free to make a copy: File > Make a copy…

If you can’t access the template, it might be because of your organization’s Google Workspace settings.

In this case, right-click the link to open it in an Incognito window to view it.

If you enjoyed this post, you might also enjoy:

How To Add Subscript and Superscript In Google Sheets

A Complete Guide To The Google Sheets Custom Number Format

Leave a Reply

Your email address will not be published.