Excel Data Matrix Generator Data Encoding Tutorial

Summy:

Data Matrix, also known as Data Matrix ECC200, is great 2-dimensional matrix barcode to store different data up to 2,335 alphanumeric characters.

Excel Data Matrix Barcode Add-In is a professional Data Matrix barcode generator which allows you to generate & create Data Matrix barcode in your Microsoft Office Excel 365, Excel 2019 and Excel 2016 versions. The Excel Add-in also supports encoding and creating GS1 Data Matrix in Excel. You can generate/print high-quality Data Matrix barcode images that are compatible with specifications and customize color, size, rotation, font, etc.

Data Matrix barcode supports full ASCII characters encoding.

Data Matrix supports the following characters encoding

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

Depends on your encoding data type, Data Matrix supports maximum length from 1,555 to 3,116 characters.

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

Data Matrix will encode the data using any combination of six encoding modes (schemes).

Encodation Scheme	Characters	Setting in Excel
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

The following Excel report template is from our existing customers, who will create an Excel inventory sheet. In the sheet, he needs create several barcodes on an A4 sheet for each products. One barcode he needs print on sheet is the Data Matrix 2d barcode, which encodes product GTIN, expiration date and batch number inside.

Here is a sample Excel document which includes 10 products' information inside. We will instruct you how to generate multiple GS1 Data Matrix barcodes in one column using OnBarcode Excel Barcode add-in software.

1. Create valide GS1 data message in column "GS1 Data" based on the product data on columns "GTIN", "Expiration Date", and "Batch Number".
   GTIN GS1 AI code is "01".
   Expiration Date GS1 AI code is "17".
   Batch Number GS1 AI code is "10".
   
   We need add AI code to each product information data. Key in the following Excel function code in Cell [D2] to [D11]
   ="(01)"&A2&"(17)"&B2&"(10)"&C2
   
   


2. Create a template Data Matrix barcode.
   
   Create a Data Matrix anywhere in Excel sheet, with the following options applied:
   Set Data to "(01)12345".
   In tab "Barcode Size":
       Bar width (X) to 32
   In tab "2D Barcode":
       GS1 Compatible Barcode to checked
   
   


3. Now we will generate multiple GS1 Data Matrix barcode labels in column "Data Matrix". All Data Matrix barcodes are using the data from column "GS1 Data".
   
   You can view the details about bulk barcode creating here:
   How to print, insert bulk barcodes in Excel column?