How to Generate EAN-13 in Excel
EAN-13, based on UPC-A standard, is implemented by EAN in Europe. It is the standard version of EAN barcode symbology. EAN-13 is linear barcode symbology with a fixed length of 13 digits and widely used in marking retail good.
BusinessRefinery.com provides a set of methods for EAN-13 generation, and EAN-13 Add-In for Excel is one of them. It supports to create single EAN-13 barcode, EAN-13 barcode lists or link EAN-13 barcodes in Microsoft Office Excel cells as your wish.
EAN-13 Add-In for Excel provides advanced controls over every aspect of barcode properties, such as X, Y dimension, Barcode width & height, wide to narrow ratio, quiet margins of top, bottom, right and left, etc. Here is a user guide for making EAN-13 barcode in MS-Excel. You can get more specific tutorials here on
how to encode valid data for EAN-13,
how customize EAN-13 barcode image, and
how to specify proper size for EAN-13.
EAN-13 Add-In for Excel Features
| Encodable Characters | Support to encode:
- 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
| Supplementary Barcode | Support to add 2-digit & 5-digit supplementary barcode for EAN-13 barcodes |
| Barcode Specification | Support to generate pre-configured EAN-13 barcodes in accordance with GS1 General Specification (Version 8) |
| MS-Excel Version | Efficient, accurate EAN-13 barcode generation compatible with Microsoft Office Excel 2007/2010 |
| Full Barcode Options | Multiple barcode setting options for you to select, including module width, image width, color, rotation, resolution, text, etc. |
| Check Digit Option | Automatically add Modulo 10 checksum digit for EAN-13 barcodes |
EAN-13 Add-In for Excel Requirements
Windows OS & .NET Compatible with Microsoft Windows 7/XP/Vista, Windows Installer 3.1, VSTO 3.0 Runtime sp1, and .NET Framework 3.5 sp1. | Microsoft Office Compatible with Microsoft Office Excel Workbook 2007; Microsoft Office Excel Workbook 2010. |
Install EAN-13 Add-In for Excel
- Download BizCode Add-In for Microsoft Exceland unzip;
- Closed your Excel and Run the Setup file;
- Open your Office Excel, you will Excel barcode add-in has been installed successfully!
How to Generate EAN-13 Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "EAN-13";
- Input some data - "123456789012" in "Data";
- Click "Generate"; then an EAN-13 barcode occurs in your Excel Workbook.
How to Generate EAN-13 Barcode with 2 & 5 digits Add-On in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "EAN-13+2";
- Input some data - "123456789012" in "Data";
- Click "Generate"; then an EAN-13 barcode occurs in your Excel Workbook;
- Go to "Linear Barcode" and input "56" in "Supplement Data";
- Click "Update"; then an EAN-13+2 barcode occurs in your Excel Workbook.
How to Link cell with a EAN-13 Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "EAN-13";
- Input some data - "123456789012" in "Data";
- Click "Generate"; then an EAN-13 barcode occurs in your Excel Workbook;
- Click on a cell with data and click "Link to Cell";
- Click "Update"; then an EAN-13 barcode occurs in the cell you choose.
How to Generate Multiple EAN-13 Barcodes in Different Cells?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "EAN-13";
- Input some data - "EAN-13" in "Data"; click "Generate"; then an EAN-13 barcode occurs in your Excel Workbook;
- Click on a cell with data and click "Link to Cell";
- Click "Generate"; then a EAN-13 barcode occurs in the cell you choose;
- Change the data in the cell you choose and click "Update Link to Cell";
- Click "Generate"; then a different EAN-13 barcode occurs.
How to Generate EAN-13 Barcode list in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "EAN-13";
- Input some data in all the cells that you want to convert to barcodes;
- Select all the cells that you want to convert to barcodes and click "Link to Cell";
- Click "Generate"; then a list of EAN-13 barcodes occurs in cell you choose.
