3 Free QR Generator tools for Excel

0 Comments
Editor Ratings:
User Ratings:




Today we will be discussing about 3 Free QR Code generators for Microsoft Excel. These Generators gather info from a single cell (or even from multiple cells in case you are doing bulk generation) from the Excel Sheet and encode them into QR Codes which are then placed in the sheet itself. In a previous article we discussed 5 QR code generator for Google Sheets, you can check out that article here.

Let’s look at these free QR code generators for Microsoft Excel below:

1. QR4Office

This is Excel Add-in available from the Office Store. Click on ‘Insert’  and then click on ‘Add-ins  to search and install it from the store. Once installed, it appears in the ‘My Add-ins’ list in Office Add-ins and can be executed from there.

The type of Information to be encoded like URL, Email id, SMS message, Tel number etc. can be selected from the drop down. Specify the foreground and background colors of the QR Code, its size and error correction values. The QR code will be automatically generated in real time in the ‘Preview’ window. You can insert it into the sheet at the desired location by clicking on ‘Insert’ or Copy-Paste the QR Image in any cell that you desire.

Overall this is a good tool to Generate and Insert QR Codes in an Excel Spreadsheet. The Insert function doesn’t at times in which case you can Copy-Paste the QR Image in the sheet.

QR4Office

2. Generate QR Code using Free Excel Spreadsheet

This is a pre-built Excel Worksheet that you can download and customize to generate QR Codes for any information value that you desire. It contains a User Defined Function in VBA and uses Google Chart API to generate the QR Code.

Just type the information values to be encoded, in the cells A1 to A6. Next click on the drop down in Cell A10 and select the specific value for which you wish to generate a QR Code. In just a matter of seconds the value that you selected in the drop down will be converted to a QR Code using the Google Chart API.

Summarily, this is a good readymade worksheet to generate QR Codes in Excel. In order to increase the number of information values in the drop down, you need to understand and edit the VBA code.

Click here to download this Excel worksheet.

Excel Sheet with Google Chart API

3. Generate QR Code using Free Excel Spreadsheet

Like the previous Generator this too is a ready-made Excel Worksheet that you can download and use to encode QR Codes for any information value that you wish.

Just type the information value to be encoded, in the cell A1. In just a few seconds, the QR Code will be seamlessly generated and displayed on the Excel spreadsheet in real time.

Every time you need to generate a new QR Code, you will have to change the information in the cell A1 with the new value and the QR Code will be updated dynamically.

All in all, this is an fair QR Code Generator for Excel with an inbuilt function to generate QR Codes in real time. It lacks any customizations of color or size of the QR image.

Click here to download this Excel worksheet.

Single QR Code Generator

If you need data values and their QR codes in one doc then QR Code Generators for Microsoft Excel does a great job.

You can try out all the mentioned QR Code Generators and then choose the one which best suits your needs.

Editor Ratings:
User Ratings:
Free/Paid: Free

Get 100 GB FREE

Provide details to get this offer