- Entirely compatible with Microsoft Office Excel 365, 2021, 2019, 2016, 2013, 2010 and 2007 on Windows
- All matrix barcodes are compatible with respective 2D barcode specifications
- 2D barcode fonts and programming skills are not required by this barcode generator Excel add-in
- Capable of adding QR Code, Data Matrix, and PDF417 barcodes in Excel documents
- Be able to create a single 2D barcode and a batch of 2D barcodes in Excel spreadsheets
- Supported error correction feature increases the readability of the generated 2D barcodes
- Rich barcode settings are provided to help users to customize 2D barcodes
Introduction of 2D (Matrix) Barcode Excel Generator Add-in
Top
Excel 2D Barcode Generation Add-In
is a two dimensional barcode encoder for Microsoft Excel 365, 2021, 2019, 2016, 2013, 2010 and 2007 versions.
This 2D barcode encoder allows users to add QR Code, Data Matrix and PDF417 barcodes in excel spreadsheets with a few clicks.
It is easy to generate high quality 2D barcodes in Excel documents for users without understanding any 2D barcode specifications.
- Data Matrix - Excel Data Matrix barcode generator prints high quality Data Matrix barcodes in MS Office Excel documents.
This Data Matrix Add-In is widely adopted to create 2D Data Matrix barcodes without font for the purpose of marking small items and it is also used universally in many other applications.
Data Matrix consists of black and white "cells" or modules arranged in either a square or rectangular pattern. A Data Matrix symbol can store up to 2,335 alphanumeric characters. However, the length of the encoded data depends on the symbol dimension that is used.
- PDF-417 - Excel PDF-417 barcode generator creates high quality PDF417 barcodes in MS Office Excel spreadsheets. This Data Matrix Add-In is widely used to draw Data Matrix barcodes for identification cards, inventory management and many other applications.
PDF417 is invented by Dr. Ynjiun P. Wang at Symbol Technologies in 1991. It is a stacked linear symbology adopted in a variety of applications. Each PDF417 consists of 3 to 90 rows, each of which is like a small 1D barcode. - QR Code - Excel QR Code barcode generator draws high quality QR Code barcodes in MS Office Excel documents. This Data Matrix Add-In is widely adopted to generate QR Code for packaging, commercial tracking, entertaining, etc.
QR Code is created by Toyota subsidiary Denso-Wave in 1994 and is one of the most popular two-dimensional barcodes. It has four error correction levels (Level L, Level M, Level Q and Level H) which crease the readability of the created QR Code.
Frequently Asked Questions
What is a 2D barcode?
2D barcodes, also known as two-dimensional barcodes, use patterns, squares, rectangles to encode data both horizontally and vertically, which dramatically increases its data storage capacity comparing to
linear barcodes.
QR Code is the most popular 2d barcode on smart phones and tablets.
Excel Barcode Add-in supports generating QR Code, Data Matrix, PDF-417 2d barcodes in Excel document.
QR Code is the most popular 2d barcode on smart phones and tablets.
Excel Barcode Add-in supports generating QR Code, Data Matrix, PDF-417 2d barcodes in Excel document.
How to verify generated 2d barcodes in Excel?
OnBarcode also provides free barcode scanner software, and you can use it to verify your created 2d barcodes (including QR Code, PDF-417, Data Matrix)
in Excel.
Can I convert international text to 2d barcode in Excel?
Yes. OnBarcode Excel Barcode add-in supports creating 2d barcode with international text string encoded in Excel application.
Follow the steps below:
Follow the steps below:
- Choose one of the 2d barcode formats: QR Code, Data Matrix, or PDF-417
- In tab "2D Barcode", choose "Data mode" as "BYTE"
- Click button "Generate" to create 2d barcode with unicode text encoded
What is a 1D vs 2D barcode?
One of most important difference between 1D & 2D barcodes is the barcode encoding data storage capability. 2D barcodes can hold vast data, including
Unicode text, images, audio, video files. OnBarcode Excel Barcode add-in supports 20+ 2D and 1D barcodes generations in Microsoft Excel documents without barcode fonts.
Is 2D code the same as QR code?
QR Code is one of the 2D barcode formats. 2D barcodes include QR Code, Data Matrix, PDF417 and other formats. OnBarcode Excel Barcode freeware supports
Data Matrix, PDF417 and QR Code (including standard, GS1 version) generations in Excel files.
How do I scan a 2D barcode with iPhone?
Use the iPhone camera to read a QR code or other 2d barcode
- Open Camera on your iPhone.
- Position iPhone so that the 2D barcode appears inside the camera frame.
- Wait for the 2d barcode scanning result. If the 2d barcode is encoding a URL, the iPhone takes you to the target webpage.