Should I use QR codes or barcodes for asset tags?

Use QR codes when a scan should open an asset record, service form, or lookup page. Use Code 128 or Code 39 when your team scans a short asset ID into an inventory system. Many teams print both a readable Asset ID and a QR code.

Can a QR asset tag update my spreadsheet automatically?

A printed QR code can open a link, form, or asset record. It does not update a private spreadsheet by itself. If you want staff to update status or location after scanning, point the QR URL to a form, app page, or asset management record that your team controls.

Can I print one replacement asset label?

Yes. Paste one row, use the Add row button, or import a small CSV with the damaged or reassigned asset. This is useful when one tag peels off, an item moves rooms, or a label needs a corrected serial number.

Which label stock should I use for laptops, tools, and shared equipment?

Use durable label stock when tags will be handled often, cleaned, transported, or used by students or field crews. The generator creates the PDF layout; the final durability depends on your printer, label material, adhesive, lamination, and where you apply the tag.

Can I print asset tags on Dymo, Brother, Zebra, or Rollo printers?

Yes. Choose a thermal label size such as 50 x 25 mm, 60 x 40 mm, Dymo 30334, or Brother DK-1201, then export the PDF and print at actual size. Always test scan quality before printing a full roll.

Can I use existing serial numbers as asset IDs?

You can, but many teams keep a separate asset_id so the label remains stable even when a device is repaired, replaced, or tracked across systems. You can print both asset_id and serial_number on the same tag.

Is this a full asset tracking system?

No. It helps create printable asset tags from the data you already maintain. You can link QR codes to your own spreadsheet, helpdesk, form, database, or asset management system, but this page does not replace your inventory process.

Batch print asset tags, QR labels, and replacement labels

Asset Tag Maker for Inventory Labels

Q: Can I make asset tags from an Excel file?

Yes. Upload an Excel or CSV file with columns such as asset_id, serial_number, item_name, location, department, assigned_to, quantity, and qr_url. The tool imports the rows so you can map each column onto the asset tag.

Turn Excel, CSV, pasted rows, or Google Sheets into printable asset tags, QR property labels, serial number stickers, equipment labels, and warehouse inventory labels. Import asset IDs, serial numbers, locations, owners, QR URLs, and quantities, then export an Avery-ready or thermal PDF.

Create Asset Tags

Open Label Designer School Asset Tags

Use this for printable tags and internal tracking labels. If your organization needs rugged metal plates, tamper-evident materials, or a full asset management system, use the generated IDs with the label stock and tracking process your team approves.

Built for IT teams, schools, warehouses, offices, labs, and field equipment

Asset tag maker from Excel with QR code, asset ID, serial number, and location fields

Spreadsheet asset label printing workflow

Try the asset tag maker

Generate asset tags from spreadsheet rows

Import asset IDs, serial numbers, locations, assigned users, departments, QR URLs, and quantities. Choose an asset tag layout, preview real rows, and export a print-ready PDF for sheet labels or thermal printers.

Step 1

Import and edit data

4 asset rows ready. Quantity expands into 5 printable tags.

Detected columns available for label design:nameskulocationquantityQR URLasset_idassigned_tobarcodedepartmentqr_url

Actions	Asset name	Barcode	Asset ID	Serial	Location	Copies	Price

1. MacBook Pro 14

AST-1001 · IT Office / Shelf A

Asset name

Barcode

Asset ID

Serial

Location

Copies

Price

QR URL

2. Document Camera

AST-1002 · Room 204

Asset name

Barcode

Asset ID

Serial

Location

Copies

Price

QR URL

3. Barcode Scanner

AST-1003 · Warehouse / Receiving

Asset name

Barcode

Asset ID

Serial

Location

Copies

Price

QR URL

4. Projector Cart

AST-1004 · Building B / Storage

Asset name

Barcode

Asset ID

Serial

Location

Copies

Price

QR URL

Step 2

Preview and export

Add data fields

Click an imported column, add fixed text, upload an image, or paste text/image from the clipboard.

Template and barcode settings are applied automatically from your data. Adjust them here only when you need a specific printer stock, layout, or scanner format.

Default barcode format

Label stock

Add or select a field to edit its position, display type, and style.

Preview

1/4

Label sheet

Add a data field to start designing this label.

QR50 x 25 mm thermal asset tagAsset Tag1 per page5 page PDF5 labels

Barcode label workflow

4 asset rows ready. Quantity expands into 5 printable tags.

Preview

Label sheet

Add a data field to start designing this label.

QR50 x 25 mm thermal asset tag5 labels

Decide What Each Asset Tag Should Do

Most teams do not need a perfect design first. They need labels that match the way assets are scanned, reassigned, repaired, and replaced.

QR asset labels

Use QR codes when a scan should open an asset record, service form, inventory lookup, or maintenance page.

Best for

Equipment with a web-based record or a check-in / check-out workflow.

Useful fields

asset_id, qr_url, item_name, location, department, assigned_to

Barcode asset tags

Use Code 128 or Code 39 when staff scan into an existing inventory system or need compact, readable IDs.

Best for

Serial numbers, property IDs, older scanners, receiving desks, and repeat inventory counts.

Useful fields

asset_id, serial_number, barcode, location, quantity

Replacement labels

Keep a small print workflow for tags that peel, get scratched, or need a new location after reassignment.

Best for

One-off reprints without rebuilding a full label sheet.

Useful fields

asset_id, serial_number, item_name, updated_location, copies

Durable label stock

Choose material before the final batch when tags will be handled by students, customers, field crews, or warehouse teams.

Best for

Laptops, tablets, tools, carts, lab equipment, outdoor gear, and shared equipment.

Useful fields

asset_id, department, owner, support_url, replacement_date

Comparison criteria	Best for When this choice helps	Useful fields Spreadsheet columns to include
QR asset labels Use QR codes when a scan should open an asset record, service form, inventory lookup, or maintenance page.	Equipment with a web-based record or a check-in / check-out workflow.	asset_id, qr_url, item_name, location, department, assigned_to
Barcode asset tags Use Code 128 or Code 39 when staff scan into an existing inventory system or need compact, readable IDs.	Serial numbers, property IDs, older scanners, receiving desks, and repeat inventory counts.	asset_id, serial_number, barcode, location, quantity
Replacement labels Keep a small print workflow for tags that peel, get scratched, or need a new location after reassignment.	One-off reprints without rebuilding a full label sheet.	asset_id, serial_number, item_name, updated_location, copies
Durable label stock Choose material before the final batch when tags will be handled by students, customers, field crews, or warehouse teams.	Laptops, tablets, tools, carts, lab equipment, outdoor gear, and shared equipment.	asset_id, department, owner, support_url, replacement_date

From Asset Spreadsheet to Printable Tags

This page is for teams that already have the asset list but still need labels that print cleanly. Keep the data in Excel, CSV, or Google Sheets, then use the label workflow to create QR tags, barcode tags, and replacement labels.

Bring the Asset List You Already Use

Upload Excel or CSV, paste rows, or import a shared Google Sheet with asset IDs, serial numbers, locations, departments, and QR links.

Use QR, Barcode, or Both

Print QR codes for asset lookup pages, Code 128 for scanner workflows, or a mixed label with human-readable text and a fallback code.

Preview Real Asset Rows

Check the longest equipment names, serial numbers, and locations before using adhesive stock.

Print Bulk Batches or Replacements

Quantity columns expand repeated tags, while pasted rows make it easy to reprint one damaged or reassigned asset label.

How to Print Asset Tags from Excel or Google Sheets

Start with the asset records you already have. The label design should follow the workflow your team uses to scan, find, and maintain equipment.

Prepare One Row per Asset

Use columns such as asset_id, serial_number, item_name, location, department, assigned_to, quantity, and qr_url.

Choose the Scan Method

Use QR codes for links and web records. Use Code 128 or Code 39 for compact asset IDs and scanner-first inventory counts.

Pick Label Stock

Choose thermal roll labels for one-at-a-time printing, Avery-style sheets for batches, or durable stock for high-touch equipment.

Export, Test, and Apply

Export the PDF, print a plain-paper or spare-label test, scan a few tags, then apply labels to the final equipment batch.

Choose Label Stock by How the Asset Is Used

A tag for a laptop cart has different needs than a tag for a storage bin. Pick the stock and layout before printing the full batch.

Thermal asset labels

Single-label printing for replacement tags, receiving desks, tool rooms, and ongoing asset intake.

Good fit

Dymo, Brother, Zebra, Rollo-style workflows where staff print a few labels at a time.

Print notes

Check the label width, printer driver scale, and whether the material is durable enough for the asset.

Avery-style sheets

Batch printing for office assets, classrooms, inventory counts, and seasonal relabeling.

Good fit

30-up, 80-up, 10-up, and durable ID label sheets.

Print notes

Print at 100% / Actual Size and test alignment before using label stock.

Small durable tags

Compact tags for laptops, tablets, tools, scanners, small electronics, and shared equipment.

Good fit

Asset ID plus QR code or barcode, with short human-readable text.

Print notes

Keep the QR code large enough to scan after the label is applied.

Large equipment labels

Roomier labels for carts, bins, furniture, storage shelves, and equipment cases.

Good fit

Asset ID, item name, department, location, QR link, and support contact.

Print notes

Use the extra space for readable location text, not just a larger logo.

Comparison criteria	Good fit Where this stock works	Print notes What to check
Thermal asset labels Single-label printing for replacement tags, receiving desks, tool rooms, and ongoing asset intake.	Dymo, Brother, Zebra, Rollo-style workflows where staff print a few labels at a time.	Check the label width, printer driver scale, and whether the material is durable enough for the asset.
Avery-style sheets Batch printing for office assets, classrooms, inventory counts, and seasonal relabeling.	30-up, 80-up, 10-up, and durable ID label sheets.	Print at 100% / Actual Size and test alignment before using label stock.
Small durable tags Compact tags for laptops, tablets, tools, scanners, small electronics, and shared equipment.	Asset ID plus QR code or barcode, with short human-readable text.	Keep the QR code large enough to scan after the label is applied.
Large equipment labels Roomier labels for carts, bins, furniture, storage shelves, and equipment cases.	Asset ID, item name, department, location, QR link, and support contact.	Use the extra space for readable location text, not just a larger logo.

Before You Print the Full Asset Batch

Asset labels are often applied in one long tagging session. Catch layout and scanning problems before staff start sticking labels to equipment.

Scan a test QR or barcode

Make sure the code opens the correct asset record or scans into the expected inventory field.

Check

Test with the phones or scanners your team actually uses.

Print at actual size

Label sheets and small thermal tags drift when the PDF is scaled to fit.

Check

Use 100% / Actual Size in the print dialog.

Preview the longest records

Serial numbers, room names, departments, and assigned user names can overflow on small tags.

Check

Review the longest rows before exporting the final PDF.

Confirm material and placement

Labels on laptops, carts, tools, and classroom devices can rub, peel, or get covered by hands and cases.

Check

Choose durable stock and apply the tag where it can be scanned.

Comparison criteria	Check What to verify
Scan a test QR or barcode Make sure the code opens the correct asset record or scans into the expected inventory field.	Test with the phones or scanners your team actually uses.
Print at actual size Label sheets and small thermal tags drift when the PDF is scaled to fit.	Use 100% / Actual Size in the print dialog.
Preview the longest records Serial numbers, room names, departments, and assigned user names can overflow on small tags.	Review the longest rows before exporting the final PDF.
Confirm material and placement Labels on laptops, carts, tools, and classroom devices can rub, peel, or get covered by hands and cases.	Choose durable stock and apply the tag where it can be scanned.

Asset Tag Maker FAQ

Practical questions teams ask before printing asset tags, QR labels, and replacement inventory labels.

Still have questions?

If you couldn't find the answer you're looking for, please feel free to ask us!

Your Question

Your Email

Create Asset Tags from Your Existing Inventory List

Import asset IDs, serial numbers, locations, QR URLs, and quantities, preview the label batch, and export a PDF that your team can test before tagging equipment.

Start Asset Tag Maker

Open Advanced Designer

Asset Tag Maker for Inventory Labels

Generate asset tags from spreadsheet rows

Import and edit data

Preview and export

Label sheet

Label sheet

Decide What Each Asset Tag Should Do

From Asset Spreadsheet to Printable Tags

Bring the Asset List You Already Use

Use QR, Barcode, or Both

Preview Real Asset Rows

Print Bulk Batches or Replacements

How to Print Asset Tags from Excel or Google Sheets

Prepare One Row per Asset

Choose the Scan Method

Pick Label Stock

Export, Test, and Apply

Choose Label Stock by How the Asset Is Used

Before You Print the Full Asset Batch

Related Label Workflows

Bulk Barcode Generator

School Asset Tags

Excel to Labels

Google Sheets to Labels

Label Designer

Uline Label Template Maker

Asset Tag Maker FAQ

Can I make asset tags from an Excel file?

Should I use QR codes or barcodes for asset tags?

Can a QR asset tag update my spreadsheet automatically?

Can I print one replacement asset label?

Which label stock should I use for laptops, tools, and shared equipment?

Can I print asset tags on Dymo, Brother, Zebra, or Rollo printers?

Can I use existing serial numbers as asset IDs?

Is this a full asset tracking system?

Still have questions?

Create Asset Tags from Your Existing Inventory List