The Free Excel CMMS: Run Maintenance on a Spreadsheet (Template Inside)

If your plant runs maintenance on a clipboard, a whiteboard, and the memory of one or two key people, you already know the failure modes: a request gets lost, a PM gets skipped, a part runs out at the worst possible time, and the same breakdown happens twice because nobody wrote down what fixed it.

The good news: you don't need to buy enterprise software to fix this. You can build a perfectly good CMMS in Excel and be organized by the end of the shift. This guide walks through exactly how — and there's a free template at the bottom so you don't have to start from a blank sheet.

What a CMMS actually is (in plain terms)

A CMMS — computerized maintenance management system — is just one place that holds your maintenance work instead of scattering it across paper, texts, and people's heads. At a minimum it tracks four things:

1. Work orders — every job: requested, in progress, done.
2. Preventive maintenance (PM) — recurring work, so it happens before something breaks.
3. Spare parts — what's on hand, and when to reorder.
4. A dashboard — the few numbers that tell you whether you're winning.

A spreadsheet can do all four. Here's how to set each one up.

Tab 1 — Work orders

This is the heart of it. One row per job. The columns that matter:

• WO number — a simple sequential ID so you can refer to a job ("close out WO-104").
• Date raised and requested by.
• Asset / equipment — what it's on.
• Description — what needs doing.
• Priority — low / medium / high / critical.
• Assigned to and status — open, in progress, on hold, done.
• Completion notes and labour hours — what actually fixed it. This is the column people skip and regret. Your completion notes are your plant's memory.

The rule that makes it work: every request becomes a row. No request lives only in someone's head or a text message. If it's not in the sheet, it doesn't exist.

Tab 2 — Preventive maintenance schedule

Reactive maintenance is expensive and stressful. PM is how you get ahead of it. Set up a tab with one row per recurring task:

• Task (e.g. "Inspect and lubricate line 2 gearbox").
• Asset and frequency (every 7 / 30 / 90 days).
• Last done and next due — a simple formula (last done + frequency) gives you the next due date.
• A status column that flags anything overdue (conditional formatting in red does this nicely).

Each week, look at what's due, and raise a work order for it on Tab 1. That handoff — PM due → work order → done → reset the "last done" date — is the loop that keeps equipment healthy.

Tab 3 — Spare parts & inventory

Stockouts cause downtime. A simple parts tab prevents most of them:

• Part name / SKU, location (bin), on-hand quantity.
• Reorder point — the level at which you reorder.
• A flag column: if on-hand ≤ reorder point, show "REORDER".

When you consume a part on a job, decrement the on-hand count. Now your storeroom tells the truth instead of surprising you.

Tab 4 — The dashboard

Three numbers tell you whether maintenance is winning:

• PM compliance — of the PMs due this month, what % got done on time? Under ~80% means you're still mostly reacting; good plants live in the 90s.
• Open / overdue work orders — watch the trend, not the number.
• Planned vs unplanned — the more of your work that's scheduled rather than "drop everything," the cheaper and calmer everything gets.

A few COUNTIF formulas across your work-order and PM tabs will calculate all three automatically.

Get the free template

You can build all of this yourself — or start from one that's already set up. We put the four tabs above into a free workbook with the formulas, the reorder flags, and the dashboard already wired:

→ Download the free Excel CMMS Lite

Add five assets, open three work orders for jobs already on your list, and set one PM. That's it — you're running maintenance off a system instead of memory.

Where the spreadsheet starts to break

A spreadsheet is a great place to start, and for a very small operation it might be all you ever need. But it has a ceiling, and you'll feel it the day:

• More than one person needs to edit it at the same time (hello, version chaos).
• You want technicians updating jobs from their phones on the floor, not back at a desk.
• You keep forgetting to check what PM is due, because nothing reminds you.
• You want history that rolls up by line or area, not buried across a dozen tabs.
• You need to answer "who closed this, and when?" — and the sheet can't.

That's the point where a purpose-built web CMMS earns its keep. It's the same four concepts — work orders, PM, parts, a dashboard — but multi-user, on phones, with PMs that generate their own work orders and a real asset history. And it should still set up in an afternoon, not a six-month project.

If you've hit that ceiling, you can try the full web version free for 30 days — no credit card. Either way, the goal is the same: move your plant from firefighting to under control.

The bottom line

You don't need a budget approval to get organized. Start with the spreadsheet today, get every request logged and every PM scheduled, and you'll already be ahead of most plants. Grab the free template, and upgrade to a real system the day the spreadsheet starts fighting back.