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

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
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.
⬇️ Get your own copy of the Google Sheet QR code generator: pages.xelplus.com/sheets-qrcode-file
🔑 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
Google Developers QR code link: developers.google.com/chart/infographics/docs/qr_codes
Windows tips & tricks video: kzbin.info/www/bejne/mqCTZ4CGjMtse5Y
Create QR code in Excel with a free add-in - watch the video: kzbin.info/www/bejne/pImqga1nermtjas
Google Sheets Playlist: kzbin.info/aero/PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu
Link to full article: www.xelplus.com/create-qr-codes
➡️ Join this channel to get access to perks: kzbin.info/door/JtUOos_MwJa_Ewii-R3cJAjoin
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: lgharani
LinkedIn: www.linkedin.com/company/xelplus
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]

Grab a copy of the file I used in the video from here 👉 pages.xelplus.com/sheets-qrcode-file Copying and pasting QR codes directly into Word or PowerPoint as demonstrated in the video is now disabled. To work around this, use the snipping tool or similar apps to take a screenshot of the QR code, then paste it into Word or PowerPoint. Feel free to share other methods in the comments.

[@limitless5591]

It's amazing. Thank for the video. I took the screenshot.

[@InsideMyWall]

I want to use QR code for check in/out and record it in a spreadsheet to keep a track of my inventory. Please make a video if possible. Would be great if we can use approval/deny options.

[@anthonyvelasco786]

when I change the chs value, say for example 1000x1000, it doesn't seem to respond and the QR code image disappears. what could be wrong here?

[@Victorinony]

Screen shot worked for me as well!! Thanks a bunch!

[@kennethwilliams8917]

@@anthonyvelasco786 Consider manually resizing the cell (max is 500).

[@rohann9260]

Videos like these is what makes KZbin 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... 🙏

[@LeilaGharani]

Wow! Thank you!

[@lovemylife816]

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!

[@gfjsnshjfi]

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

[@MissNelly86]

The absolute best words to hear! LOL

[@rohit989079]

😅😂

[@kudzaitafadzwamoyo2453]

😂

[@vipinezn]

😂

[@hanifkaisi]

😂😂 i swear

[@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 .🙏🙏

[@ifiknewthen13]

This is such an amazing guide going forward!!

[@centaurea21]

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

[@krn14242]

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

[@Tarakothari]

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

[@LeilaGharani]

You're very welcome!

[@christinaq5805]

This was freaking awesome! I so appreciate your wealth of knowledge!!

[@chefrex2900]

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

[@stressreliefmeditation8078]

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

[@swamibaal]

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

[@guystapleton6130]

I am giving a presentation later this year and this has been a game changer, being able to link resources to my website. Well explained and well illustrated. Many thanks.

[@LeilaGharani]

Glad it was helpful!

[@TylerStanczak]

Been loving the tutorials on google sheets. This is awesome to know. Thanks Leila :)

[@LeilaGharani]

Glad you like them!

[@markfrombriz]

Google sheets keeps improving , i use them for all my home use.

[@TylerStanczak]

@@markfrombriz same! :)

[@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. 😃

[@excel2722]

Hello. Leila, I love your style of teaching the steps. Thank you.

[@savantank1560]

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

[@mrs.csonlineartroom8373]

Absolutely wonderful! Thank you for sharing.

[@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.

[@nasihshamil6655]

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

[@chrisfurnessmusic4519]

This is brilliant! Thank you so much for sharing :D

[@YoutubeBrand]

Thank you for the information. You are a life saver. I appreciate you for teaching us these skills.

[@greggowaffles]

Love the intro music you used on this video!!! 🔥🔥🔥🔥🔥 Content was super helpful as always!!

[@LeilaGharani]

Appreciate it!

[@tiroyneidaniels2092]

leaving a review since I had time to read the other positive reviews. This will help my business make millions. I claim that now in Jesus name. Thanks Leila for sharing!

[@edwardowen8668]

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.

[@ebiznizstore16]

Wow this is so great. I truly appreciate. Truly helpful. Very easy to follow. Concise and clear. Thank you so much. God bless you!

[@sethlee09]

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!

[@nancymena6717]

Hello Leila, just found your channel, thank you for the easy tutorial! Would we be able to see statistics on these? like how many times ppl use it?

[@matambaavhatakali4833]

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

[@dantoinelevert8892]

Thank you so much!!!! Your explanation was very simple yet helpful!!! It was straight forward and these are the types of tutorials I like. By the way, are these QR code good for the long run (meaning, literally for lifetime?)

[@juliosoares4880]

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!

[@heppylifestyle]

another excellent vid. i'll do this method for my inventory of ??300 different edible plants! great job Leila. you earned the success -- ur channel has blown up.

[@BabelRedeemed]

Wonderful help! I just added a QR code to a flyer for work within 5 minutes of clicking on this video.

[@danschaefer6038]

Thank you so much, that was a great tutorial!

[@FlowerEconomics]

Much appreciated Leila! Thank you!!

[@LeilaGharani]

You're so welcome!

[@angeljones9096]

Thank you so much! You have truly made my day. This information is immeasurable. I can not thank you enough!

[@MrH1berto]

I am your fan, Leila! Thank you!

[@bkhudkhudia]

Looking for this one from a long time and now got the idea how to generate QR code. Thanks a lot. 🙏

[@LeilaGharani]

Glad it was helpful!

[@sufisufiyan5471]

100% satisfied ❤️

[@statanaliz]

Отличный прием для ускорения работы. Спасибо!

[@adedejiemmanuel1]

You're still the best. Thanks for your production.

[@LeilaGharani]

Thank you too!

[@wilclif]

These videos are excellent! Thank you!

[@LeilaGharani]

Glad you think so!

[@jumpshot6924]

your the best leila!!! i always watched your videos and i always do learn anything with you.

[@GrahamClarkson]

Thanks for another great video Leila. is there a way to add an image/logo to the QR code, please?

[@Hiteshhothhh]

Please tell me too

[@johanpeeters3671]

Hi, Leila, first of all thanks heaps for this very helpful and clear video. A couple months ago I've successfully used this QR code function in a Google Sheet but I've made a very stupid mistake. I'm afraid I have deleted the original file from my Google Drive (freeing up space, you know..) so the link in the QR code is no longer pointing to any file 😞 I do still have the PDF file on my computer so my question to you and all here is: is there any way of keeping the exact QR code (used on POS materials) and replace the doc link it's pointing to? Thanks in advance for any help or ideas you may have. Kind regards, Johan

[@rchaerkady]

Cool, thanks for the tutorial, you are great!

[@aci25v]

First, thank you for your time and for making this excellent tutorial. Is there any limitation on how many times the QR code can be scanned? I'm asking because a few months ago, I made a QR code in a place where it said it was "free" and then after several times the code had been scanned it stopped working.

[@happycamper5350]

I am wondering this also. Is there a limit on how many times our custom QR code can be scanned? Thanks in advance.

[@ikramzamri]

You are the best Leila!

[@wildernessworthy]

Watched 5 other videos on how to make “free” QR codes. But they’re all through random websites, really confusing, and I wasn’t convinced it was actually free. This is by far the best video I could find and is actually free!

[@LeilaGharani]

Happy to help!

[@wheatdevon]

thank you. I do inspections and have wanted to link with photos.

[@learningsimplified9025]

As always ...amazing. Thank Leila

[@LeilaGharani]

Glad you like it!

[@JoelHalcro]

One of my favourite videos I’ve ever watched on KZbin. Full marks. Fan for life.

[@Nimbin]

just amazing! you saved me time and money. I thank you a lot

[@jackievillamizar7206]

I really so thankful that you share with all of us your knowledge thank you for being such a great person you cannot imagine how you are helping me God Bless you!!!

[@paulhoyte5488]

Thanks for this video. Very educational and was able to get started on a new project. The only question I have is regarding spaces in a cell. The QR Code is not generating if there is a space in the data. Eg. if cell contains Paul,Hoyte,123456 it is good but if I enter Paul Hoyte,123456 then it fails. Infographics says it supports a space but it doesnt appear to be the case. I'm not creating a URL string but just a text string so that might something to do with it?

[@amir.granot]

Thank you for this guide!

[@Cholesterol725]

Thank for sharing this! A big help!

[@AtlasCho]

Learned someting new today. Thanks a lot ~

[@LeilaGharani]

My pleasure!

[@creationsbynore869]

Thank you for sharing this information. This can in handy for many things. Definitely a 5-star rating. Thank you for the update in the comments as well.

[@DiscClub6]

I feel like a rock star now that I know this! Honestly your content rocks! Thank you so much!!!!!!!!!!!

[@BradTefft]

This is a treasure find! Thank you Leila! What code would allow a custom color of the QR code image?

[@bleuetamoosejaw]

Tyvm can't wait to give this a try.

[@emporiodivela5012]

learned so much already at even just halfway through!

[@mattschoular8844]

Very useful. Thanks Leila (Excel needs to catch up on a few Sheet functions)

[@LeilaGharani]

That's true 😊

[@mdbelalhossain9975]

Thank you soo much for this amazing tutorials

[@marianvandenbussche1321]

Hi Leila, thank you for this tutorial! However, I have a question. How can I download this Google sheet onto my computer as an Excel? When I do it now, it gives an error in the data, where you said to put 'B3'...

[@fourthwallsatire]

Thank you so much...This was a quick solution for our event.

[@samirfathy4837]

So helpful :) Thanks a million

[@HusseinKorish]

This's cool ... thanks Leila

[@savizsafizadeh3532]

Many thanks for sharing!

[@sarahbellis13]

Thank you for sharing your document!! That made it so easy!

[@LeilaGharani]

Happy to help, Sarah :)

[@chofoguate]

I appreciate your content very much. It is very well presented and easy to understand, manage and follow up! In regards to the QR creation, I needed a better resolution to print the image on flyers. I unsuccessfully tried to increase the size of the QR by simply typing into the formula, instead of 500x5000, different sizes: 1000x1000 and 800x800. Is there a solution?

[@irvandi6734]

u can try to image trace it maybe in Adobe Illustrator?

[@drpriceteaches]

My mind is officially blown 🤯! Thank you so much!! This is so cool!

[@LeilaGharani]

Glad you like it!

[@ad-wk2sc]

Amaaaazing! Thanks, Leila!

[@shaiktalha1297]

Nice video and it was so helpful. Thanks

[@khalidelgazzar]

Thanks, great vidéo. Short and to thé point.

[@miatule]

Thank you so much for sharing this. Is there a limit on the number of scans per month?

[@LockeyPrice]

Great video and free resources. Thank you for your help and your succinct instructions.

[@LeilaGharani]

You're very welcome!

[@MsKlaSoulMusic]

Leila!!! Girl you’re the one!!!!❤️ blessings

[@garethvw1583]

Very helpful video with simple, clear instructions on how to set this. I was a click away from paying for a subscription. The only reason I didn't take the paid sub was because it said I would loose my QR codes when I stopped paying.

[@omardarwisch1178]

Good morning from Colombia. I first want to congratulate you on your channel and thank you for your generosity in sharing your skills. I have a question; Could QR codes be generated from a specific sheet of a Google Sheet?

[@LeilaGharani]

Thank you. They are generated with the formula. You can organize the Google sheet as you need and use the use the formula wherever you need.

[@user-db6ge4jo6y]

Your videos are very informative and useful. Thank you very much for sharing this with us.

[@LeilaGharani]

My pleasure!

[@mrmanthecat2099]

@@LeilaGharani THANKS, LEILA. Say, if I delete or lose the GOOGLESHEETS file, will I lose the active links? I need to know before I add codes to my product labels.

[@wayneedmondson1065]

Hi Leila. Nice tips for creating QR codes. Will come in handy. Thanks for sharing :)) Thumbs up!!

[@LeilaGharani]

Many thanks Wayne.

[@seatizen-rtb]

Great info. Leila, What about micro QR ones?

[@purpletyc]

OMG!!!!!🤯 This is....... I'm just amazed how you know all this and make it easy for us to understand. I would love to take a QuickBooks course with you. If you have any please let me know. Thank you ☺

[@LeilaGharani]

Sorry, no QuickBooks course 😁

[@tonithatcher]

Thank you so much Leila! You are great!

[@aminwahyudi]

Thank you for sharing.

[@cbn227]

Absolutely amazing video instruction on how to create QR code. I successfully did one for my Amazon store. Thank you so much.

[@LeilaGharani]

Glad it helped!

[@MyMovieShelf]

I can't believe how easy that was thanks a lot boss. 😎👍

[@franciscorafaelmendozavill5953]

Thanks, this was so useful.

[@thenaturalgemini]

This was so helpful. Thank you so much.

[@Mainu_5]

Hi great job, thanks. can you please tell how to remove green triangle without removing formula

[@vijayarjunwadkar]

Now that' s really cool! 😊👍

[@LeilaGharani]

Thank you! Cheers!

[@lieybethl1992]

Hi Leila, thanks for your great tutorial! I really need this. However, I found that the QR API has been deprecated. I wonder if I could generate the QR code via google sheets..

[@aakashparikh1788]

Hi, Thank you for this video. Can we do the same for a data column? or does it work only for URLs (for eg., need to connect the QR codes with the name and phone number of the employees)

[@thefrankfactorshow]

Excellent video. Appreciate the top quality and clear delivery.

[@daved5683]

Amazing! Thank you!

[@BigCFM]

Absolutely fantastic - thank you so much!!!

[@jlymghost]

Greatly appreciated!