Skip to content

Bar and QR Codes in Google Sheets

In this article, I will show you how you can create bar codes and QR codes in Google Sheets.

If that sounds fun to you, then let’s get to it!

Create QR Codes in Google Sheets

To create a QR code in Google Sheets, you need three things.

  • The URL of the website you want the QR code to link to
  • The URL for the Google QR Code API
  • The IMAGE and ENCODEURL functions

Of course, you can’t create a QR code without having a website to link to. So you need to make sure you have the URL for the website entered somewhere in your Google Sheets spreadsheet.

Next, you need the URL for the Google QR Code API. This is simply a link to software that will generate the QR code for you. The URL for the Google QR Code API is as follows:

https://chart.googleapis.com/chart?chs=250x250&cht=qr&chl=

Make sure you have this URL entered somewhere in your Google Sheets spreadsheet.

Finally, select the cell where you want your QR code to go. You might also want to expand the row height and column width of the cell to allow plenty of space for the QR code.

Within the selected cell, enter the following formula.

=IMAGE(googleAPIurl & ENCODEURL(url))

In the case of my example, the formula is as follows:

=IMAGE(D5 & ENCODEURL(B5))

The IMAGE function takes the Google API call and the website URL and transforms these items into an active QR code for your desired website.

Create Bar Codes in Google Sheets

To create bar codes in Google Sheets, you need two things.

  • The ID numbers for your products
  • A Libre Barcode font

To begin, make sure you enter the ID numbers for your products somewhere in your spreadsheet.

Next, you must add a Libre Barcode font to your list of available fonts. Click on the fonts button in the toolbar and then select More Fonts.

Type ‘barcode’ into the search box, and you will see a list of fonts to choose from. Go ahead and select the fonts you want, and then click Ok.

For this example, I will add the following fonts.

  • Libre Barcode 39
  • Libre Barcode 39 Text
  • Libre Barcode 128

Once you have your IDs and barcode fonts, you are ready to create barcodes.

For Code 39 barcodes, copy each ID where you want the barcode. You must also enter an asterisk before and after the ID number for each product.

You can do this by using the following formula.

="*" & productID & "*"

For Code 128 barcodes, only the ID number is necessary.

Once your IDs are ready, simply change the font to create the desired barcodes. You might also want to increase the font size to make the barcodes more visible.

And just like that, you have automatically generated barcodes in Google Sheets!

If you found this article interesting or useful, leave me a comment below to let me know! I hope you had a blast learning how to create bar and QR codes in Google Sheets.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top