Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)

This video is perfect for anyone looking to create single or bulk QR codes without any cost. We use a simple yet powerful Google Sheets function to generate QR codes, making it an ideal solution for personal or professional use. Plus, Google Sheets is accessible to anyone with a Google account, adding to its convenience.

🔑 Key Steps Explained:
▪️ How to set up a new Google Sheet for QR code generation.
▪️ Using the IMAGE function in Google Sheets combined with a URL GET request to create QR codes.
▪️ Adjusting the size and error correction level of the QR codes.
▪️ Creating dynamic QR codes linked to cell references for bulk generation.
▪️ Copying and pasting the generated QR codes into other applications like PowerPoint and Word.

If you're interested to find out how the QR function works in Google Sheets continue watching the video. I'll explain how it's setup. This way you can create your bulk QR codes with different settings and resolutions whenever you want.

00:00 How to Create QR Codes for free
01:39 How to Open a New Google Sheet
02:12 Syntax for Google Sheets IMAGE Function to Create QR Codes
05:17 Create Bulk QR Codes in Google Sheets

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

[LeilaGharani]

Please note, Google no longer supports copying and pasting QR codes directly into other applications. Instead, you can use a screenshot tool, such as the Windows Snipping Tool, to capture the QR code and paste it into your documents.

[lovemylife]

Thank you from the bottom of my heart! I'm a single mom with a special needs child trying so hard to create a stay at home business with my skills before he graduates in a year. This was hands down the BEST tip I have had all year and so clear. You have saved me huge amounts of work and headache! - simplifying my business. I did subscribe and can't wait to see the rest of your videos! THANK YOU SO SO SO MUCH!

[rohann]

Videos like these is what makes YouTube what it is and even better....

The manner in which Prof. Leila has so lucidly shared her knowledge with us is truly selfless and rewarding...

🙏

[Econotrix]

After watching your tutorial I was able to generate and print QR codes of video lessons on the flex boards, which have been put on the walls of classroom. Thanks a lot .🙏🙏

[krn]

I always thumbs up before video plays when it’s Leila. Thanks for the great video.

[Allthingsfortnite]

Nice, simple video for easy understanding. You even added the link which was GREAT! Thanks much! Leila.

[gfjsnshjfi]

It gives me goosebumps when I hear "for free" and "Google" in the same sentence.

[savantank]

Your Video changes my view about excel and now i love excel.. because of your channel...

[juliosoares]

Thank you so much!! The process of copying and pasting didn't work (as the pinned comment stated) but I just resized the cell and took a screenshot, it worked perfectly.
Saved my life!

[tech_obsessed]

If you could see how happy I am right now because of this video.... Thank you so much for all that you do to keep us educated and well informed. 😃

[swamibaal]

Thank you for in depth tutorial on generating QR codes. I like the dynamic part of it.

[edwardowen]

You are a spreadsheet goddess! I thought I was going to have to pay hundreds of dollars to get all the QR codes I needed for a game tournament. Now I can create them at Will. You have a new subscriber for life.

[sethlee]

I came here to learn about QR codes but I think you just taught me about my new favorite shortcut. Never new Windows + V was a thing!

[glamboframps]

This has been extremely helpful for making a QR code for my bands FB page. Definitely worth a subscribe, I can’t thank you enough.

[matambaavhatakali]

you are absolutely the best, i have been trying to do this for the last 2 hours and you just saved me

[chefrex]

This is awesome, every time I learnt new things from you. Thank you Leila

[Tarakothari]

THIS. WAS. PERFECT!!!
For an artist who knows no coding, this tutorial made it easy!!!
Thank you!

[nasihshamil]

i consider you my teacher. you are very professional, easy to understand, generous with links in description
i have one question i want to use it for labeling my products
so when i print my qr cods in bulk i would like each qr code to have some descriptions above it or bellow, please help ?

thank you in advance

[ifiknewthen]

This is such an amazing guide going forward!!

[centaurea]

Very good and useful explanation demystifying what at first glance would appear to be "for tech-savvy" people. Thank you.