Print jewelry inventory barcodes 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 jewelry book is SKU, description, and price. Design a small tag in the free label maker. Barcode {{sku}}. Add metal and {{price}}. Upload. Print the case reset.
Good to know: Measure the tag stock. A 2x1 will not wrap a ring. Use a jewelry tag size you actually bought.
How to print jewelry tags from the book
- Headers: sku, name, metal, price.
- Open the free label maker. Set the tag size (often 2x0.5 or 2x1).
- CODE128 with {{sku}}, small. {{name}} {{metal}} {{price}}.
- Upload the Excel file. Print two tags. Check they fold. Then the case.
Sample spreadsheet
A Saturday case reset.
| sku | name | metal | price |
|---|---|---|---|
| J-104 | Chain 16in | SS | $42 |
| J-105 | Hoops small | 14k | $120 |
| J-106 | Signet 7 | SS | $58 |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
Generic jewelry maker: jewelry label maker.
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.