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

Watch Star Trek: Picard First Episode Free on Youtube

CBS All Access, the streaming service by ViacomCBS just released Star Trek: Picard series. The episode one of this new flagship series is now...

How to Extract or Open .tar.gz, .tgz or .gz Files on Windows 10

In receiving files online, we can get various types of file formats. Some of these files have common extensions, while others have unfamiliar ones,...

How to Transfer or Change Ownership of File or Folder in Google Drive

Google Drive is a cloud-based storage that allows you to upload files from your local storage. It is helpful if you want to declutter...

How to Change or Reset Forgotten TikTok Account Password

TikTok became a phenomenal hit all over the world thanks to its unique yet addicting features. Users can create short and entertaining videos on...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected