Print lot number labels from Excel
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.
A production run has a lot number and a date. Put those in Excel. Design one lot label in the free label maker. Map {{lot}}, {{sku}}, {{packed}}. Print a sticker for every case.
Good to know: Dating and recall rules are yours. The app prints the row. Use-by wording stays your responsibility.
How to print lot labels from a batch sheet
- Headers: lot, sku, packed.
- Open the free label maker. Set 2x1 or 3x2.
- {{lot}} large or as a barcode. Add {{sku}} and {{packed}}.
- Upload the Excel file. Check the date format. Print.
Sample spreadsheet
A Friday cook and pack list might look like this.
| lot | sku | packed |
|---|---|---|
| L-0828A | SAUCE-12 | 2026-08-28 |
| L-0828B | SAUCE-32 | 2026-08-28 |
First row is the header. Those header words go inside the curly braces on the label, like {{lot}}.
Google Sheets dating: lot and expiry from Google Sheets. Kitchen dates: use-by labels.
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.