Print warehouse bin labels from a spreadsheet

Aisle-rack-bin from the location file

← Back to Blog

Print warehouse bin labels from a spreadsheet

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

Bin location tag sample from the free label maker
This is the bin location tag template in the free app. Open it and swap in your own text.

Warehouse location files already have aisle, rack, and bin. Design a large location line plus a barcode of the full code, then merge the file. Do not typeset 400 bins by hand in ZebraDesigner. Open the free label maker to do it now.

Good to know: Location schemes (and any WMS check-digit rules) are yours. We print the strings you map.

How to print warehouse bin labels from a spreadsheet

  1. Open the free label maker and set the size of your stock.
  2. Add a native barcode (not an Excel font) and map the spreadsheet column, for example {{code}}. Use a column of {{aisle}}-{{rack}}-{{bin}} as the hero type.
  3. Preview row 1 and a row near the end of the sheet.
  4. Print the stack on a Zebra, or export PDF / ZPL.

Reprint one bay

When a rack is renamed, filter the sheet to those rows and print only that range. Related: warehouse bin location guide.

Print or save

Zebra thermal: print from the browser with Browser Print at the printer’s DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.

Print from your spreadsheet

Map a column, preview a row, then print. No signup.

Open bin location tag template