Free Asset Register Template (Excel)

Free Asset Register Template (Excel)

Every maintenance system — whether it's a £50k CMMS or a spreadsheet — is built on the same foundation: a list of what you're maintaining.

That list is your asset register. Get it right and everything else follows. Get it wrong and you'll be chasing ghosts — PM tasks assigned to assets that don't exist, work orders logged against the wrong equipment, auditors pointing at gaps in your records.

This template gives you a clean starting structure. It's not complicated, because asset registers that are too complicated don't get maintained.

Download the Template

What an Asset Register Is For

An asset register is a single source of truth for what assets you manage, where they are, and what state they're in. It answers three questions:

1. What do we have? — the full inventory
2. Where is it? — location hierarchy
3. What state is it in? — active, inactive, disposed

Everything else in your maintenance system — work orders, PM tasks, maintenance history — references the asset register. The Asset ID in every other sheet links back here.

What to Include

Non-negotiable fields

Useful additions

What not to add — don't add fields you won't populate or use. An asset register with 40 columns where 30 are empty is harder to use than one with 10 columns that are complete. Start small.

Getting Asset IDs Right

This is where most people make the mistake, and it compounds over time.

Short and logical. Your technicians will type or say these IDs constantly. HVAC-A3 works. HVAC-BUILDING-A-FLOOR-3-UNIT-07 does not.

Consistent prefix by category. Use the same prefix for all assets of the same type:

• Pumps: PUMP-01, PUMP-02
• HVAC units: HVAC-01, HVAC-02
• Generators: GEN-01
• Fire extinguishers: FIRE-EXT-01

Don't encode location in the ID. Assets move. If you encode the building into the ID (PUMP-BLDG-A-01) and then the pump moves to Building B, your ID is wrong. Location belongs in the Location column.

Pad numbers. Use PUMP-01 not PUMP-1 so your sorting works correctly when you hit double digits.

Structuring Location

Location is worth thinking about before you start. How you structure it determines how useful filtering is.

Simple (one site, one building): Free text — "Plant Room", "Roof", "Floor 2". That's fine.

Multi-floor, multi-building: Consider a hierarchy column: Building → Floor → Area. Or use a structured format in one field: Building A / Floor 2 / Plant Room.

Multi-site: Add a Site column first, then Location within that site. You'll thank yourself when you need to filter assets by site for a regional report.

Populating the Register

The first pass is the hardest. You're essentially doing a physical audit of everything you manage.

Walk the site. There is no substitute. Assets that "should" be on site sometimes aren't. Assets nobody knew about are behind doors that haven't been opened in two years. Walk the site, list what you see, assign IDs on the spot.

Don't try to be perfect. Get 80% complete and accurate, then iterate. A live register with 80% coverage is infinitely more useful than a "perfect" register that's still being built six months later.

Start with assets that already have maintenance tasks. If you have any existing maintenance records — even a calendar reminder for a quarterly inspection — start with those assets. They're the ones where gaps cost you most.

One asset, one row. Don't be tempted to list "Pump A and B" in a single row. When Pump A fails and Pump B doesn't, you need separate records.

Keeping It Current

An asset register is only useful if it reflects reality. The two biggest killers:

Decommissioned assets that stay Active. When something is taken out of service, update the Status to Inactive or Disposed immediately. Old active assets create ghost PM tasks and confusion in work order searches.

New assets that never get added. New equipment arrives on site, gets installed, and starts running — but nobody added it to the register. Then it fails and nobody can find it in the system.

The fix for both is ownership. One person is responsible for keeping the register current. Not "the team" — one person. They're the only one who can add assets and change Status. Everyone else submits requests to them.

Connecting to the Rest of Your System

The asset register is the hub. Everything else connects to it via Asset ID:

• Work orders reference the Asset ID of what's being repaired
• PM tasks reference the Asset ID of what's being maintained
• Maintenance history references the Asset ID of what was worked on

This connection is what turns four separate spreadsheets into a system. You can filter the work order sheet by Asset ID and see the full repair history for a specific pump. You can filter the PM schedule by category and see all HVAC tasks at once.

For the complete four-sheet system in one file, see the full CMMS Excel template.

When the Register Outgrows Excel

The asset register is the last thing to cause problems. It's relatively static — assets don't change that often. The trouble usually starts with work orders and PM tracking, where the dynamic data is.

But there are register-specific limits:

Version control. Anyone with edit access can change or delete records. There's no history of who changed what and when. For audited industries, this is a genuine problem.

Linking to documents. Warranties, manuals, calibration certificates — you want these attached to the asset record. Excel can link to files but those links break when folders move, and attachments balloon file size.

Asset hierarchies. A pump is part of a pumping system which is part of a plant. Excel can represent this in columns but can't model the hierarchy in a way that lets you filter "show me everything in Pumping System 3."

The 5 signs you've outgrown spreadsheets covers the broader transition.