In this tutorial, we will see whether how we can create QR Codes in Google sheets.
Well, Here you can see that I have links of my profile from different platforms for which i want to create QR Codes and since we know that there is no direct function available in the google sheet to create QR Codes so far we can use “Image” function to create QR Codes
Instructional Tutorial:
So, before creating the “Image” function, go through this QR Code Page to read and understand whether how you can incorporate it into an image function and get your concerned QR Code.
Well, here is the Root URL that needs to be placed at the beginning while writing the image function, and the next argument specifies the QR Code, and the third argument is about the size of the image, and the last but not the least argument is where you add your concerned data to create your QR Code. And there are two optional arguments here too that specifies about the encoding and Error Correction and I will certainly put the link in the description so that you can read more about the QR Codes.
Now lets copy the Root URL and create image function and here you can see that we need put the link in quotation marks, so add Quotation mark and paste your Root link then, copy the next argument which will specifies about the QR code and paste it in the function after adding the & sign, then copy the third argument which is about image sizing and paste it in the function too after adding the & sign and change the Hight and width and let’s say, I keep it at 400 by 400, then copy the next argument and paste it into the function after adding the & and here you need to add your data for which you want to create your QR code, which is a URL link in my case.
And if there is no frequent need to create QR code, then just write your data here to hardcode it, otherwise, you can make it dynamic by writing the address of the cell where your data exist which is my profile links in my case, then just put the quotation and hit enter.
And here you can see, that the QR code has been created and then just drag the formula down to create bulk QR Codes.
Well, on the other hand, you can install add-ons to create QR Codes, just check if you already have an add-on that helps in creating QR Codes by selecting “Manage Add-ons” under Add-ons, and here you can see that I have no add-ons installed so far, so click on the “Get Add-ons” and search by writing “QR Codes”, It is showing many options and you can choose one of your choice to install which will help you generate QR codes.
Moreover, you can create QR Codes by using free online services, just search “Free QR codes generator online” and for the sake example, I am opening many online service providers to create QR Code and you can choose of your choice. Then just copy and paste your concerned data, which is a URL link in my case, to create QR Code.
Anyhow, This is how you can create QR Codes in Google Sheets
and I hope this will be helpful for someone out there and thanks for watching.
