Print Asset Tags from an Inventory Spreadsheet
You have a spreadsheet of IT equipment, furniture, tools, or vehicles. You need a scannable barcode label for each item. Here's how to generate and print asset tags in bulk — free, in 5 minutes.
Your Asset Inventory Spreadsheet
A typical asset inventory looks like this. Export it as CSV or upload the .xlsx directly:
How to Print Asset Tags
Choose a Label Size
Asset tags need to be small but readable. Good choices:
- • DYMO 11354 (32 × 57mm) — compact, fits laptops and monitors
- • DYMO 99012 (36 × 89mm) — room for barcode + description
- • Zebra 2" × 1" — durable thermal labels for industrial equipment
- • Avery L7160 (21/sheet) — if you're using a regular printer
Design Your Asset Tag
A good asset tag includes: company name, asset ID (as text and barcode), description, and location.
Upload Your Inventory
Click 📊 Batch → upload your CSV or Excel file. Each row becomes a unique asset tag with its own barcode.
Export as PDF, print on your label printer or sheet labels. Stick them on your assets. Scan with any barcode reader.
What Goes on an Asset Tag?
✅ Essential
- • Asset ID — unique identifier (AT-0001, SN-12345)
- • Barcode — scannable version of the asset ID (Code 128)
- • Company name / logo — identifies ownership
💡 Optional
- • Description — "MacBook Pro 16" M3"
- • Location — "Office 3A", "Warehouse B"
- • QR code — link to asset management record
- • Purchase date — useful for depreciation
Who Prints Asset Tags?
IT departments
Laptops, monitors, phones, printers, network gear. Barcode scan for check-in/check-out.
Facilities management
Furniture, HVAC, fire extinguishers, appliances. QR code links to maintenance records.
Manufacturing
Machinery, tools, calibration equipment. Sequential tags for compliance and audits.
Healthcare
Medical devices, wheelchairs, infusion pumps. Track location and maintenance schedules.
Schools & universities
Chromebooks, projectors, lab equipment. Track across classrooms and departments.
Construction
Power tools, vehicles, safety equipment. Scannable tags for job site check-out.
FAQ
What barcode format for asset tags?
Code 128 is the standard for asset tags. It encodes any alphanumeric text (AT-0001, SN-12345) and is readable by all barcode scanners. If you want smartphone scanning, add a QR code instead (or both).
How durable are printed asset tag labels?
Durability depends on your label stock, not the printing tool. For indoor use, standard DYMO/Brother labels last years. For outdoor/industrial use, use polyester or vinyl labels (available for Zebra thermal printers). OpenLabelMaker creates the design — the durability comes from the label material you choose.
Can I generate sequential asset IDs automatically?
Yes! Use {{#}} with the auto-numbering feature. Set start to 1, count to 500, prefix "AT-", padding 4 → AT-0001 through AT-0500. See our sequential numbering guide.