Learn how to Make QR Codes in Google Sheets

by DS | Mar 22, 2023 | Etcetera | 0 comments

Despite the fact that there are many ways you’ll be capable to create QR code for a URL, like via online and offline tools, alternatively, there’s a reasonably simple way to create a QR code using Google Sheets as well.

In this put up, I’ll show you two simple ways to create a QR code using Google Sheets. One method involves using a Google Sheet method and the other may also be completed via a Google Sheet add-on.

.no-js #ref-block-post-61581 .ref-block__thumbnail { background-image: url(“https://assets.hongkiat.com/uploads/thumbs/250&occasions;160/google-sheets-create-barcode.jpg”); }

Table of Contents

Learn to Generate Barcodes in Google Sheets

There used to be as soon as a time when firms sought after to buy expensive barcode software to create barcodes for their products…. Be informed further

Approach 1. The use of Google Sheets Means

Forward of starting, make a decision which cell you to insert the ideas / URL in and which cell to turn the QR code at.

In our example, we’ll insert the URL in A1, and display the QR code in A2.

Move ahead and paste the following means in A2.

=image("https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl="&ENCODEURL(A1))

What this technique does is – it takes the ideas from cell A1 and turns it proper right into a 300&occasions;300 (width x best) QR code.

Simple as that.

QR Code too small?

However, in case you’re seeing a tiny QR code in cell A2, like the one throughout the screenshot beneath, that’s maximum certainly because of you haven’t adjusted the height of your row.

To make the QR code better, transfer in between rows 1 and a couple of, pull it down, and in addition you’ll get a bigger image.

Approach 2. The use of Google Sheets Add-ons

While I don’t see a large number of a explanation why to use this whilst you’ll be capable to merely succeed in it via approach 1, this implies, alternatively, comes in handy whilst you don’t need to rely on remembering the QR code-generating means in Google Sheets.

To place within the extension, transfer to Extensions > Add-ons > Get add-ons.

Inside the Google Workspace Marketplace, sort in “QR code maker”, hit search, then click on on on the first result.

Practice the on-screen instructions to arrange the QR Code Maker add-on.

Now to create a QR code with this add-on, transfer to Extensions > QR Code Maker > Insert QR Code.

This may occasionally most likely open up a sidebar (at the right kind) for the add-on. Type to your text or URL throughout the Text or Link field, and hit Generate.