Print bulk barcode 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.
Bulk barcode labels means one layout and a different code on every sticker. Put SKUs in Excel. Design one label in the free label maker. Map the barcode to {{sku}}. Print the stack.
Good to know: Format the SKU column as text in Excel so leading zeros do not disappear.
How to print a bulk barcode run
- Sheet headers: sku, name. One row per sticker.
- Open the free label maker. Set 2x1 or your stock.
- Add a CODE128 barcode with {{sku}}. Add {{name}} under it.
- Variables, Upload the Excel file. Preview two rows. Print.
Sample spreadsheet
A 200-SKU restock sheet can start this small.
| sku | name |
|---|---|
| 10001 | Black tee M |
| 10002 | Black tee L |
| 10003 | Navy hoodie |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
Same idea from a CSV: barcode labels from CSV. Core steps: many labels from Excel.
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 the bulk barcode run
The SKU list you already keep. Stickers on the boxes.
Open free label maker