Print bin labels from Excel

You changed slotting. The list is already in Excel. Reprint the aisle.

← Back to Blog

Print bin labels from Excel

Published: · 3 min read · How-to
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.

Open bin location template

Yes. You can print warehouse bin labels from Excel. The location list is already in the sheet. Design one bin label in the free label maker, put {{loc}} huge, barcode the same column, load the file, reprint the aisle. No signup.

Good to know: Print one test on the real bin before you run 200. Wrong size is the usual miss.

How to print bin labels from Excel

  1. Open https://app.mylabelmaker.com. No signup. Set 3x2 or the bin size you actually stick.
  2. Headers in the sheet: loc, aisle, sku (optional).
  3. Put {{loc}} large. Add a CODE128 barcode that uses {{loc}}.
  4. Upload the Excel file. Preview two locations. Print the aisle.

Sample spreadsheet

A location dump after slotting might look like this.

locaisle
A-12-04A
A-12-05A
B-03-01B

First row is the header. Those header words go inside the curly braces on the label, like {{loc}}.

More warehouse sizes: bin labels from a spreadsheet.

Print or save

Print on a Zebra from the browser, or download PNG or PDF if you print another way.

Reprint the aisle

Locations in the sheet. Labels on the bins. No account.

Open free label maker