Excel GS1 128 Generator Data Encoding User Guide

Summy:

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.

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".

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

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?