QR Code Generator Tool in Excel
How to Generate QR Code Tool in Excel?
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.
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 in Excel Steps:
Step 1: Download the tool copy from below link
Step 2: Open the tool an you will see below screen
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
Step 3: Click on ‘Clear Data’ button
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.
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
Step 6: In column C (Back Color), change the cell color in which you want QR code back color
Step 7: Click on ‘Generate QR Code’
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.