QR Code, an abbreviation of Quick Response Code, is developed by Denso Wave. It is a two-dimensional barcode which provides a way to encode more information in a smaller space.
QR Code Add-In for Excel provides an easy & fast method for generating QR Code barcodes in MS-Excel, which is entirely compatible with the latest ISO Standards. This product requires no programming skills or barcode font; thus it is best suited for untrained users.
With QR Code Add-In for Excel, multiple QR Code barcode options are provided. For instance, flexible sizing options are provided to resize QR Code barcode and adjustable image options are provided to customize QR Code image according to users' needs. Here is a comprehensive user manual on QR Code barcode generation in MS-Excel. If you want know more, please go to
user manual for QR Code data encoding,
user manual for QR Code image setting, and
user manual for QR Code size setting.
QR Code Add-In for Excel Features
| Encodable Characters | Support to encode:
- Numeric characters
- Alphanumeric data
- Byte characters
- Kanji characters |
| Barcode Specification | Compatible with QR Code barcode specification in ISO; Also support to create GS1 compatible QR Code barcodes |
| MS-Excel Version | QR Code generation compatible with Microsoft Office Excel 2007 and Microsoft Office Excel 2010 |
| Image Customization | Provide selectable image options, such as image resolution in DPI, barcode rotations, bar alignment |
| Size Adjustments | Resize QR Code barcode via module size, barcode width & height, version, quiet margins of top, bottom, right and left, etc. |
| For all printers | Resolution customizable with DPI setting to print high-quality barcodes with all printers! No special printers or hardware are required |
QR Code Add-In for Excel Requirements
Windows OS & .NET Compatible with Microsoft Windows 7/XP/Vista, Windows Installer 3.1, VSTO 3.0 Runtime sp1, and .NET Framework 3.5 sp1. | Microsoft Office Compatible with Microsoft Office Excel Workbook 2007; Microsoft Office Excel Workbook 2010. |
Install QR Code Add-In for Excel
- Download BizCode Add-In for Microsoft Excel and unzip;
- Closed your Excel and Run the Setup file;
- Open your Office Excel, you will Excel barcode add-in has been installed successfully!
How to Generate QR Code Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "QR Code";
- Input some data - "QR Code" in "Data";
- Click "Generate"; then a QR Code barcode occurs in your Excel Workbook.
How to Generate GS1 Compatible QR Code Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "QR Code";
- Input some data - "QR Code" in "Data";
- Click "Generate"; then a QR Code barcode occurs in your Excel Workbook;
- Go to "2D Barcode" and activate "GS1 Compatible Barcode";
- Click "Update"; then a GS1 Compatible QR Code barcode occurs in your Excel Workbook.
How to Generate QR Code Barcode with Different ECL in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "QR Code";
- Input some data - "QR Code" in "Data";
- Click "Generate"; then a QR Code barcode occurs in your Excel Workbook;
- Go to "2D Barcode" and choose "Error Correction Level" to "L";
- Click "Update"; then a QR Code barcode occurs in your Excel Workbook.
How to Link cell with a QR Code Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "QR Code";
- Input some data - "QR Code" in "Data";
- Click "Generate"; then a QR Code barcode occurs in cell you choose;
- Click on a cell with data and click "Link to Cell";
- Click "Generate"; then a QR Code barcode occurs in cell you choose.
How to Generate Multiple QR Code Barcodes in Different Cells?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "QR Code";
- Input some data - "QR Code" in "Data";
- Click on a cell with data and click "Link to Cell";
- Click "Generate"; then a QR Code barcode occurs in cell you choose;
- Change the data in the cell you choose and click "Update Link to Cell";
- Click "Upgrade"; then a different QR Code barcode occurs.
How to Generate QR Code Barcode list in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "QR Code";
- Input some data in all the cells that you want to convert to barcodes;
- Select all the cells that you want to convert to barcodes and click "Link to Cell";
- Click "Generate"; then a list of QR Code barcodes occurs in cell you choose.
