HomeHow ToHow to Generate QR Codes with Google Sheets

How to Generate QR Codes with Google Sheets



QR Codes are widely used these days. With just a simple set of codes, you can have access to different information without going through the manual process of searching. This is useful if you want to share data like addresses, authentications, payments, or URLs.

Many businesses are integrating the use of QR codes to make it easier for their customers to connect with them. QR codes stand for Quick Response Codes, which offers, as the name implies, quick responses to information or online locations that you need. It is similar to a barcode but is made up of white spaces and black dots.

Now, you can generate and make your own QR codes using Google Sheets. With a simple formula, it is quick and easy to generate several QR codes in less time.

How do you Create QR Codes in Google Sheets

Image / Windows Dispatch

To get started, you will need to take note of this Google Sheets formula:


This is the formula you need to add on your Google Sheets to create the QR Code. You can change the cell location between the two & signs. In the example above, the cell location is A1.

  • Now, to start making QR Codes, launch your Google Sheets.
  • Click Create a new spreadsheet.
  • You can use two columns: first is for the URL that will lead to the information you want to redirect your users. The second column is for the QR Code.
  • Add the URL first and on its QR Code cell, copy and paste the formula. Make sure to change the cell location.
  • Do the same to each of the URLs that you want to generate a QR Code. Always change the cell location.
  • If you have many URLs to generate QR Code, click the formula cell and drag the blue box until you reach the end of your list.

That’s it! Now, you can easily create as many QR Codes as you want using Google Sheets. What do you think of the method above? Share your thoughts with us by dropping a comment below.


More From

How to Restrict Editing and Protect Parts of a Word Document

If you are planning to send a Word document to someone but are worried that your work will be edited, you can protect it...

Use Netflix Search Codes to Find Hidden Movies and TV Shows

Sometimes, you might think that Netflix has a crappy recommendation system. If you don't do some extra steps in finding the tons of movies...

How to Create, Use and Manage Tags in Microsoft Teams

It is easier to collaborate with your workmates thanks to Microsoft Teams. You can share files, hold video meetings, or create group chats to...

Top 7 Strategies to Grow Your Graphic Design Business

Graphic design has never been more popular than it is right now. But with this popularity comes stiff competition. Winning clients and claiming a...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected