Print classroom supply 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 classroom supply barcodes from Excel. Open the free label maker, barcode a short {{sku}}, add the item and bin, and print before students arrive. No signup. Keep codes short so a cheap scanner still reads them.
Good to know: Keep codes short so a cheap scanner or phone app can read them on a busy cabinet.
How to print classroom supply barcodes from Excel
- Open https://app.mylabelmaker.com. No signup.
- Headers: sku, item, bin. Set 2x1 or 3x2.
- CODE128 with {{sku}}. {{item}} large. {{bin}} small.
- Upload the Excel file. Print the art cabinet first. Scan. Then the rest.
Sample spreadsheet
A first-week classroom inventory.
| sku | item | bin |
|---|---|---|
| RM12-GLUE | Glue sticks | Art-A |
| RM12-CRAY | Crayons 24ct | Art-A |
| RM12-SCI | Hand lenses | Sci-1 |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
Student names are a different run: class roster labels. Books: library 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.