2D Data Matrix Barcode Add-In for Microsoft Excel

Create, print Data Matrix barcode in Excel spreadsheet. Free download freeware. No Excel macro, formula, vba, barcode font.

Using Data Matrix Barcode Add-in for Excel to insert Data Matrix Barcode in Excel Spreadsheets

In this Excel Data Matrix user guide, you will learn how to generate, create 2d Data Matrix barcodes in Microsoft Office Excel files.

Support full ASCII, Unicode, byte array in Data Matrix data encoding in Microsoft Excel
Generate Data Matrix compatible with ISO/IEC 16022
Easy to customize Data Matrix barcode image dimensions
Create valid GS1 Data Matrix barcode images
Encode Data Matrix with international characters (Unicode text)
Support latest version of Office Excel on Windows. No font, native vba, macro required.

How to create Data Matrix 2d barcodes in Microsoft Excel document?

Download Data Matrix Generator Excel Add-in
Install Data Matrix Excel add-in to
create Data Matrix barcode images in Excel files
Step by Step Tutorial

ON THIS PAGE:

Overview
Video: How to Create Data Matrix in Excel?
Quick to Generate Data Matrix Barcodes in Excel
Data Matrix Basic Characteristics
Data Matrix Data Encoding
Data Matrix Property Settings

Be able to compatible with Microsoft Office Excel 2019, 2016, 2013, 2010 and 2007 versions
Excel Data Matrix Barcode Add-in used to create barcodes for Excel
Easy to install barcode add-in, without any barcode font, macro vba required
Free barcode addin software downloads. Complete demo source code included.
Data Matrix industry standards are well customized in the barcodes
Specifications of Data Matrix are not required for any users
Data Matrix Barcode Add-In for Excel requires NO barcode fonts
Easy and simple to generate article lists or catalogues as demands
Support high quality Data Matrix barcode images generation in MS Excel

A quick video tutorial for making, printing Data Matrix barcode in Excel

Top

Introduction of Excel 2D Data Matrix Generator Software

Top

Data Matrix Barcode Add-In for Excel is a mature and reliable barcode generator for Data Matrix generation in Excel. And all produced Data Matrix barcodes are customizable and well-designed to meet various application demands of users.

In addition to Data Matrix Barcode Excel Generator Add-In, Onbarcode.com also provides other mature and professional linear (1D) & 2D barcode Add-Ins for Excel as well as Word which can generate the following barcodes: Data Matrix, Code 128, EAN, UPC, GS1 128, Interleaved 2 of 5, Postal Codes, QR Code, Data Matrix, PDF-417, etc.

Install Data Matrix Barcode Add-In for Excel

Top

Download Excel Barcode Add-in and unzip it
Close all MS Office Excel spreadsheets.
Click the setup.exe to install.
Open a new Excel document to click "Install". Done!

Data Matrix Barcode Basic Characteristics

Data Matrix Encodable Characters

Data Matrix symbology supports full 128 ASCII characters and extened ASCII characters encoding.

ASCII values 0 - 127 in accordance with the US national version of ISO/IEC 646
Extended ASCII values 128 - 255 in accordance with ISO 8859-1
Other character sets (e.g. Arabic, Cyrillic, Greek, Hebrew) may be supported when using the Extended Channel Interpretation (ECI) protocol or byte mode

To help Excel Data Matrix generator users quickly create Data Matrix from various character sets, we have provided full detailed guide.

Data Matrix Data Mode

Data Matrix barcode supports the following data modes.

ASCII
- double digit numerics
- ASCII values 0 - 127
- Extended ASCII values 128 - 255
C40
- Upper-case alphanumeric
- Lower case and special characters
Text
- Lower-case alphanumeric
- Upper case and special characters
X12: ANSI X12 EDI data set
EDIFACT: ASCII values 32 - 94
Base 256: All byte values 0 - 255

If you fully understand your encoded Data Matrix character set, you can choose the right data mode. Otherwise, you'd better choose Data Matrix data mode as "AUTO". With "AUTO" data mode, the barcode generator software will automatically select the right data modes for you based on your encoded characters.

Data Matrix Maximum Character Size

Depends on your encoding Data Matrix characters type, a single Data Matrix barcode supports maximum char length from 1,555 to 3,116 characters.

Alphanumeric data: max up to 2,335 characters
Byte data (8-bit): max up to 1,555 characters
Numeric data: max up to 3,116 digits

You need make sure that the encoded character size will not exceed the maximum character length, otherwise the Excel Data Matrix generator will automatically create an error image with message "Invalid Barcode Settings" printed.

Data Matrix Characters Encoding in Microsoft Excel

Data Matrix Encode ASCII Printable Characters

ASCII characters code values from 32 to 126 are printable characters, represent letters, digits, punctuation marks, and a few miscellaneous symbols.

You can key in ASCII printable characters directly in the Data text box in the Barcode Generator Excel setting pane.

Or you can generate Data Matrix from linked Excel Cell data with ASCII printable chars. View details here:
How to create barcodes using the linked Excel Cell data using Barcode Generator for Excel add-in?

Data Matrix Encode Unicode Characters

Data Matrix barcode supports Unicode text encoding. You can easily generate Data Matrix from Unicode text in Microsoft Excel document using Barcode Generator for Excel.

Choose Data mode as BASE256
Select your preferred byte encode mode from property Encode for bytes. By default it is UTF-8.
Key in the Unicode text in property Data or the linked Excel cell.

You can view more details about Unicode text encode in 2d barcode in Excel here:
How to create barcodes from Unicode text in Microsoft Excel using Excel Barcode Generator?

Data Matrix Encode GS1 Data Message

Data Matrix symbology is one of the GS1 Standard supporting data carriers. It is really easy task to encode GS1 data elements using Excel Barcode Generator add-in. View details at:
How to encode GS1 data in barcodes in Microsoft Excel 365/2019?

Data Matrix 2d barcodes with property settings in Microsoft Excel

Top

Basic Settings

Barcode Type: choose "Data Matrix / GS1 Data Matrix" to create standard Data Matrix and GS1 compatible Data Matrix barcodes in Excel file.
Data: Data Matrix data to encode. The data here should be compatible with Data Matrix supported character sets.

Data Matrix Advanced Settings

Apply tilde (~): If it is checked, the Code 128 barcode generator software allows using the tilde character "~" to specify special characters in the Code 128 input data. For more information, please read the details here:
How to encode barcode with non-printable characters in Excel document?
Data mode: Data Matrix data encoding modes, which will be applied to convert Data Matrix data message to codewords.
- AUTO (recommended): In auto data mode, the Excel barcode generator software will automatically use the best suitable Data Matrix data mode to convert data message into Data Matrix codewords.
- ASCII: It is used to encode data that mainly contains ASCII characters (0-127).
- C40: It is used to encode data that mainly contains numeric and upper case characters.
- TEXT: It is used to encode data that mainly contains numeric and lower case characters.
- X12: It is used to encode the standard ANSI X12 electronic data interchange characters.
- EDIFACT: It is used to encode 63 ASCII values (values from 32 to 94) plus an Unlatch character (binary 011111).
- BASE256: It is to encode byte array datas
Encode for bytes: This property is applicable when the "Data mode" is "BASE256". Most of the Data Matrix 2d barcode generator and scanner softwares or apps will use UTF-8 to encode byte array datas.
Format mode: Specifies the Data Matrix Format to use on that symbology. Valid values are *X*;
GS1 Compatible Barcode: To create GS1 Data Matrix barcodes in Excel, you should check this checkbox option. View details here: How to create GS1 Data Matrix barcodes in Microsoft Excel file?

Barcode Common Settings

Data Matrix barcode dimension width and height, view more information here: Barcode dimension size options in Excel
Data Matrix barcode module colors, you can apply Data Matrix bar and space modules color settings:
- Bar and space colors
- Transparent background image
view details here: How to apply barcodes bar and space color settings in Excel?

Generate Data Matrix Barcode into MS Excel

Top

How to Generate Data Matrix Barcode for Excel

Open a new Excel spreadsheet firstly. Switch to "Add-Ins" and click "Create Barcode" to activate "Barcode Settings" panel. Choose a cell to produce the barcode image. Select "DATAMATRIX", input encodable data, and then click "Generate".

How to Modify Generated Data Matrix in Excel

On the one hand, users can switch to "Barcode Size". Bar width, image width and height, margin and rotation degree are all allowed to be revised. On the other hand, switch to "2D Barcode" to choose required data mode and format mode. After this, please remember to click "Update".

How to Create Data Matrix Barcode List in Excel

First of all, start with a new Excel spreadsheet to activate the task panel. And then within the "Barcode Settings" panel, select a column of cells with required data. Choose "DATAMATRIX", and click "Generate".

How to Link Data Matrix to Cell for Excel

Choose a cell to generate a Data Matrix image. Click "Link To Cell". And select a cell with data. Then click "Update". Now, the Data Matrix image is linked to the data in the cell. Besides, multiple barcode images can be linked to different cells. Link multiple Data Matrix images to different cells with data respectively. Change the data and click "Update Link To Cell".

To get more detail, please click Integration Tutorial for Office Excel Barcode Generator provided by OnBarcode.com

Barcode Types Supported by Excel Barcode Add-In

Top

1D / Linear Barcodes

2D / Matrix Barcodes: Data Matrix, PDF417, QR Code