- 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 11, 10, 8, 7, Windows Server 2008, Windows Vista, Windows XP, etc
- 100% compatible with Microsoft Office Excel 365, 2021, 2019, 2016 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.
How to generate QR Code barcodes on Excel
Users can refer to the following steps to generate QR Code barcode images in Microsoft Excel documents.
- Open a new Excel spreadsheet, move to "Add-Ins" tab, and click "Insert Barcode".
- Choose a cell, select "QRCode" barcode symbology, and input valid data.
- Customize the property values and click "Insert" button to get required QR Code image.
- Users can make adjustments for the added barcode,
and then click "Update".
How to create multiple/bulk QR Codes in Microsoft Excel file without vba, font, macro?
It is easy to use the following steps to create QR Code barcode list in Excel.
- Switch to "Add-Ins" tab to activate "KA.Barcode for Excel" setting panel.
- Select a list of cells, choose "QRCode", and enter or input valid data.
- Or select a list of cells with required data, and choose "QRCode" barcode type.
- Then click "Insert" to generate the QR Code barcode image list in Excel.
How to create QR Code barcode using Excel Cell data?
Link QR Code barcode images to cell in Microsoft Excel documents with the following steps.
- Choose the generated QR Code barcode image or create a new barcode image.
- Click "Link Barcode to Cell" and select a cell with required data.
- Then click "Update Barcode". And now the QR Code barcode image is linked to the cell.
- It is allowed to link multiple barcodes to cells using the same method.
- Revise the data in linked cells, just click "Update".
Encoding QR Code character sets in Excel
- numeric data (digits 0 - 9)
- alphanumeric data (digits 0 - 9; upper case letters A -Z; nine other characters: space, $ % * + - . / : )
- byte data (default: ISO/IEC 8859-1)
- Kanji characters
Encode GS1 data in QR Code in Microsoft Excel
To create GS1 compatible QR Code barcodes, you need follow the steps:
- In tab "2D Barcode", check property "FNC1"
- 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:
- Check property "Apply Tilde Function"
- 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:
- Check property "Auto Resize"
- 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.