Print lot and expiration labels from Google Sheets

Lot + use-by per row from the sheet

← Back to Blog

Print lot and expiration labels from Google Sheets

Published: · 3 min read · How-to
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.

Kitchens and CPG teams keep lot and use-by in a Sheet. Map {{lot}} {{exp}} {{sku}}, print FIFO dots or 2×1 product faces. Open the free label maker to do it now.

Good to know: FDA, USDA, and kitchen health-code dating are yours. A date sticker is not a process authority.

How to print lot and expiration labels from Google Sheets

  1. Open the free label maker and set the size of your stock.
  2. Add a native barcode (not an Excel font) and map the spreadsheet column, for example {{code}}. Use a column of lot / batch token.
  3. Preview row 1 and a row near the end of the sheet.
  4. Print the stack on a Zebra, or export PDF / ZPL.

Date formats

Use a format humans and scanners agree on (YYYY-MM-DD or MM/DD/YYYY) and stick to it. Mixed formats are how FIFO fails.

Print or save

Zebra thermal: print from the browser with Browser Print at the printer’s DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.

Print from your spreadsheet

Map a column, preview a row, then print. No signup.

Open free label maker