s
Barcode Generator & Reader SDK - OnBarcode  
Download | Purchase | Support

UPC-A Barcode Add-In for Microsoft Excel

No barcode font, Excel macro, formula, vba, to create, print 1D barcode images in Excel spreadsheet
Download Excel Barcode Generator Free Evaluation

Create high quality UPC-A barcode images in Excel spreadsheets with this add-in



In this Excel user guide, you will learn how to create, insert UPC-A barcode images in Microsoft Office Excel files

  • Easy to generate a single UPC-A barcode or multiple UPC-A barcodes in Microsoft Excel document
  • Support Microsoft Office Excel 365 on Windows, Excel 2021, 2019, 2016, 2010, 2007 versions
  • Make and print standard UPC-A barcodes or UPC-A with supplemental 2-digit, or 5-digit code
  • Customize generated UPC-A image in Excel with specified image width, height, image resolution, module colors, text font styles
  • No font, macro, vba, script programming needed

How to create UPC-A barcodes in Microsoft Excel?

  1. Download UPC-A Barcode for Excel Add-in
  2. Install barcode add-in to create UPC-A barcodes in Excel files
  3. Step by Step Tutorial






ON THIS PAGE:



  • Seamlessly Integrate into Microsoft Excel 365, 2021, 2019, 2016, 2013, 2010 and 2007 versions
  • Barcode fonts, vba, macro, programming knowledge are not required by this mature barcode add-in for Excel spreadsheets
  • Generated high quality barcodes can be printed even on low-resolution printers
  • UPC-A industry standards are predefined well in this add-in for users.
  • Allow thermal printers to print generated high quality UPC-A barcodes.
  • Easy to convert a cell or a list of cells filled with data into UPC-A barcodes.
  • Created UPC-A barcode images can be linked to the contents of cells.
  • Parameters of UPC-A barcodes can be adjusted according to requirements.
  • UPC-A Barcode Add-In for Excel calculates and adds the check digit automatically.

[Video] How to make, print UPC-A barcodes in Microsoft Excel files?

Top


UPC-A barcode Add-In for Excel is one of our advanced Excel barcode add-ins which has strong functions. It enables users to create and insert a single UPC-A barcode or an UPC-A barcode list on Microsoft Office Excel spreadsheets easily and quickly.



OnBarcode.com provides Excel Barcode Generator without font, vba, macro for Microsoft Excel as well as other professional & reliable 1D & 2D barcode add-ins for Excel and Word, including Code 39 excel add-in, Code 128 in excel, GS1-128 generator for excel, QR Code generator for excel, Data Matrix for excel, etc.

You could learn more step by step user guide to create, customize barcodes in Excel document here:
How to generate linear and 2d barcodes in Microsoft Excel document?
How to create multiple barcodes in Microsoft Excel sheet?
How to encode and make GS1 barcodes in Excel?
How to create barcodes in Word mail merge with Excel data?
How to create and customize barcode dimension size (width and height) in Excel?

UPC-A Barcode Data Characters Encoding in Excel

Top

UPC-A data character set

UPC-A barcode can encode numeric data from 0 through 9.

A standard UPC-A bar code are grouped by four areas: a number system, a menufacturer code, a product code and a check digit.





How many digits is UPC-A

Each standard UPC-A barcode totally includes 12 digits (0 through 9). The first 11 digits are data message, and followed by a check digit.

UPC-A may also includes a supplemented barcode with 2 digits or 5 digits.



UPC-A with 2 digits supplemented barcode

UPC-A with 5 digits supplemented barcode




UPC-A check sum digit

The UPC-A checksum digit is based on a modulo 10 calculation based on the weighted sum of the values of each of the digits in the number system, manufacturer code, and product code.

Using Excel Barcode Generator software, you do not need input the last check digit. The barcode software will automatically calculate the UPC-A check digit for you. If your provided UPC-A data includes the 12th digit, the barcode software will ignore it, and calculate the checksum digit based on your first 11 digits. You can learn more about the UPC-A check digit calculator here
How to calculate UPC-A check digit?




UPC-A barcode with options in Microsoft Excel

Top

Basic Settings

  • Barcode Type: choose "UPC-A" for UPC-A barcode, "UPC-A +2", or "UPC-A +5" for UPC-A barcode with 2-digit or 5-digit supplemented data.
  • Data: UPC-A barcode encoding data. The valid UPC-A data formats is 11 or 12 digits (0-9). If UPC-A barcode includes supplemented barcode, add "+" with supplemented data. For example, UPC-A with 2-digit supplemented data "12345678901+12".

UPC-A Supplemented Barcode

  • Bar height: (In Supplement data under tab "1D Barcode" ) This is a multiplicator of the height of the bar module; The default is 0.8 (80% of Y - bar module height).
  • Bar space (in px): The space between the UPC-A bar module and the supplement bar. Default is 15 pixel.

Barcode Common Settings





Insert UPC-A Barcodes in Excel
Top

How to Generate an UPC-A Barcode in Excel

First of all, click "Add-Ins" -> "Create Barcode" to activate "Barcode Settings" panel. Then, choose "UPC-A" and type required UPC-A barcode data. Next, click "Generate" button and a single UPC-A barcode is created into the Microsoft Excel document (To remove it, click "Delete").

How to Configure UPC-A in Excel Add-In Setting Panel

In "Barcode Settings" panel users can adjust various parameters of UPC-A barcodes like barcode size, rotation, font, bar alignment, etc. Take bar width as an example. Firstly, select a generated UPC-A barcode and go to "Barcode Size". Then input required data into the text box of "Bar width (X)" to replace the default data. Lastly, click "Update" button.

How to Insert an UPC-A Supplement 2 or 5 Barcode

Click "Add-Ins" -> "Create Barcode" and then "Barcode Settings" panel is activated on the right. Select "UPC-A +2" or "UPC-A +5" in "Barcode Type". Next, input valid data except the supplement data in the text box of "Data" and click "Generate". Now go to "1D Barcode" -> "Supplement data" and input your ideal data to replace the default one.

How to Draw UPC-A Barcode Lists in Excel

Besides a single UPC-A barcode image, this Excel Barcode Add-In allows barcode lists or tables to be created. Specifically, choose a column or row of cells filled with valid data first. Then select "UPC-A" in "Barcode Type". Lastly, click "Generate" button.

How to Link a UPC-A Barcode to a Cell in Excel

Insert an UPC-A barcode in an Excel document first. Then activate "Link To Cell" in "Barcode Settings" panel. Next, select a cell with data and click "Update". Successfully, the linkage between the barcode image and the data in the cell is finished. In addition, multiple barcodes which are linked to different cells can be updated at one time.
More detail will be represented by OnBarcode.com with Integration Tutorial for Office Excel Barcode Generator.
Barcode Types Supported by Excel Barcode Generator
Top
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.