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

GS1-128 Barcode Generator for Excel

No Excel macro, formula, vba, GS1-128 font, to create and print EAN/GS1-128 barcode images in Excel spreadsheet

Download Excel Barcode Generator Free Evaluation

Using Excel GS1 128 (EAN 128) Barcode Generator Add-in to create EAN-128 in Excel without Barcode Font, VBA, Excel Macro, Formula.



In this GS1-128 generator Excel user guide, you will learn how to create, print GS1-128 barcode images in Microsoft Office Excel files.

  • Create GS1-128 barcodes compatible with both GS1 and Code 128 standards in Excel
  • Easy to input GS1 identification code and data
  • No font, fomula, vba, macro programming required.

How to create GS1-128 barcodes in Office Excel?

  1. Download GS1-128 Barcode Generator Excel Add-in
  2. Install GS1-128 Excel add-in to add GS1-128 barcodes to Excel files
  3. Step by Step Tutorial






ON THIS PAGE:



  • Completely available to be integrated with for MS Office Excel 2016, 2013, 2010 & 2007
  • Create GS1 128 barcodes in Excel spreadsheets immediately with this Excel add-in
  • GS1 128 (UCC/EAN 128) barcode specifications are unnecessary for users
  • Industry standards of GS1 128 (UCC/EAN 128) Barcode are configured
  • Article lists or catalogues is allowable to be produced without any effort
  • High quality barcode images are supported by this Excel Barcode Generator without EAN 128 font, VBA, Excel macro, formula.
  • Barcode Font files are not necessary while inserting GS1 128 (UCC/EAN 128) barcode


[Video]: How to create, print GS1-128 barcode in Microsoft Excel. Step by step.

Top




The GS1-128 barcode is a subset of the Code 128 barcode symbology.

By agreement between AIM and GS1, use of the Function 1 Symbol Character (FNC1) in Code 128 symbols in the first symbol character position following the start character has been reserved exclusively for the GS1 system. This extremely flexible symbology encodes element strings using GS1 Application Identifiers.



As an efficient and convenient barcode generator, GS1-128 Barcode Excel Add-In is commonly used to insert GS1 128 barcode images in the Excel workbook. It is simple and easy to create required GS1 128 image for users who have no special programming skills.

You can view more detailed user guide to encode, print, customize 2d and linear barcodes in Microsoft Excel at
How to generate 1d and 2d barcodes in Microsoft Excel document without any font, VBA, formula, Macro programming?
How to create multiple (bulk) barcodes in Microsoft Excel sheet?
How to encode, print GS1 barcodes in Office Excel 365?
How to create barcodes in Word mail merge using data from Excel cells?
How to create and draw barcodes on the specified area (width and height) in Excel?

OnBarcode.com provides Barcode Generator (not font) Excel Add In for Excel as well as other professional & reliable 1D & 2D barcode add-ins for Excel and Word, including Code 39 excel add-in, Code 128 generator for excel, UPC-A barcode add-in for excel, QR Code generator for excel, Data Matrix for excel, etc.

GS1-128 Barcode Data Encoding in Excel

Top

GS1-128 data character set

GS1-128 barcode supports the following data characters
  • The GS1 subset of International Standard ISO/IEC 646
  • Four non-data function characters. FNC1, FNC2, FNC3, FNC4. FNC2 and FNC4 are not used in GS1-128 barcodes.
  • Four code set selection characters (including single character code set shift).
  • Three start characters.
  • One stop character.
Using Excel barcode generator software, you do not need encode function characters and start, stop characters to GS1-128 barcode. You need encode GS1 data message only, and the barcode generator software will automatically insert the function chars into GS1-128 barcode symbology.


GS1-128 check digit character

GS1-128 barcode has one mandatory symbol check character. The check digit character will not be displayed in the HRI (human readable interpretation).



Using Excel barcode generator, the property "Add checksum char" is not applicable. The barcode encoder software will automatically add one check character before the stop character in every GS1-128 barcode symbol.


GS1-128 GS1 data message encoding in Excel

The GS1 data message includes one or multiple element strings, and each element string is the combination of a GS1 Application Identifier (AI) and its data field.

Here is a sample GS1 data message: (01)99012345678909(15)241015(21)abc. There are totally three element strings.
  • 01 - GTIN (identification of a trade item). The AI Code will be followed by fixed 14 digits
  • 15 - Best before date. The AI Code will be followed by fixed 6 digits in YYMMDD. The example date here is Oct 15, 2024
  • 21 - Serial number. A serial number is assigned to an entity for its lifetime. When combined with a GTIN, a serial number uniquely identifies an individual item. A serial number is in a variable length from 1 to 20 alphanumeric chars.
When you encode GS1 data message in Excel, all the AI code are surrounded by parentheses, and followed by its data field. In Barcode Generator Excel "Barcode Settings" pane, you can directly key in the "(01)99012345678909(15)241015(21)abc" in Data property



Generate GS1 128 (UCC/EAN 128) for Excel
Top

How to Create GS1 128 (UCC/EAN 128) Barcode on Excel

Open a new excel document to activate the "Barcode Settings" panel. Choose "GS1 128 (UCC/EAN 128)", enter demanded data and click "Generate". Users can click "Delete" to remove the inserted GS1 128 (UCC/EAN 128) barcode image if necessary.

How to Configure GS1 128 (UCC/EAN 128) Barcode on Excel

Choose the generated GS1 128 (UCC/EAN 128) barcode image, and making adjustments in the "Barcode Settings" panel is allowed. Users can modify some basic properties of this barcode image, like width, height, rotation degree, etc. After that, click "Update" to get the required barcode image.

How to Create GS1 128 (UCC/EAN 128) Barcode List in Excel

It is also easy to create GS1 128 (UCC/EAN 128) barcode lists. Activate the "Barcode Settings" panel. Choose a column of cells with data to create barcode images, and then click "Generate". A list of GS1 128 (UCC/EAN 128) barcode images will be embedded on the excel workbook.

How to Link GS1 128 (UCC/EAN 128) to Cell for Excel

Our Excel barcode addin is available to create dynamic GS1 128 (UCC/EAN 128) barcode images. First of all, choose or create the required barcode image. Then click "Link To Cell" and chose a data cell. After this, click "Update".
Besides, multiple GS1 128 (UCC/EAN 128) images are able to be linked to target cells. Link barcode images to selected cells, and revise the data in linked cells. And then click "Update Link To Cell".
OnBarcode.com also provides more detail with Integration Tutorial for Office Excel Barcode Generator
Barcode Types Supported by Barcode Generator in Excel
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.