Guide to Generate Data Matrix in Excel
Create and print high-quality Data Matrix barcodes in Microsoft Excel
- Compatible with Microsoft Office Excel 2007 running on Windows
- Support Windows 2007, Windows Server 2008, Windows Vista, Windows XP, etc.
- Easily generate and draw 2d Data Matrix in MS Excel spreadsheets
- Flexible Data Matrix barcode settings including module width, image width, height, margins, etc.
- Compatible with ISO/IEC specifications for Data Matrix for valid image output
- High-quality Data Matrix barcode printout for all printers
- Mature and reliable barcode generator for Data Matrix generation in Excel
Data Matrix Introduction
Data Matrix, also named as ECC200, 2D DataMatrix barcode, is a two-dimensional matrix barcode commonly used to mark small items. Being space-efficient, Data Matrix is recommended by American EIA for labeling small electronic components.
Data Matrix Barcode Encodable Character Set:
- ASCII: All ASCII characters, including 0-9, A-Z, a-z and special characters like $ , % + / : * etc.
- Auto: KeepAutomation will select proper data format according to your encoding value.
- Base256: to encode images, double-byte characters, binary data and 8 bit values.
- C40: 0-9, A-Z
- Edifact: 0-9, A-Z, many punctuation marks
- Text: 0-9, a-z
- X12: 0-9, A-Z, and some punctuation marks
Data Matrix Generation in Excel
Install KA.Barcode Add-In for Excel
1.
Close all your Excel documents
2.
Download KA.Barcode Add-In for Excel and unzip.
3.
Click "KeepAutomation.Barcode.Excel.2007.Addin.msi" to install.
4.
Open an Excel document. Click "install" in the pop-up "Microsoft Office Customization Installer"
5.
Now you will see Add-Ins in the Excel menu bar.
How to Generate Data Matrix in Excel
1.
Switch to Add-In tab in Excel
2.
Click "Barcode" in KeepAutomation add-in, a Barcode Setting panel pops up on the right.
3.
Select "DATAMATRIX" in the barcode type pull-down menu
4.
Select the cell for barcode generation, and click "Generate" in Barcode Setting panel.
5.
Now a Data Matrix is successfully generated!
How to Generate a Data Matrix List in Excel
1.
Switch to Add-In tab in Excel
2.
Click "Barcode" in KeepAutomation add-in, and a Barcode Setting panel pops up.
3.
Select "DATAMATRIX" in the barcode type pull-down menu.
4.
Select a list of cells for barcode generation, and click "Generate" in Barcode Setting panel.
5.
All the cells in the list are converted into a list of Data Matrix barcode images.
How to Update Data Matrix Image
1.
Select the printed Data Matrix image
2.
Adjust barcode settings in the right-side setting panel
3.
Click "Update" button, and you will see the updated barcode image
How to Link Data Matrix Barcode to Cell Contents
1.
Open an Excel spreadsheet, generate a Data Matrix and click "link to cell"
2.
Select a cell with data, and click "update" (To undo it, click Cancel)
3.
Now the Data Matrix image is successfully linked to the data in the cell
4.
You can also revise multiple cell data, and click "update link to cell"
5.
Now all the linked Data Matrix images will update to the revised data in selected cells.
