BizCode Barcode Add-In for Microsoft Excel
The most professional and unique barcode solution for Microsoft Excel
Quick Overviews
  • Mature barcode plug-in
  • No Programming Skills
  • MS-Excel 2007/2010
  • Linear & 2D barcode support
  • Barcodes Freely Adjustable
How to Encode Data into QR Code Using Excel Add-In
QR Code Excel Add-in is a professional, user-friendly QR Code barcode plug-in for MS Office Excel used world-wide with flexible royalty-free purchased Developer License. It provides an easy way to install and insert high-quality QR Code barcodes in Microsoft Excel Workbook 2007 and 2010 with a few mouse clicks.
With this Excel QR Code Generator Add-in, Standard QR Code barcodes can be directly generated from the latest QR Code barcode specifications and QR Code barcode image properties can be easily configured in Excel, such as QR Code image margins, image width, and image height. Here are detailed samples for modify QR Code data in Excel. Others, please link to:
Data Related Properties

Symbology

Barcode Generator for Microsoft Excel gives full power to users to determine that which data type they want to encode into QR Code barcode with Barcode Type option.

Excel QR Code Barcode Add-in encodes:
  • Numeric data: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
  • Alphanumeric data
  • Byte value (ISO/IEC 8859-1)
  • Kanji characters

Data Mode

Barcode Generator for Microsoft Excel gives full power to users to determine that which data mode to be used for encode QR Code valid character sets with different data mode.

6 QR Code data modes:
  • Auto: encodes all 256 possible 8-bit byte values
  • Alphanumeric: encodes uppercase and lower case letters Aa-Zz
  • Byte: encodes 8-bit values according to ISO/IEC 8859-1
  • Numeric: encodes 10 Arabic digits 0-9
  • KanjI: encodes Kanji characters
  • Customer: encodes data according to the customer

Code

Barcode Generator for Microsoft Excel gives full power to users to control QR Code barcode data length with Data option.

ProcessTilde

Barcode Generator for Microsoft Excel gives full power to users to decide that whether to encode special ASCII characters or GS1 Application Identifiers for QR Code using a tilde character "~" with Apply Tilde option.
  • 1-byte character: ~0dd/~1dd/~2dd (character value from 000 ~ 255); ASCII character '~' is presented by ~126
    Strings from "~256" to "~299" are unused
  • 2-byte character (Unicode): ~6ddddd (character value from 00000 ~ 65535)
    Strings from "~665536" to "~699999" are unused
  • for GS1 AI Code:
  • ECI: ~7dddddd (valid value of dddddd from 000000 to 999999)
  • SJIS: from ~9ddddd (Shift JIS 0x8140 ~ 0x9FFC and 0xE040 ~ 0xEBBF)

Error Correction Levels

Barcode Generator for Microsoft Excel gives full power to users to determine which Reed Solomon error correction level (L, M, H, Q) to be used in QR Code barcode for withstanding different damage Error Correction Level option.
Customize QR Code Barcode Data in Excel
Ensure you have installed those following programs before you start to encrypt your QR Code valid character sets in Excel Workbook:
Encode QR Code Barcode Data in Excel
  1. Create a new Excel Document and activate Barcode Add-In for Microsoft Excel;
  2. Go to "Barcode Setting Panel" and choose "Barcode Type" to "QR Code";
  3. Input some data - "QR Code" in "Data";
  4. Click "Generate"; then a QR Code barcode occurs in your Excel Workbook.
Encode QR Code Barcode with Different Data Mode in Excel
  1. Select the existed QR Code in Excel;
  2. Go to "2D Barcode" and select "Data Mode" to "Byte";
  3. Input some data - "+-&*" in "Data";
  4. Click "Update"; then a QR Code barcode occurs in your Excel Workbook.
Encode QR Code Barcode with "~" in Excel
  1. Select the existed QR Code in Excel;
  2. Go to "1D Barcode" and activate "Apply Tilde";
  3. Input some data - "~ai2456QR Code" in "Data";
  4. Click "Update"; then a QR Code barcode occurs in your Excel Workbook.
Encode QR Code Barcode with Different ECL in Excel
  1. Select the existed QR Code in Excel;
  2. Go to "2D Barcode" and select "Error Correction Level" to "L";
  3. Click "Update"; then a QR Code barcode occurs in your Excel Workbook.