Print lot number labels from Excel
Free label maker: Open app.mylabelmaker.com. No signup. Design the label, print from Excel if you have a list, then download PNG or PDF or print to a Zebra from this computer.
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
- Open https://app.mylabelmaker.com. No signup.
- Set 2x1 or 3x2. Put {{lot}} large or as a barcode. Add {{sku}} and {{packed}}.
- Headers in Excel: lot, sku, packed. Upload the file.
- Check the date format on a test sticker. Then print the run.
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
If you have a Zebra, print from this computer with Browser Print at the printer's DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.
Open the free label maker
No signup. Custom size, barcode or QR, print from Excel, PNG or PDF. Print to a Zebra or from this computer.
Open free label maker