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

Wi-Fi doesn’t actually slow down when a café gets crowded — the signal is fine, but every device has to wait its turn to speak on the same frequency, and the polite queuing is what you feel as lag
In 1988, a 23-year-old Cornell graduate student named Robert Morris released a self-replicating program to measure the size of the internet — within hours it had crashed roughly 6,000 of the 60,000 machines then online, and computer security became a field
In July 2026, Psy’s Gangnam Style passed six billion YouTube views, fourteen years after its horse-riding dance became the platform’s first billion-view video and long after engineers had replaced a counter designed to stop at 2,147,483,647
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.