GS1-128 Label Generator from Excel and Google Sheets
Turn Excel, CSV, pasted rows, or Google Sheets data into GS1-128-style labels for GTIN, lot number, batch number, expiry date, serial number, location, and quantity fields. Preview the full label, expand quantities, and export a print-ready PDF instead of downloading loose barcode images.
Browser-based label workflow for spreadsheet data. No Excel add-in, barcode font, or macro required.
For batch, carton, warehouse, food, cosmetic, and supplement labels
Generate GS1-128, lot, batch, expiry, and product labels from spreadsheet rows
Import Excel, CSV, pasted rows, or a shared Google Sheet with GTIN, lot, batch, expiry, serial, quantity, and traceability fields. Choose GS1-128 or another barcode format, preview labels, and export one print-ready PDF.
Import and edit data
3 rows ready. Quantity expands into 6 printable labels.
| Actions | Product | GTIN | Lot / Batch | Serial | Location | Qty | Price |
|---|---|---|---|---|---|---|---|
1. Wireless Mouse
(01)09521234543213(10)ABC123 · Aisle A / Bin 04
2. USB-C Dock
(01)10012345000017(17)260531 · Aisle B / Bin 11
3. Barcode Scanner
(00)106141411234567890 · Receiving Desk
Preview and export
Add data fields
10Click an imported column to place it on the label preview.
Label sheet
Barcode label workflow
3 rows ready. Quantity expands into 6 printable labels.
Label sheet
Built for spreadsheet data and real label printers
A GS1-128 label workflow should solve more than one barcode image
Many search results generate a single barcode image or talk about UPC/EAN input conversion. Manufacturing, food, cosmetic, and warehouse teams usually need full labels: product text, normalized GTIN, lot, expiry, batch, quantity, and a layout that prints correctly.
Spreadsheet rows become label rows
Bring in Excel, CSV, pasted rows, or Google Sheets data instead of typing one GS1-128 value at a time.
UPC and EAN inputs become GTIN-14
Use GTIN-8, UPC-A, EAN-13, or GTIN-14 values from your sheet. The label workflow right-aligns shorter GTINs with leading zeros for GS1 AI (01); it does not create a new GS1 number.
Lot and expiry fields stay visible
Keep human-readable lot, batch, serial, expiry, and product fields on the label so operators can verify the print before it reaches packaging.
Quantities expand into printable labels
Use quantity columns to create the number of labels needed for cartons, units, samples, shelf locations, or batch-controlled products.
PDF output fits real stock
Choose common thermal sizes or sheet layouts instead of downloading one loose barcode image and rebuilding a label elsewhere.
Best fits for GS1-128, lot, and expiry label searches
Position this page for operators who need labels for traceability, not just a barcode image download.
Print labels that include product name, GTIN, lot number, expiry or best-before date, and quantity for small-batch production and packaging runs.
How to create GS1-128-style labels from a spreadsheet
A practical browser workflow for label sheets, not one-off barcode images.
Prepare product and batch rows
Use columns such as product_name, gtin, lot_number, batch_number, expiry_date, serial_number, location, quantity, and qr_url.
Import Excel, CSV, pasted rows, or Google Sheets
Bring your production, warehouse, or packaging sheet into the label workflow and review rows before export.
Review the normalized GS1 text
Check the generated (01) GTIN-14 value plus lot, expiry, and serial Application Identifier text before printing.
Preview and export PDF labels
Check visible product, lot, expiry, serial, and quantity data, then export a print-ready PDF for your label stock.
Features for batch and traceability label printing
Focused on the jobs behind GS1-128 searches: repeatable labels, spreadsheet imports, and production-ready PDFs.
Excel, CSV, paste, and Google Sheets
Import production, packaging, receiving, or catalog rows from the sources small teams already use.
Lot, batch, expiry, and serial fields
Keep variable production data visible on the label next to the barcode for human verification.
Quantity-aware batch output
Use quantity columns to repeat labels for units, cartons, bins, or samples without duplicating rows manually.
Thermal and sheet layouts
Choose compact thermal sizes or Avery-style sheet layouts depending on how your packaging area prints.
Browser-based preview
Preview the label sheet before export so long product names, lot numbers, and expiry dates do not surprise you at the printer.
Clear GS1 boundary
The tool helps format and print labels. Your company remains responsible for GS1 number assignment, Application Identifier rules, verification, and partner requirements.
GS1-128 label generator FAQ
Practical answers for users searching for GS1-128, lot, batch, expiry, and barcode label printing.
Still have questions?
If you couldn't find the answer you're looking for, please feel free to ask us!
Create GS1-128-style batch labels from your spreadsheet
Import product, lot, expiry, serial, and quantity rows, preview the labels, and export a print-ready PDF.