Part of Batch labels. Excel, CSV, and Google Sheets how-tos start on that page.

Print lot and expiration labels from Google Sheets

Yes. You can print lot and expiration labels from Google Sheets. Map {{lot}} and {{exp}}, preview a row, then print FIFO dots or 2x1 product faces. Free, no signup.

← 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}}, and {{sku}}, then print FIFO dots or 2x1 product faces. Open the free label maker and start. No signup.

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 https://app.mylabelmaker.com. No signup. Set the size of your stock.
  2. Add text for {{lot}} and {{exp}}. Add a barcode on {{sku}} if you scan it.
  3. Publish the Google Sheet as CSV, paste the URL in Variables, and preview row 1 plus a row near the end.
  4. Print the stack on a Zebra, or download PNG, PDF, or 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

Got a Zebra? Print from the browser with Browser Print, at the printer's DPI. Otherwise download PNG, JPG, SVG, PDF, or ZPL. JSON keeps the label you can open later.

Print lot and use-by from the sheet

Map lot and date, preview a row, then print. No signup.

Open free label maker