How to Create QR Code in Google Drive

We have shown you several ways to create QR code, and most of them require you to visit a website or download a software. For Google Documents (aka. Google Drive) user, here is a quick way you can create QR code.

1. Create a new Spreadsheet in Google Drive.

2. In Column A, enter the content that you want to embed in the QR code. It can be a URL, a word, sentence, or paragraph, a contact number.

3. In the respective cell in Column B, paste in the following forumla:

You can change the 150×150 value to set the QR code size. Also, change the “A1” value to the cell where it will grab the content to embed.

This is what you will see:


From here, you can take a screenshot of your desktop to save the QR code.


  1. Nice, Damien – thanks !…


  2. PS : Damien, can Google Drive spreadsheets also be used to read QR codes ?…


    1. Not that I know of.

  3. I have done this without too much of a problem, but have found that if I try to type a sentence with spaces (more than one word), the code disappears. Why is this, and how can I fix it?

    1. Perhaps you can try replacing the spaces with %20 as that is the url
      encoded format.

      1. Yep, that worked! Thank you so much.

Comments are closed.

Sponsored Stories