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:
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A1)
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.
Damien Oh started writing tech articles since 2007 and has over 10 years of experience in the tech industry. He is proficient in Windows, Linux, Mac, Android and iOS, and worked as a part time WordPress Developer. He is currently the owner and Editor-in-Chief of Make Tech Easier.
6 comments
Comments are closed.
Nice, Damien – thanks !…
Henri
PS : Damien, can Google Drive spreadsheets also be used to read QR codes ?…
Henri
Not that I know of.
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?
Perhaps you can try replacing the spaces with %20 as that is the url
encoded format.
Yep, that worked! Thank you so much.