Excel EAN 13 Generator Data Encoding Tutorial

samples to input valid data and generate linear EAN 13 images in Excel


Excel EAN 13 Introduction

Excel EAN 13 Overview

EAN-13, also known as European Article Number 13, UPC-13, GTIN-13, GS1-13, EAN/UCC-13, is the standard barcode version of European Article Number.


More barcode generating in Excel:


Excel EAN 13 is a barcode generating component designed to use on Microsoft Office Excel. It is a mature barcode component to generate, draw EAN 13 barcodes on Microsoft Office Excel 2003/2007/2010. Equipped with 50+ barcode property options, high-quality EAN 13 barcode images can be easily streamed with customized color, size, image, text, etc. This product supports EAN 13 supplement 2-digit barcode and EAN 13 supplement 5-digit barcode to be generated as well.

For more details, you may refer to:


EAN 13 Related Products

Onbarcode.com provides other barcode component on EAN 13 to make your business more professional, please see EAN 13 in ASP.NET, EAN 13 in JAVA, EAN 13 in Winforms, EAN 13 in C#, EAN 13 in VB.NET, EAN 13 for Android, EAN 13 for Iphone, etc.


Excel EAN 13 Data Encoding

EAN 13 Valid Character Set

EAN 13 is linear barcode symbology, which is able to encode numeric data only:

  • 0, 1, 2, 3, 4, 5, 6, 7, 8, 9

Excel EAN 13 provides 3 modes to encode EAN 13 valid value:

Mode EAN-13 EAN-13+2 EAN-13+5
Valid Character Set 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
Sample Encoding 1. Choose Barcode Type to EAN-13;

2. Write down data to encoded - "012345678912";

3. Set Image Format to PNG;

1. Choose Barcode Type to EAN-13+2;

2. Write down data to encoded - "012345678912";

3. Set Supplement Data to 34";

4. Set Image Format to PNG;

1. Choose Barcode Type to EAN-13+5;

2. Write down data to encoded - "012345678912";

3. Set Supplement Data to "56789";

4. Set Image Format to PNG;

Sample Image


EAN 13 Valid Length

EAN 13 is a fixed-length linear barcode symbology, encoding 12-digit data plus a check digit at last.

Fixed-length 13 digits 15 digits 18 digits
Sample Encoding 1. Choose Barcode Type to EAN-13;

2. Write down data to encoded - "135792468013";

3. Set Image Format to PNG;



1. Choose Barcode Type to EAN-13+2;

2. Write down data to encoded - "135792468013";

3. Set Supplement Data to "57";

4. Set Image Format to PNG;

1. Choose Barcode Type to EAN-13+5;

2. Write down data to encoded - "135792468013";

3. Set Supplement Data to "90246";

4. Set Image Format to PNG;



Sample Image



Excel Barcode Generator Supporting Bar Code Types









OnBarcode is a market-leading provider of barcode generator, reader controls and components for ASP.NET, Windows Forms, WPF, as well Java, Android, iOS (iPhone, iPad) across all major enterprise development platforms. We provides high quality tutorials and guides for various linear, 2d barcode information, such as C# Barcode, QR Code C#, QR Code VB.NET, QR Code ASP.NET, QR Code .NET, ASP.NET Barcode. OnBarcode barcode products are supported by RasterEdge ASP.NET Document Viewer, which supports ASP.NET PDF Viewer, ASP.NET MVC Document Viewer, ASP.NET PDF Editor, MVC PDF Viewer. And provide high quality C# Convert PDF to Tiff, C# Convert PDF to Word, C# Convert PDF to HTML, C# Convert PDF to Jpeg images, and their easy and simple documents, like C# PDF SDK, C# extract text from PDF, C# Compress PDF, Print PDF in C# and C# extract image from PDF.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.