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