KA.Barcode for Excel
How to Convert Data into Data Matrix Barcode in MS Excel
How to generate and create Data Matrix images using Barcode Generator for Excel

Excel Data Matrix barcode generator add-in freeware: how to make, create data matrix 2d barcode in Excel. no font, free download



  • Create high-quality Data Matrix 2D barcode images in Microsoft Excel
  • Other barcode solutions provided - barcode .NET, Word barcode, Java barcode, etc.
  • Easy to integrate into Microsoft Office Excel 2007 version
  • Encode valid ASCII characters into Data Matrix barcode for Excel spreadsheets
  • Support encoding numeric, upper-case and lower-case letters for Data Matrix generation
  • Print and draw Data Matrix images in Excel documents
  • Java barcode, barcode .NET WinForms, barcode Excel, .NET barcode & barcode ASP.NET provided
  • Compatible with GS1 specification to create scannable barcodes for all printers
KA.Barcode for Excel is an easy-to-use barcode plug-in for simple Data Matrix generation in Microsoft Excel 2007 spreadsheets. With this detailed guide on Data Matrix data encoding, you can generate, create Data Matrix images in Excel in no time.
Data Matrix Information
Data Matrix (aka, DataMatrix, Data Matrix ECC200) is a 2D matrix barcode consisted of black and white "cells" or modules arranged in either a square or rectangular pattern.

Data Matrix Valid Data:

  • Extended ASCII: values 128-255 (in accordance with ISO 8859-1)

Data Matrix Valid Length:

  • Data Matrix barcode has a variable-length.
Data Matrix Data Encoding in Microsoft Excel

Install Data Matrix Barcode Add-In for Excel

  1. 1.
    Download KA.Barcode for Excel and unzip.
  2. 2.
    Click KeepAutomation.Barcode.Excel.2007.Addin.msi to install.
  3. 3.
    Open an Excel document and click "install" in the pop-up "Microsoft Office Customization Installer" window
  4. 4.
    Now you will see KA.Barcode Add-In in the Excel menu bar add-in tab.
  5. 5.
    Switch to KA.Barcode Add-In tab, click the button, and a property panel appears on the right side.

Data Matrix ASCII Data Mode

ASCII data mode for Data Matrix support encoding double digit numerics, ASCII values 0-127, Extended ASCII values 128-255, which include numeric digits, upper-case letters, lower-case letters, and special characters.
  1. 1.
    In the barcode type pull down menu, select DATAMATRIX.
  2. 2.
    Select data mode "ASCII" in the Data Mode pull-down menu.
  3. 3.
    Input ASCII data, for example, "DMtest123", into textbox.
  4. 4.
    Adjust other settings like size if necessary.
  5. 5.
    Click Generate button and a Data Matrix image is successfully created.

Data Matrix C40 Data Mode

C40 Data Mode for Data Matrix allows you to encode upper-case alphanumeric data.
  1. 1.
    In the barcode type pull down menu, select DATAMATRIX.
  2. 2.
    In the Data Mode pull-down menu please select data mode "C40"
  3. 3.
    Input proper data, for example, "DATA40", into textbox.
  4. 4.
    Adjust other settings like size if necessary.
  5. 5.
    Click Generate button and a Data Matrix image is successfully created.

Text Data Mode for Data Matrix

Text Data Mode for Data Matrix allows you to encode lower-case alphanumeric data, i.e. a-z, and 0-9.
  1. 1.
    In the barcode type pull down menu, select DATAMATRIX.
  2. 2.
    In the barcode type pull down menu, select DATAMATRIX.
  3. 3.
    Input proper data, for example, "DATA40", into textbox.
  4. 4.
    Adjust other settings like size if necessary.
  5. 5.
    Click Generate button and a Data Matrix image is successfully created.

EDIFACT Data Mode for Data Matrix

To encode alphanumeric data in Data Matrix, you can choose EDIFACT Data Mode, which allows you to encode ASCII values 32-94, so you can input 0-9, A-Z and many punctuation marks.
  1. 1.
    In the barcode type pull down menu, select DATAMATRIX.
  2. 2.
    Select EDIFACT in the data mode menu for Data Matrix.
  3. 3.
    Input proper data, for example, "ECC200", into textbox.
  4. 4.
    Click Generate button sand a Data Matrix image is successfully created.

Click Generate button sand a Data Matrix image is successfully created.

If you select Base 256 Data Mode for Data Matrix, then you can encode ASCII values 32-94, which include 0-9, A-Z and many punctuation marks. This data mode also supports all byte values 0-255.
  1. 1.
    In the barcode type pull down menu, select DATAMATRIX.
  2. 2.
    Select EDIFACT in the data mode menu for Data Matrix.
  3. 3.
    Input proper data, for example, "DM200", into textbox.
  4. 4.
    Click Generate button sand a Data Matrix image is successfully created.
If you are not sure which data mode to choose, you can always select Auto mode, with which KA.Barcode for Excel can automatically apply proper data mode according to your encoding data type for maximum data density.