Generating barcodes in Google Sheets


Making barcodes in Google Sheets

25 May, 2021 · 1 min read

We learned how to create QR codes in Google Sheets, and with that, I thought let me try and see if Barcodes are also possible.

It turns out it is!

Creating barcodes in Google Sheets

To start, let’s write the product IDs in column A. This will be our reference point.

Google Sheets product IDs

To make a valid barcode, we need to get that value and append two stars (*).

Let’s fix that with a formula in row B.


This will take the value from row A and wrap it in the two stars. Pull down the cells to have it working for all items.

Barcode raw

You might be thinking, ok, but how is this now a barcode? And the magic is actually in the font we will be using!

Select row B and click “More fonts” change the font to be “Libre Barcode” there are two options, but we’ll use Code 39 for this article.

You now have barcodes in your Google Sheet.

Barcodes in Google Sheet

Check out my Barcode Google Sheet here.

Thank you for reading, and let’s connect!

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter

Spread the knowledge with fellow developers on Twitter
Tweet this tip
Powered by Webmentions - Learn more

Read next 📖

I wrote 1000 articles, what’s next?

22 Dec, 2022 · 3 min read

I wrote 1000 articles, what’s next?

Too much, and yet not enough

7 Dec, 2022 · 3 min read

Too much, and yet not enough

Join 2099 devs and subscribe to my newsletter