How to create QR codes in Google Sheets. Let’s explore about QR codes today. One kind of optical label used to identify a product is a QR code; machines can read these labels. These days, businesses, eateries, and marketers employ these labels, sometimes known as QR codes, everywhere in malls. We will discover how to create QR codes in Google Sheets by following this tutorial on the subject.
Why is it Important to use QR Codes in Google Sheets?
Effective Data Entry: Data, such as product details, inventory details, or contact details, can be represented via QR codes. By scanning these codes, data entry is made easier, which speeds up the process and lowers the possibility of human error.
Management of Inventory: Businesses that manage inventories can give each item a QR code. Inventory management procedures are streamlined by scanning these codes, which give fast access to information such as location, stock levels, and other pertinent details.
Linking Documents: Documents kept on Google Drive or other cloud services can be accessed via QR codes. This eliminates the need for long URLs and is especially helpful for distributing papers, presentations, or forms.
You may also like>>> How To Calculate Hours Worked In Google Sheets [2 Ways]
How to Create QR Codes in Google Sheets
There are two effective ways to generate QR codes in Google Sheets, which we will cover in this article.
- Create QR Code Using Formula
- Create QR Code Using Add-on
Create QR Code Using Formula
The IMAGE function in Google Sheets allows you to generate a QR code. To make a QR code in Google Sheets, follow the steps below, where we will go over each step of the formula in detail. There is a prepaid link in Google Sheets.
Step 1>
This sample data contains a URL in a column from which, using a formula, we will generate a QR Code in Google Sheets. Now let’s look at how to make QR codes in Google Sheets.
Step 2>
To make a QR Code in Google Sheets, first point the cursor where you want it to go and use the IMAGE function to write an image in the cell with an equal sign, as seen below.
Step 3>
First, as stated below, we will write this link in the syntax using quotation marks after initializing the IMAGE function in the cell.
Complete Formula: =IMAGE(“https://chart.googleapis.com/chart?chs=300×300&cht=qr&ch1=”&B3)
Step 4>
We will include the cell reference for which we are constructing a QR Code in the syntax along the link in the following pattern after writing the above link for importing the QR Code.
Step 5>
Upon finishing the syntax for generating a QR code in Google Sheets, simply hit the Enter key to obtain the output displayed below.
In this way, you can use the image feature of the above-specified website to create a QR Code in Google Sheets for any product.
Create QR Code Using Add-on
Similar to how many features in Google Sheets can be accommodated by numerous third-party solutions, you can also produce QR codes in Google Sheets by utilizing an add-on.
Step 1>
Navigate to the “Extensions” tab in Google Sheets using the menu bar. Select “Add-ons” from the drop-down menu. Next, select “Get add-ons” from another popup menu, as indicated below.
Step 2>
After selecting “Get add-ons“, a new window displaying a variety of add-ons will appear. Look for the “QR Code Generator” add-on and add it to your sheet.
Step 3>
You will need to follow some important steps to install an add-on on your sheet. First, click the “Allow” box to provide them permission to access your account.
Step 4>
After the add-on has finished installing, select the “Open” option, as indicated in the following image, to open it from the Extension tab.
Step 5>
There will be an open pane option on the right side of the window that allows you to generate a QR code. The first thing you need to do is set the QR code’s size on this panel. I’ve chosen the medium size here.
Step 6>
The following step will be to select the format in which you wish to make the QR code after deciding on its size. I’ve chosen the “PNG” format in the example below to create a QR code.
Step 7>
Remember to choose the reference cell for which you are producing the QR code before clicking the “Generate” button in Google Sheets. You can click the “Generate” button once the cell has been selected.
The QR code generator generates a QR code and stores it in Google Drive. You must use the following methods to get the file from Google Drive to insert it into Google Sheets.
Step 8>
To start, point the cursor where in Google Sheets you want to make a QR code for the product.
Step 9>
Navigate to the “Insert” tab in the menu bar. When you click on the “Image” option, a drop-down menu will appear. Choose the option that you want, whether you want to put the image inside a cell or over it.
Note: Since we generated the QR code in PNG format, I’m inserting an image here to insert it; if you generated the code in PDF format, you’ll need assistance from Docs to insert it in Google Sheets.
Step 10>
The window that follows will show up when you click the option to insert an image. Since the QR code creator saves its files to Google Drive, I will choose “Google Drive” and locate my QR file there as instructed below.
Step 11>
As you choose the image and press the “Insert” button, your QR code will be entered into the cell, as seen in the result in the image that follows.
You may also like>>> How To Make Categories In Google Sheets [Easy Guide]
Frequently Asked Questions
How can I adjust the QR code size in Google Sheets?
You may have to change the size of the QR code based on the assignment or data that you are trying to find. You can adjust the size of a QR code in Google Sheets by following these steps if you have made one and it is larger or smaller.
Step 1>
Assume the following scenario: I’ve added a QR code to Google Sheets, as shown in the photo. We want to change the code’s size. Let’s explore what we can do.
Step 2>
As you can see, the QR code size is indicated by the Chs=300×300 in the syntax. It is possible to adjust its size by adjusting these parameters. As demonstrated in the example below, I’m creating a 150 x 150 QR code.
Step 3>
The QR code has been resized to 150 by 150 pixels. Similarly, you can change the QR code’s size in Google Sheets.
How do I download a QR code in Google Sheets?
After creating a QR code in Google, you may want to save it to share it on the market or for any other reason. The procedures to download a QR code in Google Sheets are listed below.
Step 1>
If you used a QR code generator to make your code, it needs to be kept in Google Drive so that you can download it to Google Sheets with ease.
Step 2>
To begin with, locate and pick the QR code you wish to download. Next, click the three dots icon. A little drop-down menu will appear with the option to “Download” on it. To download the QR Code in Google Sheets, select this option.
Conclusion
Learning how to create QR codes in Google Sheets will improve data management and speed up procedures. With the help of this tutorial, you will be able to create personalized QR codes in Google Sheets with ease, which is a convenient and effective way to handle chores like inventory management, audience interaction, and information sharing.
