Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)
Вставка
- Опубліковано 26 лип 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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-qrco...
🔑 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/i...
Windows tips & tricks video: • Uncover Windows 10 Mos...
Create QR code in Excel with a free add-in - watch the video: • 6 FREE Add-Ins for Exc...
Google Sheets Playlist: • Google Sheets Tips, Tr...
Link to full article: www.xelplus.com/create-qr-codes
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ 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: / 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!
The Google Chart API featured in our video has since been deprecated. To address this, we've integrated a similar alternative QR code generation service into our QR code generator. Grab an updated copy of the QR code generator here: 👉 pages.xelplus.com/sheets-qrcode-file
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.
It's amazing. Thank for the video. I took the screenshot.
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.
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?
Screen shot worked for me as well!! Thanks a bunch!
@@anthonyvelasco786 Consider manually resizing the cell (max is 500).
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!
Videos like these is what makes UA-cam 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...
🙏
Wow! Thank you!
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 .🙏🙏
I always thumbs up before video plays when it’s Leila. Thanks for the great video.
Nice, simple video for easy understanding. You even added the link which was GREAT! Thanks much! Leila.
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.
Very good and useful explanation demystifying what at first glance would appear to be "for tech-savvy" people. Thank you.
This is such an amazing guide going forward!!
This is awesome, every time I learnt new things from you. Thank you Leila
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. 😃
This was freaking awesome! I so appreciate your wealth of knowledge!!
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.
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.
Glad it was helpful!
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.
THIS. WAS. PERFECT!!!
For an artist who knows no coding, this tutorial made it soooooo easy!!!
Thank you!
You're very welcome!
Been loving the tutorials on google sheets. This is awesome to know. Thanks Leila :)
Glad you like them!
Google sheets keeps improving , i use them for all my home use.
@@markfrombriz same! :)
Hello. Leila, I love your style of teaching the steps. Thank you.
It gives me goosebumps when I hear "for free" and "Google" in the same sentence.
The absolute best words to hear! LOL
😅😂
😂
😂
😂😂 i swear
Your Video changes my view about excel and now i love excel.. because of your channel...
Thank you for in depth tutorial on generating QR codes. I like the dynamic part of it.
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!
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!
Love the intro music you used on this video!!! 🔥🔥🔥🔥🔥 Content was super helpful as always!!
Appreciate it!
you are absolutely the best, i have been trying to do this for the last 2 hours and you just saved me
Absolutely wonderful! Thank you for sharing.
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!
This is brilliant! Thank you so much for sharing :D
Wow this is so great. I truly appreciate. Truly helpful. Very easy to follow. Concise and clear. Thank you so much. God bless you!
Thank you for the information. You are a life saver. I appreciate you for teaching us these skills.
One of my favourite videos I’ve ever watched on UA-cam. Full marks. Fan for life.
Wonderful help! I just added a QR code to a flyer for work within 5 minutes of clicking on this video.
I am your fan, Leila! Thank you!
Hi Leila. Nice tips for creating QR codes. Will come in handy. Thanks for sharing :)) Thumbs up!!
Many thanks Wayne.
your the best leila!!! i always watched your videos and i always do learn anything with you.
Thank you so much, that was a great tutorial!
Looking for this one from a long time and now got the idea how to generate QR code. Thanks a lot. 🙏
Glad it was helpful!
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?)
Отличный прием для ускорения работы. Спасибо!
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
These videos are excellent! Thank you!
Glad you think so!
Thank you so much! You have truly made my day. This information is immeasurable. I can not thank you enough!
I feel like a rock star now that I know this!
Honestly your content rocks! Thank you so much!!!!!!!!!!!
Very useful. Thanks Leila (Excel needs to catch up on a few Sheet functions)
That's true 😊
You're still the best. Thanks for your production.
Thank you too!
Much appreciated Leila! Thank you!!
You're so welcome!
EXCELLENT, THANK YOU VERY MUCH LEILA
Thank for sharing this! A big help!
learned so much already at even just halfway through!
Learned someting new today. Thanks a lot ~
My pleasure!
Nice video and it was so helpful. Thanks
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!
Happy to help!
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.
So helpful :) Thanks a million
Cool, thanks for the tutorial, you are great!
Thank you so much...This was a quick solution for our event.
WOW!!! Liked and subbed for the no nonsense solution! What a relief!
Glad to have you aboard!
Thank you for this guide!
As always ...amazing. Thank Leila
Glad you like it!
Excellent video. Appreciate the top quality and clear delivery.
My mind is officially blown 🤯! Thank you so much!! This is so cool!
Glad you like it!
Great video and free resources. Thank you for your help and your succinct instructions.
You're very welcome!
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.
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!!!
You are the best Leila!
just amazing! you saved me time and money. I thank you a lot
Very useful, good. Thanks Leila.
You're very welcome Luciano!
Leila!!! Girl you’re the one!!!!❤️ blessings
Thanks, this was so useful.
I can't believe how easy that was thanks a lot boss. 😎👍
Now that' s really cool! 😊👍
Thank you! Cheers!
This was so helpful. Thank you so much.
This's cool ... thanks Leila
Many thanks for sharing!
Tyvm can't wait to give this a try.
Thank you soo much for this amazing tutorials
Thank you for sharing your document!! That made it so easy!
Happy to help, Sarah :)
This is a treasure find! Thank you Leila! What code would allow a custom color of the QR code image?
Amazing! Thank you!
I used this to help my mom promote her business. Thank you so much.
Tq Leila. i love all your vids
Thank you so much Leila! You are great!
thank you. I do inspections and have wanted to link with photos.
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?
GREAT INFORMATION SIR VERY VERY THANKS
Thanks again for all your videos save my day:) Have an awesome day and aloha...
Really helpful! Appreciated for your teaching!
100% satisfied ❤️
Amaaaazing! Thanks, Leila!
Wooow!
It's save me a lot of money.
Thanks Leila!!!
You're welcome 😊
excellent....your every video is very effective....really awesome....
Thank you very much!
Thank you ! You are amazing !
Perfect.....This worked just like you shared
Absolutely amazing video instruction on how to create QR code. I successfully did one for my Amazon store. Thank you so much.
Glad it helped!
I figured it out. I missed adding " at the very beginning after the first parenthesis. lol Thanks. I've never coded anything in my life Once I figured that out it worked perfectly.
Your videos are very informative and useful. Thank you very much for sharing this with us.
My pleasure!
@@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.
Ohh how much I learn with you. Thanks!
Absolutely fantastic - thank you so much!!!
Thanks, great vidéo. Short and to thé point.