Print warehouse location 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.
Yes. You can print warehouse location barcodes from Excel. Location barcodes go on the rack, not the SKU. Put every slot id in the sheet, design one label in the free label maker, barcode {{loc}}, add aisle and bay as text, print the map. No signup.
Good to know: One unique loc per row. Duplicate slot IDs send pickers to the wrong bay.
How to print location barcodes from Excel
- Open https://app.mylabelmaker.com. No signup. Set 3x2 or 4x2 so a pallet jack can scan it.
- Headers: loc, aisle, bay, level.
- CODE128 with {{loc}}. {{aisle}} {{bay}} {{level}} in large type.
- Upload the Excel file. Walk two bays. Scan. Print the rest.
Sample spreadsheet
A first aisle of a small warehouse might look like this.
| loc | aisle | bay | level |
|---|---|---|---|
| A01-B01-L1 | A01 | B01 | L1 |
| A01-B01-L2 | A01 | B01 | L2 |
| A01-B02-L1 | A01 | B02 | L1 |
First row is the header. Those header words go inside the curly braces on the label, like {{loc}}.
Item stickers are a different run: inventory barcodes. Bin names only: bin labels from Excel.
Print or save
If you have a Zebra, print from the browser with Browser Print at the printer's DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. Save JSON if you want the editable master later.