How to create a QR Code for selective data in MS Excel

This quick tutorial helps you create QR Code using selective data. This video also shows how an Add-in can be used in MS Excel for creating a QR Code.

[@mathtoma7885]

Thank you so much - It's really helpful.

[@nuramohamed6005]

Thank you.. You helped me a lot

[@SMJTech2020]

You are welcome!

[@SudarshanKarki-n4g]

When I scan your QR code, data appear on the google search bar. Is there a better way of presenting of the data?

[@tristramemerge]

Thank you for this. Do you know what add ins also cater both image and text in QR?

[@SMJTech2020]

Hi Thank you for your comment. There are quite a few add ins for text however, to incorporate image, you'll need to use an online tool as Excel doesn't embed the image inside of its cell therefore, it is not possible to pick it up. However, if you have used IMAGE function within Excel to have the logo inside of the cell, then you can use that selection to generate QR code.

[@tristramemerge]

@@SMJTech2020 i see thank you for the knowledge, planning to have my own personal ID for my students. The plan is scanning there ID and at the same time they can watch the preview to a monitor after scanning to verify attendance. I think this needs a software. 😅

[@raogaming3313]

If changes made in cell them can qr code generate automatically

[@SMJTech2020]

Yes

[@user-gc9oq6kk4p]

I want to create a barcode with info shown like company logo product info. Could you help me

[@SMJTech2020]

There's a barcode font which can be used however I'll have to check if there's a possibility of of including logos or any images since they are not usually embedded within a cell in Excel.

[@NoorFatima-lz2zk]

Nice

[@SMJTech2020]

Thanks

[@middleeasternmediterranean4477]

What if I have 100 employees? Shall I do it one by one? Can I do it as dragging?? Thanks

[@scanbocustomerdelightteami2914]

Please let me know how to attach the company logo with the QR code.

[@SMJTech2020]

Sure, I 'll try to cover in my upcoming video.