QR Code Generator Tool in Excel

QR Code Generator Tool

Hi Friends, today we are going to learn something which is more closure to many businesses. As the businesses going global and digital, there is a need to adopt the new way of tagging. Yes, we are talking about QR Code and Barcodes. These codes have made the life simpler for many people.

In this article, we will learn how to generate QR codes right from your Excel file.

What is QR Code?

QR stands for Quick Response. These codes are considered as cell phone friendly. You may find these codes printed for displayed at many places such as payment stores, web pages, books, mobile apps etc.

The reason for these codes to be more useful is because of its capabilities. QR can store much more data as compare to Barcodes such as site URLs, text messages, numbers, geo coordinates etc.

Can I Generate QR Codes in Excel File?

Yes, it is possible to generate QR Codes using Excel. Since it is bit complex; hence we have taken simpler approach for explanation. We are making use of Web API provided by https://api.qrserver.com to generate the QR code.

QR Code Generator Tool

How to use this tool?

Step 1: Download the tool copy from below link

Download QR Code Generator Tool

Step 2: Open the tool an you will see below screen

QR Code Generator Tool

Note: Since this file includes Macros; hence you need to enable macros if Excel prompt you to enable it. See below a sample screenshot of Excel warning message. You need to click on Enable Content

QR Code Generator Tool

Step 3: Click on ‘Clear Data’ button

QR Code Generator Tool

Step 4: In column A (Content/Text/URL etc.), enter the content you want in the QR code. This can be your site address, any text, alphanumeric number etc.

QR Code Generator Tool

Note: This copy of tool can generate up to 10 QR Codes at a time

Step 5: In column B (Font Color), change the cell color in which you want the QR code

QR Code Generator Tool

Step 6: In column C (Back Color), change the cell color in which you want QR code back color

QR Code Generator Tool

Step 7: Click on ‘Generate QR Code’

QR Code Generator Tool

Step 8: Tool will now send text, font and back color details to https://api.qrserver.com and paste the QR code provided from the site in column D (QR Code)

QR Code Generator Tool

Note: Since the tool is getting the QR code from the site; hence please ensure that you are connected to internet before using the tool. Also, you must have access to https://api.qrserver.com. Sometimes due to slow site response or internet issues, you may receive few error messages. Just click on OK and try again.

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply

Your email address will not be published. Required fields are marked *