Excel UPC-A Generator Data Encoding Tutorial

samples to input valid data and generate linear UPC-A images in Excel



Excel UPC-A Introduction

Excel UPC-A Add-In - Overview

UPC-A, also known as Universal Product Code version A , UPC Code, UPC Symbol, GTIN-12, GS1-12, UCC-12, is the most common and well-known barcode symbology in the United States.

Excel UPC-A Barcode Add-In is a professional UPC-A barcode generator which allows you to generate & create UPC-A barcode in your Microsoft Office Excel 2003, Excel 2007 and Excel 2010 versions. You can generate/print high-quality UPC-A barcode images that are compatible with specifications and customize color, size, rotation, font, etc.

For more details, you may refer to:


UPC-A Related Products

Besides UPC-A Barcode Add-In for MS Excel, Onbarcode.com provides other barcode component on UPC-A to make your business more professional, such UPC-A in ASP.NET, UPC-A in Crystal Report, UPC-A in WinForms, UPC-A in C# , UPC-A in VB.NET, UPC-A for Ipad, and UPC-A for Iphone, etc.


Excel UPC-A Data Encoding

UPC-A Valid Character Set

UPC-A is a linear barcode symbology that encode numeric digits only.

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

Excel UPC-A provides three modes to encode UPC-A valid value:

Mode UPC-A UPC-A+2 UPC-A+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 UPC-A

2. Write down data to encoded"44556687788";

3. Set Image Format to PNG;

1. Choose Barcode Type to UPC-A

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

3. Set supplement data "99"

4. Set Image Format to PNG;

1. Choose Barcode Type to UPC-A

2. Write down data to encoded "44556687788";

3. Set supplement data "99999"

4. Set Image Format to PNG;



Sample Image


UPC-A Valid Barcode Length

UPC-A is a fixed-length linear barcode symbology, encoding 11-digit data without the last check digit. However, you can also add a 2-digit or 5-digit supplemental symbol to encode extra information.

Fixed-length 11 digits 13 digits 16 digits
Sample Encoding 1. Choose Barcode Type to UPC-A

2. Write down data to encoded"11111555551";

3. Set Image Format to PNG;



1. Choose Barcode Type to UPC-A

2. Input data to encoded - "11111555551";

3. Input Supplement Data "15"

4. Set Image Format to PNG;



1. Choose Barcode Type to UPC-A

2. Input data to encoded - "11111555551;

3. Input Supplement Data "15151"

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.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.