Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)
HTML-код
- Опубликовано: 9 июн 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).
Videos like these is what makes RUclips 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!
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!
It gives me goosebumps when I hear "for free" and "Google" in the same sentence.
The absolute best words to hear! LOL
😅😂
😂
😂
😂😂 i swear
I always thumbs up before video plays when it’s Leila. Thanks for the great video.
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 .🙏🙏
Nice, simple video for easy understanding. You even added the link which was GREAT! Thanks much! Leila.
This is such an amazing guide going forward!!
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 awesome, every time I learnt new things from you. Thank you Leila
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! :)
Very good and useful explanation demystifying what at first glance would appear to be "for tech-savvy" people. Thank you.
Thank you for in depth tutorial on generating QR codes. I like the dynamic part of it.
This was freaking awesome! I so appreciate your wealth of knowledge!!
THIS. WAS. PERFECT!!!
For an artist who knows no coding, this tutorial made it soooooo easy!!!
Thank you!
You're very welcome!
Hello. Leila, I love your style of teaching the steps. Thank you.
Your Video changes my view about excel and now i love excel.. because of your channel...
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. 😃
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.
Love the intro music you used on this video!!! 🔥🔥🔥🔥🔥 Content was super helpful as always!!
Appreciate it!
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!
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.
Absolutely wonderful! Thank you for sharing.
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!
you are absolutely the best, i have been trying to do this for the last 2 hours and you just saved me
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!
One of my favourite videos I’ve ever watched on RUclips. Full marks. Fan for life.
I am your fan, Leila! Thank you!
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.
These videos are excellent! Thank you!
Glad you think so!
your the best leila!!! i always watched your videos and i always do learn anything with you.
EXCELLENT, THANK YOU VERY MUCH LEILA
You're still the best. Thanks for your production.
Thank you too!
Thank for sharing this! A big help!
Thank you for this guide!
Much appreciated Leila! Thank you!!
You're so welcome!
Wonderful help! I just added a QR code to a flyer for work within 5 minutes of clicking on this video.
This is brilliant! Thank you so much for sharing :D
So helpful :) Thanks a million
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 very much!
You are the best Leila!
Thank you so much...This was a quick solution for our event.
GREAT INFORMATION SIR VERY VERY THANKS
Cool, thanks for the tutorial, you are great!
Wow this is so great. I truly appreciate. Truly helpful. Very easy to follow. Concise and clear. Thank you so much. God bless you!
Very useful. Thanks Leila (Excel needs to catch up on a few Sheet functions)
That's true 😊
Learned someting new today. Thanks a lot ~
My pleasure!
Thank you ! You are amazing !
I feel like a rock star now that I know this!
Honestly your content rocks! Thank you so much!!!!!!!!!!!
Thank you for the information. You are a life saver. I appreciate you for teaching us these skills.
Many thanks for sharing!
Tyvm can't wait to give this a try.
Tq Leila. i love all your vids
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
Nice video and it was so helpful. Thanks
This's cool ... thanks Leila
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?
Amazing! Thank you!
As always ...amazing. Thank Leila
Glad you like it!
Thanks, this was so useful.
Leila!!! Girl you’re the one!!!!❤️ blessings
Thank you so much! You have truly made my day. This information is immeasurable. I can not thank you enough!
Hi Leila. Nice tips for creating QR codes. Will come in handy. Thanks for sharing :)) Thumbs up!!
Many thanks Wayne.
This was so helpful. Thank you so much.
This is a treasure find! Thank you Leila! What code would allow a custom color of the QR code image?
learned so much already at even just halfway through!
Very useful, good. Thanks Leila.
You're very welcome Luciano!
Thank you so much, that was a great tutorial!
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?)
Now that' s really cool! 😊👍
Thank you! Cheers!
WOW!!! Liked and subbed for the no nonsense solution! What a relief!
Glad to have you aboard!
Amaaaazing! Thanks, Leila!
just amazing! you saved me time and money. I thank you a lot
Thank you for sharing.
Thank youuu so much im so happy!!
Greatly appreciated!
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
Excellent, thanks
thanks for help miss
Excellent video. Appreciate the top quality and clear delivery.
Great content, 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!
My mind is officially blown 🤯! Thank you so much!! This is so cool!
Glad you like it!
thank you. I do inspections and have wanted to link with photos.
Thanks for another great video Leila. is there a way to add an image/logo to the QR code, please?
Please tell me too
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!!!
Thanks ليلى
I used this to help my mom promote her business. Thank you so much.
Ohh how much I learn with you. Thanks!
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?
Thank you so much Leila! You are great!
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!
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'...
excellent....your every video is very effective....really awesome....
Great video and free resources. Thank you for your help and your succinct instructions.
You're very welcome!
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.
Thank you Leila, super helpful!!
I can't believe how easy that was thanks a lot boss. 😎👍
wow talk about gems. this actually works thank you Leila for this information.