How-to

Asset id + barcode from your inventory sheet

← Back to Blog

Print asset tags from an Excel inventory list

Published: · 8 min read · How-to
Free label maker: app.mylabelmaker.com — no signup. Native barcodes, Excel/Sheets batch, export or Zebra print. Related: barcodes from Excel · Google Sheets · all guides.

Open asset tag template

The actual question people ask

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 maker · label maker hub.

Honest scope: Do not print passwords, BitLocker keys, or serials you treat as secrets on a visible tag.

Steps that match the query

r/sysadmin pattern

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.

Batch from Excel or Google Sheets

Map column tokens into text, barcodes, or QR. Paste CSV, upload a file, or load a published Google Sheet. Preview rows, then print quantity 1 before the stack. Guide: mail merge · CSV mail merge.

Print or export

Zebra thermal: Browser Print at the printer’s DPI. Everyone else: Options → PNG, JPEG, SVG, PDF, or ZPL. JSON saves the editable master.

Related

Try this workflow free

Browser canvas · native barcodes · Excel batch · export or Zebra print. No account.

Open free label maker