Print barcode labels by quantity from Excel
You can print barcode labels by quantity from Excel. The free label maker prints one sticker per row. If you have 15 of SOAP-12, put SOAP-12 on 15 rows, or print that one SKU and choose 15 copies. No signup.
How to print barcode labels by quantity from Excel
- Open https://app.mylabelmaker.com. No signup.
- For mixed SKUs, duplicate each row once per unit (15 stock = 15 identical rows). Barcode {{sku}}. Add {{name}}.
- Upload the file. Preview. The stack matches the row count.
- For one SKU only: load one row, print, and set copies to the quantity on the printer dialog.
Sample spreadsheet
A restock that needs three stickers of one SKU and one of another.
| sku | name |
|---|---|
| SOAP-12 | Lavender soap |
| SOAP-12 | Lavender soap |
| SOAP-12 | Lavender soap |
| CAND-04 | Pine candle |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
Inventory run: barcodes for inventory. Print on a Zebra from the browser, or download PNG or PDF if you print another way.
Print or save
Got a Zebra? Print with Browser Print at the printer's DPI. Everyone else: print from this computer, or download PNG, JPG, SVG, PDF, or ZPL. Save JSON if you want the editable master back later.
Print the right number of stickers
Match the count in the sheet. Then scan a test.
Open free label maker