Excel QR Code Generator Add in free download
How to create, generate QR Code barcode in Excel without using font, vba, macro

How to generate, display, print QR Code barcode in Excel without using font. Free download.

  • Advanced and reliable Excel barcode addin for QR Code barcodes
  • Latest QR Code ISO/IEC 18004 specifications pre-configured to ensure barcode validity
  • Support operating systems Windows 7, Windows Server 2008, Windows Vista, Windows XP, etc
  • 100% compatible with Microsoft Office Excel 2007 & 2010 versions to generate QR Code barcode
  • Dynamically encode and generate QR Code images in Microsoft Excel spreadsheets
  • Print out professional QR Code images in Excel file for almost all printers
  • Create Code 128 in Excel, PDF417 in Excel, Data Matrix in Excel are also included in the barcode excel add in package.
  • Provide royalty-free KA.Barcode for Excel user licenses for users permanently
QR Code Introduction
QR Code is a kind of 2D (two-dimensional) symbology developed by Denso Wave (a division of Denso Corporation at the time) and released in 1994 with the primary aim of being a symbol that is easily interpreted by scanner equipment. It is also known as Denso Barcode, QRCode, Quick Response Code, JIS X 0510, ISO/IEC18004.

QR Code is capable of handling all types of data, such as numeric and alphabetic characters, Kanji, Kana, Hiragana, symbols, binary, and control codes.
Download QR Code Barcode Addin for Excel
Download and unzip the free trial version of QR Code Barcode Addin for Excel and you will find the following contents in it.
  • KeepAutomationExcel2007Addin.exe
  • KeepAutomationExcel2010Addin.exe
  • End user license agreement, installation tutorial and order page
We should inform you that this free trial version can be used permanently only for non-commercial applications because QR Code barcode image generated with this trial version will include a "KA Barcode" watermark randomly.
How to Install KA.Barcode for Excel
Users can refer to the following steps to install this Excel barcode addin to create QR Code barcode images in Excel documents.
  1. Be certain that all Microsoft Excel spreadsheets are closed.
  2. Download and unzip KA.Barcode for Excel free trial version.
  3. Double click "KeepAutomationExcel2007Addin.exe" or "KeepAutomationExcel2010Addin.exe".
  4. Open a new Excel and click "Install" in the pop-up window.
  5. Now you can insert multiple QR Code barcode images in your Excel document.
How to Generate QR Code Barcode on Excel
Users can refer to the following steps to generate QR Code barcode images in Microsoft Excel documents.
  1. Open a new Excel spreadsheet, move to "Add-Ins" tab, and click "Insert Barcode".
  2. Choose a cell, select "QRCode" barcode symbology, and input valid data.
  3. Customize the property values and click "Insert" button to get required QR Code image.
  4. Users can make adjustments for the added barcode, and then click "Update".
How to Create QR Code List for MS Excel
It is easy to use the following steps to create QR Code barcode list in Excel.
  1. Switch to "Add-Ins" tab to activate "KA.Barcode for Excel" setting panel.
  2. Select a list of cells, choose "QRCode", and enter or input valid data.
  3. Or select a list of cells with required data, and choose "QRCode" barcode type.
  4. Then click "Insert" to generate the QR Code barcode image list in Excel.
How to Link QR Code Barcode to Cell
Link QR Code barcode images to cell in Microsoft Excel documents with the following steps.
  1. Choose the generated QR Code barcode image or create a new barcode image.
  2. Click "Link Barcode to Cell" and select a cell with required data.
  3. Then click "Update Barcode". And now the QR Code barcode image is linked to the cell.
  4. It is allowed to link multiple barcodes to cells using the same method.
  5. Revise the data in linked cells, just click "Update".

Encoding character sets in QR Code
  1. numeric data (digits 0 - 9)

  2. alphanumeric data (digits 0 - 9; upper case letters A -Z; nine other characters: space, $ % * + - . / : )

  3. byte data (default: ISO/IEC 8859-1)

  4. Kanji characters

Encode GS1 data in QR Code in Microsoft Excel
To create GS1 compatible QR Code barcodes, you need follow the steps:
  1. In tab "2D Barcode", check property "FNC1"
  2. In barcode "Data" property, for each AI elements, around AI code with "()", and followed by AI data, such as "(02)225(03)33344". Here "02", "03" are the AI code, "225", "33344" is the AI data.

Encode Non-printable chars in QR Code in Microsoft Excel
To encode non-printable chars (such as '[GS]'), follow the steps:
  1. Check property "Apply Tilde Function"
  2. Use 3-digts '~ddd' for non-printable chars. For example, ASCII char [GS] is non-printable, and its decimal value is 29. In barcode data, you need use ~029 for char [GS].

QR Code image width and height setting in Office Excel sheet
If you need to create a barcode with specified image width, height, and with maximum barcode module (X and Y), please do the following steps:
  1. Check property "Auto Resize"
  2. Set values of property "Barcode Width", "Barcode Height"

Or you can resize the barcode image by drag and drop the corners of the image. After resize the image, you need click button "Update" or "Update All Linked Barcodes" to re-draw the barcode image.

Note: After drag and drop the barcode image, you need click the image again, then you click the button "Update" to update the barcode image width and height.

Check property "Auto Resize", you will get the maximum of bar width.

User Guide

Data Matrix for Excel PDF417 for Excel QR Code for Excel more Codabar for Excel Code 39 for Excel Code 128 for Excel EAN-8 for Excel EAN-13 for Excel EAN 128 for Excel Intelligent Mail for Excel Interleaved 2 of 5 for Excel ISBN for Excel ITF-14 for Excel RM4SCC for Excel UPC-A for Excel UPC-E for Excel more
KeepAutomation provides complete barcode automation solutions. We recommend the customers use high quality document controls: ASP.NET Document Viewer, ASP.NET MVC Document Viewer, Document Viewer ASP.NET C#, ASP.NET PDF Viewer, ASP.NET Word Viewer, ASP.NET Excel Viewer, ASP.NET PDF Editor, MVC PDF Viewer, ASP.NET Annotate PDF, c# pdf sdk, C# View, edit PDF online , C# Convert PDF to Tiff, C# Convert PDF to text, txt, .net imaging sdk, C# PDF metadata edit from RasterEdge.com.