Excel EAN 13 Generator Data Encoding Tutorial

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



Summy:
  • Install & uninstall barcode Excel add-in
  • Quick to create an EAN-13 barcode
  • How to generate a valid EAN-13 barcode images
  • How to create EAN-13 image by using selected cell data
  • How to create a high resolution EAN-13 image for printing
  • How to generate list of EAN-13 barcodes in Excel


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.

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 365/2019/2016/2013/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.




EAN-13 Data Encoding

Top

EAN 13 valid characters

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

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


EAN 13 data length

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




Step by step guide to create list of EAN 13 bar codes with valid data in Excel document

Top
The following request and guide is from one of our customers.

Jack has a list of product EAN bar codes, and he wants to represent these data as actual EAN-13 barcodes in the next column in the Excel document.

The list of ean barcodes are in 13 digits.





  1. As we know, the complete EAN-13 bar code includes 13 digits. The first 12 digits are the EAN-13 data, which is usually presenting a product ID, and the last digit is the check sum digit. Using OnBarcode Barcode Excel add-in, the barcode software will automatically calculate the last digit for you. You need input the 12 digits product ID in the Excel document.

    In column C, we will create the list of real EAN 13 data.

    In cell C4 function, key in =LEFT(B4, 12) to get the first 12 digits of the B4 data. And repeat the same steps from cell C4 to C7.

  2. Now we have got the list of real product ID in 12 digits. Here we will create a sample EAN-13 barcode with customized barcode settings, include bar module size, text size, text margin. And the final list of EAN-13 barcode will use the same properties as the sample one.

    Apply the following EAN 13 properties in the Barcode Settings panel on the right size in Excel application.

    In tab "Barcode Size"
        Set Bar width (X) to 6
        Set Text margin to 20
    In tab "1D Barcode"
        Set font size to 14

    Now you have created a sample EAN13 bar code label as template.

  3. Here we will create list of EAN 13 bar code images on column D.

    You can know the bulk barcode generation here: How to generate multiple barcodes in one Excel column?









OnBarcode is a market-leading provider of barcode imaging 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 comprehensive tutorials and how-tos for various linear, 2d barcode information, such as C# in ASP.NET, C# .NET, C# Barcode Encoding, C# Barcode Image, VB.NET in ASP.NET, VB.NET Winforms, VB.NET Barcode Encoding. 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.