DEV Community

Cover image for Generating barcodes in Google Sheets
Chris Bongers
Chris Bongers

Posted on • Originally published at daily-dev-tips.com

Generating barcodes in Google Sheets

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!

Generating barcodes in Google Sheets

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.

="*"&A1&"*"
Enter fullscreen mode Exit fullscreen mode

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

Top comments (0)