Print asset tags from an Excel inventory list

Asset id + barcode from your inventory sheet

← Back to Blog

Print asset tags from an Excel inventory list

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 asset tag template

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

IT and facilities teams keep assets in Excel and then ask how to get a tag on each laptop or cart. Map {{asset}} {{loc}} {{user}}, barcode the id, print 2×1 or 2×3 tags. Open the free label maker to do it now.

Good to know: Do not print passwords, BitLocker keys, or serials you treat as secrets on a visible tag.

How to print asset tags from an Excel inventory list

  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 asset id as CODE128 (not a screenshot).
  3. Preview row 1 and a row near the end of the sheet.
  4. Print the stack on a Zebra, or export PDF / ZPL.

A common warehouse setup

The usual thread is “300 unique barcodes on a ZD421.” Same workflow: one layout, many rows. Save JSON so next year’s inventory uses the same face.

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 asset tag template