Print lot and expiration labels from Google Sheets
Free label maker: app.mylabelmaker.com — no signup. Native barcodes, Excel/Sheets batch, export or Zebra print. Related: barcodes from Excel · Google Sheets · all guides.
The actual question people ask
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 maker · label maker hub.
Honest scope: FDA, USDA, and kitchen health-code dating are yours. A date sticker is not a process authority.
Steps that match the query
- Lot / batch token
- Use-by / packed-on date as text (not a formula screenshot)
- SKU or item name
- Reprint only the lots you packed today
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.
Batch from Excel or Google Sheets
Map column tokens into text, barcodes, or QR. Paste CSV, upload a file, or load a published Google Sheet. Preview rows, then print quantity 1 before the stack. Guide: mail merge · CSV mail merge.
Print or export
Zebra thermal: Browser Print at the printer’s DPI. Everyone else: Options → PNG, JPEG, SVG, PDF, or ZPL. JSON saves the editable master.
Related
Try this workflow free
Browser canvas · native barcodes · Excel batch · export or Zebra print. No account.
Open free label maker