Most small plants don't fail at preventive maintenance because they bought the wrong software. They fail because PM lives in someone's head, on a clipboard, or in a calendar reminder that gets snoozed for three weeks. You don't need a six-figure CMMS to fix that. You need a structured list, sensible frequencies, and a schedule your team can see. Excel does all three.
Here's how to build a preventive maintenance program in Excel that your technicians will actually follow.
Step 1: List your assets before your tasks
The single biggest mistake is starting with tasks ("grease the conveyor") instead of assets. Start with a clean asset list. One row per piece of equipment, with:
- A short, consistent Asset ID (e.g.,
CONV-01,OVEN-02) - Asset name and location/area
- Criticality — how badly does it hurt if this goes down? High / Medium / Low
Criticality matters more than people expect. It's what stops you from writing 40 PM tasks for a backup pump and zero for the line that runs your whole product.
Step 2: Identify the right PM tasks
For each asset — starting with your High-criticality equipment — ask three questions:
- What does the manufacturer's manual recommend?
- What actually breaks on this machine in our plant?
- What's the cheapest inspection that would have caught the last failure?
Write tasks that are specific and verifiable. "Inspect belts, check tension, look for cracks and glazing" beats "check conveyor." A technician should be able to read the task and know exactly what done looks like.
Step 3: Set frequencies you can defend
Frequency is where Excel PM programs go to die — everything gets set to "monthly" because it's easy. Instead, tie each task to a real interval:
- Time-based: weekly, monthly, quarterly, annual
- Usage-based: every X run-hours or X cycles (if you track them)
A good rule for a first pass: inspections lean more frequent (cheap, fast), and intrusive tasks (teardowns, oil changes) lean less frequent. You can always tighten an interval after a failure; you rarely regret inspecting too often.
Step 4: Build the schedule with a "Next Due" date
This is the part that turns a task list into a program. Add two columns:
- Last Completed Date
- Next Due Date = Last Completed + Frequency (in days)
In Excel, that's a simple formula. Then add a status column that flags each PM as OK, DUE SOON, or OVERDUE based on today's date. Conditional formatting turns that into a color you can read across the room — green, amber, red. Now your PM program tells you what to do this week without anyone thinking about it.
Step 5: Close the loop with completion
A PM that gets done but never recorded is invisible. When a technician finishes, they update Last Completed Date — and the Next Due Date rolls forward automatically. Over a few months this gives you something most small plants have never had: PM compliance — the percentage of PMs completed on time. That one number is the difference between "we do maintenance" and "we manage maintenance."
Step 6: Don't overbuild it
The temptation with Excel is to add 25 columns and three macros in week one. Resist it. A PM program that covers your top 20 assets, runs reliably, and gets updated every week will beat a beautiful spreadsheet nobody maintains. Start small, prove it works, then expand.
A shortcut if you'd rather not start from scratch
Everything above is doable in a blank workbook over a weekend. If you'd rather start from a structure that already has the asset list, PM task fields, frequency logic, auto-calculated due dates, and color-coded status built in, that's exactly what our Preventive Maintenance template in the CMMS Lite set is — a ready-to-use version of this guide.
Either way, the goal is the same: get PM out of people's heads and into a system you can see. A spreadsheet is more than enough to start.
Want a hand setting up a PM program for your plant? Book a free consultation and we'll help you scope it.