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

How to generate barcodes with GS1 data message in Excel document?

Generate, create GS1 barcode (GS1-128, QR Code, Data Matrix) images in Microsoft Office Excel document

Download Excel Barcode Generator Free Evaluation

How to encode GS1 message in barcodes (GS1 QR Code, GS1 Data Matrix, GS1-128) in MS Office Excel file with free online user guide?



In this Excel barcode generator user guide, you will learn how to encode GS1 data message into GS1 System supported barcode symbologies in Microsoft Excel file.

  • Easy to encode GS1 system element strings into QR Code, Data Matrix, GS1-128, EAN/UPC, ITF-14 barcodes
  • Encode GS1 Application Identifier and data elements directly into barcodes without any control characters needed.
  • No font, COM control, VBA, Macro, activex programming code installed

How to generate barcodes with GS1 elements in Microsoft Excel W/O font, VBA?

  1. Download Barcode Generator Excel Add-in software
  2. Install Excel add in to create barcodes with GS1 elements data in Microsoft Excel
  3. Step by Step Tutorial










What is GS1 data message?

The GS1 data message includes one or multiple element strings, and an 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.


GS1-128 with above GS1 data message encoded in Excel document


To encode the above GS1 data message in Standard AI element strings in the Microsoft Office Excel document, you could use the following barcode types which are listed in the GS1 General Specifications.
  • GS1-128
  • GS1 DataBar
  • GS1 DataMatrix
  • GS1 QR Code




How to create GS1 barcodes with GS1 data in Office Excel document?

Top

Create GS1-128

To create GS1-128 barcodes in Excel file, please apply the following options in the Excel Barcode Settings pane.
  • Choose Barcode Type as "GS1 128 (UCC/EAN 128)"
  • Input Data as "(01)99012345678909(15)241015(21)abc"



Create GS1 QR Code

To create GS1 QR Code in Microsoft Excel document, please apply the following options in the Excel Barcode Settings pane.
  • Choose Barcode Type as "QRCODE"
  • Input Data as "(01)99012345678909(15)241015(21)abc"
  • In Tab "2D Barcode", Check option "GS1 Compatible Barcode"


Create GS1 Data Matrix

To create GS1 Data Matrix in Office Excel document, please apply the following options in the Excel Barcode Settings pane.
  • Choose Barcode Type as "DATAMATRIX"
  • Input Data as "(01)99012345678909(15)241015(21)abc"
  • In Tab "2D Barcode", Check option "GS1 Compatible Barcode"
















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.