Print inventory labels from Excel

Name, SKU, location. One sticker per row.

← Back to Blog

Print inventory 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

Inventory already lives in Excel. The sticker should too. Design one inventory label in the free label maker. Map {{sku}}, {{name}}, {{bin}}. Upload the sheet. Print the restock.

Good to know: Print only the rows you are tagging today. A full dump of discontinued SKUs wastes the roll.

How to print inventory labels from a sheet

  1. Headers: sku, name, bin.
  2. Open the free label maker. Set 2x1 or 3x2.
  3. {{name}} large. Barcode {{sku}}. {{bin}} in the corner.
  4. Upload the Excel file. Preview a bin you know. Print.

Sample spreadsheet

A Monday restock for aisle A might look like this.

skunamebin
FLT-20Cabin filterA-12
BLT-7Drive beltA-13
GLV-MNitrile MB-01

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

Shop stickers with price: product stickers from inventory. Bins only: bin labels from Excel.

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 this restock

The inventory sheet. Stickers on the bins.

Open free label maker