Being able to create QR codes directly in Google Sheets is very useful and the process is easy. Quick response (QR) code becomes a popular way to quickly share information via mobile devices. Whether for professional or personal use, the ability to generate a QR code is still a useful feature. This blog post provides the necessary information to create QR codes in Google Sheets spreadsheet with ease.
Create QR Codes via Google Graphics API
Google provides a link to the Chart API that you can use with the IMAGE function in Google Sheets to create QR codes. Once you have the link, you’ll see how easy it is to work with the formula. You can use the formula to create QR codes that link to websites, phone calls, or text messages.
The formula looks like this:
=IMAGE(“https://chart.googleapis.com/chart?chs=150×150&cht=qr&chl=” & NEED QR-CODE)
Let’s break down the information in the formula and explain the options.
https://chart.googleapis.com/chart?: This is the site link to access the Google Charts API.
chs=300×300: This is the size of the QR code in pixels as width and height. To adjust the size, change the value to another number.
cht=qr: This specifies that the type is a QR code.
chl=”&NEED-QR-CODE: This is the data to encode or whatever cell reference you want to encode.
Open Google spreadsheetsso Create a new spreadsheet document or open google sheets spreadsheet in which you want to create the QR codes.
Create two columns, one for your links and one for your QR codes.
Select the cell where you want to add the QR code.
Locate the function area, type =IMAGE(“https://chart.googleapis.com/chart?chs=150×150&cht=qr&chl=” & NEED-QR-CODE)
Replace NEED-QR-CODE with the address in which you would like to generate the QR code (Example: A2)
Click anywhere on your Google Sheets spreadsheet to display your QR code.
To generate QR codes for the rest of the Google Sheets spreadsheet, simply drag the first cell down.
Video to show how to make a qr code for a google sheet
Another easy way to create QR codes in Google Sheets is by using an extension
Instead of the formula, you can install an extension from the Google Workspace Marketplace. There are plenty of extensions that can get the job done, but the one we’ll be using in this tutorial is QR Code Marker.
open your Google Chrome Web navigator.
Go to the Google website, then Log in with your credentials.
In it Google Workspace Marketplaceguy QR code creatorpress search, then click on the first result.
Follow the instructions on the screen to install the extension.
When you have the extension installed in your browser, open Google Sheets and create a new spreadsheet or open the spreadsheet in which you want to create the QR codes.
Select the data you want to convert to a QR code. This could be any text message, website URL, email address, phone number, or other.
Go to the extension menu, then select Generate QR code.
In conclusion, Google Sheets offers an easy-to-use method of creating QR codes that can be used for a variety of purposes. By following the steps provided in this blog post, you can quickly and efficiently generate QR codes that contain specific information, such as web addresses or phone numbers. This simple process can help you share information with others quickly and efficiently.
What to read next
If you like the content of this publication or if it has been useful to you, consider sharing it on your social networks and follow me on Facebook and Twitter for more exclusive content.