We’ll show you how to make QR codes step by step. But if you want to use QR codes right away without the hassle, just click the link at the end of this post.

By clicking the link, you’ll get a copy of the file. Then, just enter the URL you want, and a QR code will be made for you automatically.

After your QR code is ready, you can copy and paste it into any app you like.

Creating the QR Code from Scratch

NOTE: You will need to be logged in to your Google account for this to work properly.

Creating the Workbook

The first step in creating a QR code in Google Sheets is to open your favorite browser and type “sheets.new” (without the quotes) in the Location Bar.

This will start a new Google Sheets workbook and automatically save it in your Google Drive.

It would be a good idea to give the new workbook a better name.  Feel free to change the workbook name to something other than “Untitled spreadsheet”.

If you are unhappy with the save location of the file in your Google Drive, you can click the Move button to relocate the file to a better location.

The next step is to create a list of the link or links that you wish to generate QR codes from.

Google Sheets QR code generator

Writing the Formula for the QR Code Generator

Google Sheets does not possess a specific function to generate QR codes, but you can use the IMAGE function to call a URL that will generate the QR code.

The requirements for the IMAGE function’s URL are the link to the Google API along with the desired size and cell address that holds the Web link.

Information on the Google API can be found at the following address:

https://developers.google.com/chart/infographics/docs/qr_codes

(See what I did there?  😊 )

The requirements for generating the QR code are:

  • The root URL – https://chart.googleapis.com/chart?
  • The QR code request option – cht=qr
  • The image size defined as <width> x <height> – ex: chs=500×500
  • The URL for the image – chl=

You can also define the output encoding and error correction if needed.  See the online Google API documentation for details.

A generic version of an API call would look like the following.

https://chart.googleapis.com/chart?cht=qr&chs=500x500&chl=

In the below example, we are placing the URL to a website in a separate cell.

The IMAGE function is accepting the Google API link concatenated with a cell reference (B1) to create and retrieve the QR code and place it in a cell.

Notice how each of the QR code API elements is concatenated using the “&” character.

By enlarging the height of the rows, we get a clearer image of the QR code.

Create a qr code in Google Sheets

By dragging the formula down to adjacent rows, we can generate QR codes for all the desired links.

Bulk QR Code Generator: Create Multiple Codes

If you plan on using the QR API call using the IMAGE function in many locations throughout your document, consider placing the API URL in a dedicated cell.  This cell can be referenced by the IMAGE function.

When concatenated with the cell holding the website URL, it can make for a very short and easy to remember formula.

Bulk QR code generator in Google Sheets

If you name the cell holding the API URL, say to something like “QRCode”, your formulas can be even easier to remember and write.

Use Image function to create QR codes in Google Sheets

Using the QR Codes in Other Applications

Once the QR codes have been generated in Google Sheets, it’s a simple matter of using a snipping tool, press COPY, then switch to your favorite application and press PASTE.

QR code for link to XelPlus

Download the QR Code Generator

Grab your own copy of the file HERE.

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.