To create a QR code with Google Sheets is very simple, you just need to combine some functions in Google Sheets. So to create QR codes online, we have many different ways to do it. You can use online websites to create QR codes, or create QR codes on Google Docs or create QR codes with Google Sheets. We just need to paste the link into Google Sheets and then use the function. The article below will guide you to create QR codes using Google Sheets.
Instructions for creating Google Sheets QR codes using functions
Step 1:
First, paste the website link you want to create into a QR code in Google Sheets.
Step 2:
In the cell where you want to display the QR code for the entered link, we will enter the function formula =IMAGE(“https://chart.googleapis.com/chart?chs=500×500&cht=qr&chl=”&ENCODEURL(D48)) then press Enter.
In which D48 is the cell of the website link, 500×500 is the size of the QR code. This size can be varied as desired and is in square size.
Step 3:
As a result, we will see the QR code in Google Sheets as shown below. You adjust the size of the box to adjust the display size for the QR code.
Now we will scan this QR code with the camera on the phone. When receiving a QR code, the option to access the website embedded in the QR code will be displayed.


How to create QR codes in Google Sheets via utility
Step 1:
At the interface on Google Sheets, we click Add-ons sectionthen click next Download add-ons.
Step 2:
Display the utility search interface, us Enter the keyword QR Code Generator and then you will see the results below. We click on the QR Code Generator utility as shown below.
Step 3:
Next comes the user Click on Settings to install this utility on Google Sheets.
You need agree to certain access rights of this utility, click Allow to complete the installation of the QR Code Generator utility.
Step 4:
Return to the QR Code Generator interface, click Extensions section then click QR Code Generator utilitythen tap Open to open this utility.
Step 5:
Friend Click on the website link want to create a QR code, then look at the right edge to adjust the QR code creation mode on Google Sheets from the utility.
First us Choose to download the QR code as an image or as a document. If you click Save as Document, you will create a QR code in Google Docs. If you click Save as PNG, the QR code image will be saved to Google Drive.
Final Click Generate to generate QR codes.
Step 6:
As a result, you will see the option to open a Google Docs document to view the QR code or open a folder on your computer to view the QR code image.
Now you just need to send a photo of this QR code to others for them to scan and access.