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, and 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 if you use bins.
- Open https://app.mylabelmaker.com. No signup. Set 2x1.
- CODE128 with {{part}}. {{name}} under the bars.
- Upload the Excel file. Preview 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
Got a Zebra? Print from the browser with Browser Print, at the printer's DPI. Otherwise download PNG, JPG, SVG, PDF, or ZPL. JSON keeps the label you can open later.
Print parts barcodes from this BOM
The numbers on the sheet. Stickers on the bins.
Open free label maker