How to print product 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.
You run a small shop. Inventory lives in Excel: soap, candles, tote bags. You need a sticker on each one with the name, SKU, and price. Do not type 80 labels. Design one sticker in the free label maker, load the sheet, print the stack.
Good to know: The header names in Excel must match the placeholders on the label. If the column is price, use {{price}}.
How a shop prints stickers from inventory
- Keep the inventory sheet. Headers: name, sku, price.
- Open the free label maker. Set a 2x1 or 3x2 sticker.
- Add {{name}} large, {{sku}} under it, {{price}} on the right. Optional: barcode with {{sku}}.
- Open Variables. Upload the Excel file. Preview two rows. Print.
Sample spreadsheet
A Saturday restock for a candle and soap shop might look like this.
| name | sku | price |
|---|---|---|
| Lavender soap | SOAP-12 | $8.00 |
| Pine candle | CAND-04 | $14.00 |
| Canvas tote | TOTE-01 | $18.00 |
First row is the header. Those header words go inside the curly braces on the label, like {{name}}.
Full steps: print many labels from Excel.
Print or save
Print on a Zebra from the browser, or download PNG or PDF if you print another way.