How to Create a QR Code in Excel for Every Need (FREE File)

How to make QR codes in bulk for a website, PDF, etc. in Excel using formulas.
👩‍🏫 Simplify your work in Excel with my Advanced Formulas: bit.ly/advformulas0130
➡️ DOWNLOAD the free example file here: bit.ly/qrcodesfile
In Excel, we can create QR codes in bulk for free for use in any application using a formula. Unlike Google Sheets, you can simply copy the image and paste it where you need it. QR codes can be used to open URLs, store mobile tickets, contactless payments, even obituaries on headstones, to name a few. Because they are simply a graphical representation of alphanumeric strings, they don't expire.
Now, there are a couple of ways you can create QR codes in Excel. We'll start with the IMAGE function technique, which is available with Microsoft 365, and then I'll show you an alternative way which allows you to create colored QR codes and works in all versions of Excel. At the end, I''m going to answer some frequently asked questions, so stay tuned.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 Why to make QR codes in Excel
0:46 First way of making QR codes
2:37 Second way of making QR codes
5:14 If you want to simplify your work
5:24 Third way of making QR codes
6:50 Create colored QR codes
7:29 The question many users ask
7:48 One thing you need to know when using the first way
8:08 Which option is the best (personal opinion)
#QRCode #Excel #ExcelTutorial

[@MyOnlineTrainingHub]

❓Which one of these 3 ways do you find the easiest to work with? Simplify your work in Excel with my Advanced Formulas: bit.ly/advformulas0130

[@ianwebster2296]

Mynda, I just saw a KZbin short on this very subject and it was on my list for today to investigate it. I arrived at work and your email was there waiting for me on the very same subject. As usual, you explained the subject matter much better and in much more depth. You answered FAQ questions and presented options that allow me to not only obtain the functionality of generating QR codes but increase my skillset in Excel at the same time. Thanks for yet another very informative video on a fun subject. --Ian

[@MyOnlineTrainingHub]

That’s awesome to hear, Ian 😊 glad it was helpful 🙏

[@ServusLibertate]

Fantastic, out of the box thinking at its best!

[@MyOnlineTrainingHub]

Thank you 😊

[@chrism9037]

Super awesome, thanks Mynda!

[@MyOnlineTrainingHub]

Thank you for the support! It means a lot!

[@normundserglis1795]

Cool!!! Till that, I have used the third way with different add-on, but now my favorite will be the first way. Thanks!

[@MyOnlineTrainingHub]

Thank you for the comment 😊

[@xezebo]

Amazing! Much thanks 🥳

[@MyOnlineTrainingHub]

Thank you for the comment and for watching!

[@ivanbork4175]

Dear Mynda It's great that you keep finding new and very useful topics to bring up, thank you so much

[@MyOnlineTrainingHub]

Thank you for your kind words! Do you have any ideas/requests to share for the upcoming videos? 😃

[@ivanbork4175]

That a bit like asking a Sunday league player to give ideas to a Premier League player 🙂 One thing that I need to get deeper into is Lambda, but Excel can do so many things, and in different ways. personally, I really enjoy when you introduce new functions that can otherwise be easily overlooked, but perhaps to accommodate new users it is a good idea with examples of more basic functions.

[@sowjanyas3846]

@MyOnlineTrainingHub is it possible to make tutorial to generate qr code with nice label designer 10 software mam?

[@IamTheReaper911]

Wow! This was just awesome. Thanks for the video 😊

[@MyOnlineTrainingHub]

Thank you for your kind feedback, I really appreciate it 😊

[@DavidVsOficial]

Excelente vídeo, muchas gracias

[@MyOnlineTrainingHub]

Gracias!

[@VVeiQuek]

You can also generate QR for your home/company wifi, so that you can share wifi with guests without revealing the password each time and only those who drops by can access it.

[@MyOnlineTrainingHub]

Fantastic idea! 😃👏

[@FEBear1]

great to see you back after the hack

[@MyOnlineTrainingHub]

Thank you for the support! 🙏

[@erdal4687]

Perfect

[@MyOnlineTrainingHub]

Thank you!

[@mikrom]

Looks so easy in your case, but what if it has to work on the shopfloor machine with Office 2013 and no access to the internet? I've been there. Tried to generate the image via the VBA, but I couldn't make it work. So I found some PHP library and created my own api on the internal server. As it was already XLSM file, I am just downloading the picture and placing it to the range in VBA. 😎

[@MyOnlineTrainingHub]

Yes, not as easy without a connection to the internet. Glad you found a workaround.

[@yassirkhalid5376]

Great Video as usual! I prefer to do it with Lambda, but since the maximum size is 375, is it possible to make the size as an optional parameter with a default size of 150? So in case the user didn't enter any value it will be by default 150 and if entered more than 375, such as 400, the function takes 375.

[@MyOnlineTrainingHub]

Thanks 😊 yes, you could modify the lambda to allow for a default size value if the user omits it.

[@yassirkhalid5376]

@@MyOnlineTrainingHub Glad to hear this, but still looking forward for a video on these tricks!! This will open a wide door for many improvements to my existing lambda functions.

[@jdalco]

Do I need to creat the lamda function in every workbook or is there a way to access it across different workbooks?

[@MyOnlineTrainingHub]

You can either save the LAMBDA in your default workbook, or simply copy the formula from the example file into the file you want to use it in.

[@razvanafloarei6256]

Should I have a specific formatting in the QR code cell?

[@MyOnlineTrainingHub]

No, no formatting required.

[@CG-em4kg]

Hi Mynda, great work! how do I retrieve a qr code from a qrcode string in excel?

[@MyOnlineTrainingHub]

Not sure what you mean by a 'qrcode string in Excel'?

[@ireyel]

Mynda, you've been a great help thank you for doing this. A bit off topic, I was watching your videos yesterday then suddenly it becomes unavailable saying channel is private. When going to your home page I was redirected to Vitalik Buterin's channel. Checking in this morning and now your channel says Ethereum?

[@MyOnlineTrainingHub]

Thanks for your support. Our channel was hacked yesterday, and I've finally restored it, including the channel name.

[@TheUmaiz]

Excellent,👍 How we can create the same with shape inside the QR code?

[@MyOnlineTrainingHub]

Not sure what you mean by 'with shape'.

[@TheUmaiz]

@@MyOnlineTrainingHub Custom design QR code

[@rosemarygrundy3539]

Hi Mynda I had the same question. I currently use QRCode Generator which requires a hefty annual fee, but it does allow me to put our LOGO in the centre of the QR Codes. I think thats what Umaiz was talking about. Do you think that’s possible?

[@geisamendes5887]

👏👏👏👏

[@MyOnlineTrainingHub]

Glad it was helpful 😁🙏

[@Noura.sa19]

Could the QR background be transparent in Excel ?

[@MyOnlineTrainingHub]

Do you mean if it is possible to save a QR code as a PNG file with a transparent background?

[@Noura.sa19]

@@MyOnlineTrainingHub yes

[@petercrowther5575]

Hi there. Can you create a QR code that will open a Document> Pdf, word etc.

[@MyOnlineTrainingHub]

Yes, if that document is stored in a web enabled URL e.g. saved on OneDrive or a web server.

[@jerrydellasala7643]

I've found that if I have a LAMBDA function in an open worksheet, copying a cell with that LAMBDA formula in it, and then pasting that CELL/FORMULA in another (new) Workbook will copy the LAMBDA function to the new Workbook. No need to copy the Worksheet.

[@MyOnlineTrainingHub]

Thanks for sharing 👍

[@sowjanyas3846]

How can i create multiple column data into 1 qr code ? Example i would like to keep colum a and b data together in one qr code? It would be great if u help

[@MyOnlineTrainingHub]

You could concatenate the text first e.g. =A1&B1

[@sowjanyas3846]

@MyOnlineTrainingHub thank you for reply. I would like to ask one more question if I combine A&B in one column...if I give code it's creating qr code for each row but I would like only 1 QR code for all row data is there any possibility mam? It could be helpful if I get help

[@MyOnlineTrainingHub]

QR codes are alternate ways to access a URL, so I'm a bit confused about what you're trying to generate a QR code for. Don't reply here as I won't see it. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@dorislo8671]

can this function on excel 2016？

[@MyOnlineTrainingHub]

The add-in might be able to, but the IMAGE function is only available to Microsoft 365 users.

[@yametekudasai676]

can i use this in google sheet?

[@MyOnlineTrainingHub]

I expect so, yes.

[@4braKadabra]

What about logo inside the QR code? Do you know a way to create QR codes eith logo inside in bulk ?

[@MyOnlineTrainingHub]

Good question, I don't know of any free ways to do this. Bit.ly allow you to with their paid service.

[@esrAsnataS]

This is excellent but sadly add-ins are locked at our company.

[@MyOnlineTrainingHub]

You can create a QR code in Excel without add-ins.

[@user-pf4we6vc4c]

Just tried this first method but it says blocked! any advice would be great!

[@MyOnlineTrainingHub]

This bottom of this page explains possible causes of the #BLOCKED! error: support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5

[@user-pf4we6vc4c]

@@MyOnlineTrainingHub Thank you! I managed to sort that message. Sorry another question, is there a way to take the information from more than 1 cell to generate the QR code? Say I wanted the QR code to bring up a name and an email? Sorry I'm not very good with excel.

[@vedmuchandikar-xu6jd]

Can I create QR code like this and provide service to clients who want qr code for their website?

[@MyOnlineTrainingHub]

Probably, but I’m not sure if there are licensing restrictions about using these tools and charging for them. You’d have to look at their terms and conditions.

[@vedmuchandikar-xu6jd]

@@MyOnlineTrainingHub Thank you so much.

[@ahawk850]

Hello, I have been trying the Google URL, but I get the error : #VALUE! Also, there is a message on the Google website that says: "Warning: This API is deprecated. Please use the actively maintained Google Charts API instead." What can help this error? Thanks - AH

[@MyOnlineTrainingHub]

Sounds like you don't have a version of Excel that has the IMAGE function. I address the API deprecation in the video. It has been deprecated for many years, but it still works, so I don't expect it will stop working anytime soon.

[@malakamir8491]

the first method is not working for me. the qr codes generates but when i come to use my camera to scan it, the link is not popping up

[@MyOnlineTrainingHub]

Did you try making the QR code bigger? Have you tested the link you've fed into the formula actually works?

[@walidmaamar]

The image function don't work for me, any tips ?

[@MyOnlineTrainingHub]

Use the add-in instead.

[@alisami5434]

hi, i'm doing it exactly like you did, but i'm getting the #Name? error please advice, thank you

[@MyOnlineTrainingHub]

I suspect you don't have the IMAGE function in your version of Excel.

[@alisami5434]

@@MyOnlineTrainingHub if my version of excel is missing the image function! Is it possible to add it?

[@MyOnlineTrainingHub]

Only by upgrading Excel. You cannot purchase new functions and put them in old versions of Excel.

[@mikes4177]

How do I make a QR code for text

[@MyOnlineTrainingHub]

Use the Add-in and choose 'Custom' from the drop down.

[@F5Yourself]

Excel add error failed to load

[@MyOnlineTrainingHub]

Sorry to hear that. Hopefully you can still use the API method.

[@Noura.sa19]

Also, Is it free?

[@MyOnlineTrainingHub]

100% free