Print electronics parts bin barcodes from Excel
Open the free label maker: https://app.mylabelmaker.com. No signup. Design the label, then print to a Zebra or download PNG, PDF, or ZPL.
You can print electronics parts bin barcodes from Excel. Open the free label maker, barcode {{mpn}} or {{bin}}, put the value in large type, and stick it on the drawer. No signup. Don't barcode a long manufacturer URL.
Good to know: Barcode the number you will scan later, usually the MPN or your bin ID. Do not barcode a long manufacturer URL.
How to print electronics bin barcodes from Excel
- Open https://app.mylabelmaker.com. No signup.
- Headers: mpn, value, bin. Set 2x1 to fit a small drawer front.
- {{value}} large. CODE128 with {{mpn}}. {{bin}} in the corner.
- Upload the Excel file. Print a drawer you can reach. Scan. Then the rest.
Sample spreadsheet
A first pass on resistor and IC drawers.
| mpn | value | bin |
|---|---|---|
| RC0603-10K | 10k 0603 | R-12 |
| RC0603-1K | 1k 0603 | R-04 |
| ATMEGA328P | ATmega328P | IC-02 |
First row is the header. Those header words go inside the curly braces on the label, like {{mpn}}.
Shop tools: tool crib labels. Mechanical parts: parts barcodes.
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.