Print parts 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 bill of materials is already a list. Design one parts label in the free label maker. Barcode {{part}}. Add {{name}}. Upload the BOM. Print a sticker for every line.
Good to know: Use the part number your MRP or vendor already uses. A second code on the bin causes pick errors.
How to print parts barcodes from a BOM
- Headers: part, name, loc (optional).
- Open the free label maker. Set 2x1.
- CODE128 with {{part}}. {{name}} under the bars.
- Upload the Excel file. Scan a part you know. Print.
Sample spreadsheet
A short mechanical BOM might look like this.
| part | name | loc |
|---|---|---|
| HX-M4-12 | M4x12 hex cap | D-04 |
| BRG-608 | 608 bearing | D-11 |
| SHM-0.5 | 0.5mm shim | D-18 |
First row is the header. Those header words go inside the curly braces on the label, like {{part}}.
Electronics bins: electronics bin barcodes. Kits: kitting barcodes from a BOM.
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 parts barcodes from this BOM
The numbers on the sheet. Stickers on the bins.
Open free label maker