Learn how to Make QR Codes in Google Sheets

Even though there are lots of techniques you’ll be able to create QR code for a URL, like thru on-line and offline gear, on the other hand, there’s a moderately easy technique to create a QR code the usage of Google Sheets as neatly.

On this publish, I’ll display you two easy techniques to create a QR code the usage of Google Sheets. One approach comes to the usage of a Google Sheet method and the opposite will also be finished thru a Google Sheet add-on.

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

Learn how to Generate Barcodes in Google Sheets

There was once a time when companies wanted to shop for pricey barcode instrument to create barcodes for his or her merchandise…. Learn extra

Means 1. The usage of Google Sheets Method

Ahead of beginning, come to a decision which mobile you to insert the guidelines / URL in and which mobile to show the QR code at.

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

Cross forward and paste the next method in A2.

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

What this method does is – it takes the guidelines from mobile A1 and turns it right into a 300×300 (width x top) QR code.

Easy as that.

QR Code too small?

On the other hand, if you’re seeing a tiny QR code in mobile A2, like the only within the screenshot underneath, that’s most definitely as a result of you haven’t adjusted the peak of your row.

To make the QR code larger, move in between rows 1 and a pair of, pull it down, and also you’ll get a larger picture.

Means 2. The usage of Google Sheets Upload-ons

Whilst I don’t see a lot of a reason why to make use of this when you’ll be able to simply reach it thru approach 1, this means, on the other hand, turns out to be useful when you don’t wish to depend on remembering the QR code-generating method in Google Sheets.

To put in the extension, move to Extensions > Upload-ons > Get add-ons.

Within the Google Workspace Market, kind in “QR code maker”, hit seek, then click on at the first consequence.

Observe the on-screen directions to set up the QR Code Maker add-on.

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

This will likely open up a sidebar (at the proper) for the add-on. Kind on your textual content or URL within the Textual content or Hyperlink box, and hit Generate.