Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)
HTML-код
- Опубликовано: 4 июл 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 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!
It gives me goosebumps when I hear "for free" and "Google" in the same sentence.
The absolute best words to hear! LOL
😅😂
😂
😂
😂😂 i swear
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.
THIS. WAS. PERFECT!!!
For an artist who knows no coding, this tutorial made it soooooo easy!!!
Thank you!
You're very welcome!
Nice, simple video for easy understanding. You even added the link which was GREAT! Thanks much! 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. 😃
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!
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!
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! :)
This is such an amazing guide going forward!!
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.
Your Video changes my view about excel and now i love excel.. because of your channel...
This is awesome, every time I learnt new things from you. Thank you Leila
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.
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!
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!
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!!
Hello. Leila, I love your style of teaching the steps. 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.
Love the intro music you used on this video!!! 🔥🔥🔥🔥🔥 Content was super helpful as always!!
Appreciate it!
One of my favourite videos I’ve ever watched on RUclips. Full marks. Fan for life.
you are absolutely the best, i have been trying to do this for the last 2 hours and you just saved me
Wonderful help! I just added a QR code to a flyer for work within 5 minutes of clicking on this video.
your the best leila!!! i always watched your videos and i always do learn anything with you.
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!
Absolutely wonderful! Thank you for sharing.
Very useful. Thanks Leila (Excel needs to catch up on a few Sheet functions)
That's true 😊
Hi Leila. Nice tips for creating QR codes. Will come in handy. Thanks for sharing :)) Thumbs up!!
Many thanks Wayne.
Отличный прием для ускорения работы. Спасибо!
You're still the best. Thanks for your production.
Thank you too!
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
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?)
Wow this is so great. I truly appreciate. Truly helpful. Very easy to follow. Concise and clear. Thank you so much. God bless you!
These videos are excellent! Thank you!
Glad you think so!
This is a treasure find! Thank you Leila! What code would allow a custom color of the QR code image?
I feel like a rock star now that I know this!
Honestly your content rocks! Thank you so much!!!!!!!!!!!
I am your fan, Leila! Thank you!
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 the information. You are a life saver. I appreciate you for teaching us these skills.
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?
Thank you so much...This was a quick solution for our event.
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
Learned someting new today. Thanks a lot ~
My pleasure!
WOW!!! Liked and subbed for the no nonsense solution! What a relief!
Glad to have you aboard!
This is brilliant! Thank you so much for sharing :D
Thank you so much! You have truly made my day. This information is immeasurable. I can not thank you enough!
EXCELLENT, THANK YOU VERY MUCH LEILA
Much appreciated Leila! Thank you!!
You're so welcome!
thank you. I do inspections and have wanted to link with photos.
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'...
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 for sharing this! A big help!
Leila!!! Girl you’re the one!!!!❤️ blessings
Thanks for another great video Leila. is there a way to add an image/logo to the QR code, please?
Please tell me too
My mind is officially blown 🤯! Thank you so much!! This is so cool!
Glad you like it!
Cool, thanks for the tutorial, you are great!
Nice video and it was so helpful. Thanks
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 for this guide!
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!!!
Excellent video. Appreciate the top quality and clear delivery.
Thank you so much, that was a great tutorial!
Very useful, good. Thanks Leila.
You're very welcome Luciano!
So helpful :) Thanks a million
learned so much already at even just halfway through!
just amazing! you saved me time and money. I thank you a lot
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.
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 used this to help my mom promote her business. Thank you so much.
You are the best Leila!
Hi great job, thanks. can you please tell how to remove green triangle without removing formula
Tyvm can't wait to give this a try.
Great info. Leila, What about micro QR ones?
Very good explained to create the QR-Code.
After I had finished the QR-Code, I tryied it to copy in my Excel-Shet with Ctrl C and Ctrl V and have very big problems.
Can yo tell me, what I make wrong or how I have to make it to do?
As always ...amazing. Thank Leila
Glad you like it!
This was so helpful. Thank you so much.
Now that' s really cool! 😊👍
Thank you! Cheers!
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..
Thank you so much for sharing this. Is there a limit on the number of scans per month?
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.
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 ☺
Sorry, no QuickBooks course 😁
Great video and free resources. Thank you for your help and your succinct instructions.
You're very welcome!
GREAT INFORMATION SIR VERY VERY THANKS
Tq Leila. i love all your vids
Thank you very much!
Quite Simple and Awesome. Could you please help how to do the same in Excel. I sense there is no easy replacement for the Google Sheets Image Function in Excel. Please help
Thank you for sharing your document!! That made it so easy!
Happy to help, Sarah :)
Thank you! what if you want QR code that goes to a landing page, with multiple links on it?
Thanks, this was so useful.
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.
I am wondering this also. Is there a limit on how many times our custom QR code can be scanned? Thanks in advance.
Thank you ! You are amazing !
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)
This's cool ... thanks Leila
Many thanks for sharing!
I can't believe how easy that was thanks a lot boss. 😎👍