Excel GS1 128 Generator Data Encoding User Guide

How to encode valid GS1 128 data, and generate GS1-128 barcodes in Office Excel document





Summy:
  • Quick to create a GS1-128 barcode
  • What are valid GS1-128 data
  • How to create GS1-128 image by using selected cell data
  • How to create a high resolution GS1-128 image for printing
  • How to generate list of GS1-128 barcodes in Excel
  • Install & uninstall barcode Excel add-in




GS1-128 Data Encoding

Top
GS1-128 (formly EAN-128 or UCC-128) barcode is a subset of Code 128 barcode symbology. Each GS1-128 barcode starts with a Start character (A, B or C) followed by a Function 1 Symbol Character (FNC1) and GS1-128 data message.

GS1-128 data message is a group of Application Identifier code (AI Code) and Application Identifier data field (AI Data). The AI Code defines the specific purpose for the data field followed.

For example AI Code "00" is for Identification of a logistic unit (SSCC), the followed AI Data should contain an SSCC (Serial Shipping Container Code), which is a fixed 18 digits.

A sample GS1-128 with AI Code 00.



GS1-128 data encode in Excel document

Using OnBarcode Barcode for Excel Add-in, you do not need input start character, FNC1, stop character. The barcode software will automatically generate these mandatory characters in the right positions.

What you need provide is the GS1-128 data message, which are a group of Application Identifier code (AI Code) and Application Identifier data field (AI Data).

All AI Codes are surrounded by parentheses. For example: "(00)395123451234567895(01)09501101530003".


The Formula for GS1-128 Formatted Data Fields in Excel

Excel formulas can be written in a variety of ways in order to generate formated GS1-128 data messages. You will explore a simple method as follows.

Select the cell next to your SSCC data field and write the formula as shown below. Here, the SSCC data fields are in column 'B'.

You can write the formula as follows: (SSCC AI Code is 00)

="(00)"&B2



How to create multiple GS1-128/EAN-128 barcode labels in Excel Worksheet

Top
In the following content, you will learn how to create a formated GS1-128 data messages using Excel formula and generated list of GS1-128 barcodes in one Excel column.

The following sample Excel document includes two columns of data fields. The Column B includes list of data fields for SSCC, and the Column C includes data fields of GTIN





  1. Create formated GS1-128 data message using Excel formula.
    In Cell D4, input the formula as follows:

    ="(00)"&B4&"(01)"&C4


  2. Create a sample GS1-128 barcode with options customized as template

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


  3. Create multiple GS1-128 barcodes in Column E (Barcode)

    View the bulk barcode generation in Excel here:
    How to create 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.