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:

=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:

google-drive-qr-code

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

Also read: How to Scan QR Codes From an Image on Mobile

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Damien Oh Avatar

Read next

Suzanne Simard sealed paper birch and Douglas fir seedlings inside plastic bags, fed them carbon-14 and carbon-13 dioxide, and nine days later found carbon had crossed between species through fungal threads in the British Columbia soil beneath her boots
A species of jellyfish called Turritopsis dohrnii can revert its adult cells back to a juvenile polyp stage when injured or starving, effectively restarting its life cycle, and biologists have so far failed to identify any natural limit to how many times it can do this.
A Japanese man named Jiroemon Kimura, who lived to 116, was born in 1897 when Queen Victoria still ruled and died in 2013, meaning a single human life personally overlapped with the invention of the airplane, the atomic bomb, the internet, and Instagram
The Hollywood sign originally read HOLLYWOODLAND when it was built in 1923 as a real estate advertisement for a housing development, and it was only meant to stand for 18 months, but nobody ever got around to taking it down and the city eventually adopted it as a landmark
Almost all of the world’s internet traffic does not travel by satellite but through fibre-optic cables lying on the ocean floor, a hidden web of wires crossing the deepest parts of the sea to connect the continents.
People who flip their phone face down on every table aren’t being secretive. They figured out that staying interruptible meant handing their time to whoever rang first
Twitch vs. Facebook Gaming vs. YouTube Gaming: What’s the Best Live Game Streaming Platform?
Chrome Extensions Ownership Transfer is a Direct Threat to You: How to Stay Safe