2D Data Matrix Barcode Add-In for Microsoft Excel

Excel Data Matrix Barcode Add-In is a mature and reliable barcode generator for Data Matrix generation in Excel without any barcode font, ActiveX installed. 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.

You can click to download free Data Matrix Generator Add-in for Excel.

Click and run the "OnBarcode.Barcode.Excel.Addin.2025.Setup.exe" to install. For more details, go to page:
How to download and install barcode add-in for Excel freeware?

• Open a sample Excel document in Microsoft Excel application.
  Go to Excel toolbar Add-ins > OnBarcode.com, click Create Barcode to open "Barcode Settings" pane.
  

1. Select cell B2 on Excel sheet.
   You will find that the Data text value has been updated to =LINK(B2). It indicate the printed Data Matrix will encode the cell B2's text value.
2. Choose Data Matrix / GS1 Data Matrix from "Barcode Type" dropdown list
3. Click Generate button
   
4. A new Data Matrix has been printed and inserted on cell B2 with the cell B2 text value encoded.
   

Now we will re-print the Data Matrix on cell B2 and it will convert the cell A2 text value to Data Matrix image.

1. Select the Data Matrix barcode on cell B2
2. Change the Data text box value to =LINK(A2)
3. Click button Update
   
4. The Data Matrix image has been updated with cell A2 text value encoded.
   

It is easy to create bulk of Data Matrix barcodes encoding list of Excel cells' values using Excel Barcode Add-in.

1. Choose an existing Data Matrix as template
2. Select a list of cells to create new Data Matrix barcodes
3. Click button Dupliate or Dupliate All

Here we have input more texts on cells in Excel column A, and we will demonstrate how to create and insert multiple Data Matrix barcodes on column B with few clicks.

1. Select the Data Matrix barcode on cell B2. And you will find the following text message on "Barcode Settings" pane.
   
   
   Now you can start duplicating Data Matrix barcodes.
2. Select three cells from cell B3 to cell B5
3. Click button Duplicate All
   
4. The three new Data Matrix images have been generated and printed on cells from B3 to B5.
   

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?

Most of Data Matrix is a square barcode. However some Data Matrix are rectangle barcodes.

• Click and select the Data Matrix
• Find the properties Image width and Image height in group "Width & Height" in tab "Barcode Size", and modify the values.
• Click button "Update" to re-draw the Data Matrix with new width and height.
  

The Data Matrix specification has defined 6 ractangular Data Matrix formats. You can create them by choosing the right Data Matrix format mode.

Using Excel Barcode add-in, you can apply it through property Format mode in tab "2D Barcode" in "Barcode Settings" pane.


To create a rectangular Data Matrix with your target width and height, you need provide the same image width vs height ratio with Data Matrix columns vs rows ratio.

In the following Excel document, the Data Matrix is using the format mode 12x36, the number of column modules are 3 times of the number of row modules. So the Data Matrix image width size should be 3 times of height size. And the generated image width and height are 1536 pixels in width and 512 pixels in height.

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.

• 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.

• 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?

• 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?