How to make key tags from a spreadsheet

Hook number and room. Small stock

← Back to Blog

How to make key tags 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 asset tag template

How to make key tags from a spreadsheet: put hook and room in columns, open the free label maker, set a small tag, map {{hook}} and {{room}}, print. Optional barcode on the hook id.

Good to know: Do not print master-key codes or lock combinations on a tag that can fall off a ring.

How to make key tags from a spreadsheet

  1. Sheet: hook, room, optional barcode id.
  2. Open the free label maker. 1.5x1 or 2x1.
  3. Map {{hook}} and {{room}}. Optional CODE128 on the id.
  4. Preview two hooks. Print on durable stock if you have it.

Front desk and shops

Hotels, gyms, and shops use the same two fields. Save JSON. Add a row when you cut a new key.

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 the key board

Hook and room from the sheet.

Open free label maker