Exceptional promotion: 50% off all our products. Discover the offer here.
View all posts

CMMS on Google Sheets: Maintenance Tracking for Small Teams

How to manage maintenance schedules, work orders, and asset history in Google Sheets. Built for small teams that cannot justify a full CMMS subscription.

Apr 21, 20265 min read
Maintenance ManagementPreventive MaintenanceCorrective MaintenanceCMMSGoogle SheetsSMEsOperations

Most small teams do not sit down and decide between preventive and corrective maintenance. It just happens. Something breaks, someone fixes it. If there is time left over, a check gets scheduled. Then it gets moved. Then forgotten.

That is corrective-first by default. And for a while, it works, until it does not.

Understanding the difference between the two is not about picking a philosophical approach. It is about knowing what is costing you money, what is creating risk, and where a bit of planning would save a lot of reactive scrambling.

What Is Corrective Maintenance?

Corrective maintenance is what you do after something fails. A machine stops. A system throws an error. A piece of equipment produces unexpected output. You fix it.

It is also called reactive maintenance or breakdown maintenance, and it is the oldest maintenance approach there is.

There are two forms:

Immediate corrective maintenance addresses the failure right away. The machine is down, production is paused, and the team responds now.

Deferred corrective maintenance logs the issue but schedules the fix for later: when it is safe, when a part arrives, or when the equipment is not critical to current operations.

Corrective maintenance is not inherently bad. On low-priority assets, it can actually be the most cost-effective approach. The problem arises when it becomes the only approach, applied indiscriminately to everything, including equipment where a failure causes serious disruption or safety risk.

What Is Preventive Maintenance?

Preventive maintenance is scheduled work done before a failure occurs. The goal is to reduce the likelihood of breakdowns by inspecting, cleaning, lubricating, calibrating, or replacing components on a defined cycle.

It runs on time or usage. Every 30 days, every 500 hours of operation, every quarter, depending on the asset and manufacturer recommendations.

It is proactive by design. The technician does not wait for a signal from the machine. The schedule creates the signal.

Common examples:

  • Monthly inspection of production line equipment
  • Quarterly HVAC filter replacement in a facility
  • Weekly check of vehicle fluid levels in a fleet
  • Annual calibration of measurement instruments

The output of preventive maintenance is predictability. You know when interventions are coming. You can plan resources, order parts in advance, and avoid the chaos of emergency repairs.

The Key Differences

CorrectivePreventive
TriggerFailure has occurredSchedule or usage threshold
Cost timingUnpredictable, often highSpread out, more controlled
DowntimeUnplannedPlanned
Planning requiredLowMedium to high
Best forLow-priority or low-cost assetsCritical equipment, safety systems

The core tradeoff is simple. Corrective maintenance has lower upfront planning cost but higher emergency cost. Preventive maintenance requires consistent scheduling but reduces expensive failures over time.

Neither is always right. The real skill is knowing which applies where.

Why Most Small Teams Struggle With This

The gap between understanding the concepts and actually running a mixed maintenance strategy is almost always the same problem: no system.

Preventive maintenance requires a plan. Which assets get scheduled checks? At what frequency? Who is responsible? What happened last time?

Without a place to track that, it collapses. The schedule lives in someone's head. Or in a spreadsheet that nobody updates. Or in a calendar entry that disappears when the person who made it leaves.

Corrective maintenance then fills the gap, not because it is the right choice, but because it is the only one visible.

This is where structure matters more than software. You do not need a complex CMMS to run preventive maintenance for a small team. You need a consistent record: what asset, what intervention, when, and what was found.

How to Decide Which to Plan First

A practical starting point is to look at your assets through two filters:

What is the consequence of failure?

If failure stops production, creates a safety risk, or requires a long lead time to repair, that asset needs preventive maintenance. If failure is minor and easily fixed in minutes, corrective is often fine.

What is the cost of failure versus the cost of prevention?

Emergency repairs are almost always more expensive than planned ones. Parts ordered urgently cost more. Technician time in crisis mode is less efficient. If a planned inspection costs you 30 minutes and an emergency repair costs half a day, the math makes the decision.

Start with your three to five most critical assets. Build a simple preventive schedule for those. Let everything else stay corrective for now. Expand from there as you have capacity.

Tracking Both Without Overcomplicating It

The practical minimum for running both strategies in a small team:

  • A list of assets with basic information (name, location, criticality)
  • A log of corrective interventions: what happened, when, who fixed it
  • A schedule of preventive checks: what asset, what task, due date, assigned to

That is it. You do not need a full CMMS on day one.

Fixeets lets teams manage exactly this inside Google Sheets. Maintenance interventions are logged with structured fields. Preventive schedules are tracked and visible. Asset history accumulates over time, which means the next time something fails, you can actually look back and see whether it was missed on its last check.

The system does not replace your team's judgment. It just makes sure the work and the history are recorded in a place everyone can access.

If you want to see how it works in practice, the Fixeets maintenance management page has the details.

The Realistic Starting Point

Most small operations should plan preventive maintenance first for critical assets, and use corrective maintenance for everything else, not because corrective is bad, but because preventive planning on low-priority equipment is often waste.

Once the critical assets are covered and the team has a rhythm, expanding preventive coverage is straightforward.

The goal is not to eliminate corrective maintenance. It is to make sure corrective maintenance is a deliberate choice, not just what happens when there is no plan.

If you are considering whether your team needs a dedicated system to support this, our overview of what a CMMS is and whether small teams need one helps you assess the right starting point.

For a practical guide to building that schedule step by step, how to build a preventive maintenance schedule in Google Sheets walks through the full structure from asset register to completion tracking.

Key Takeaways

  • Corrective maintenance fixes problems after they occur; preventive maintenance schedules work before failures happen
  • Corrective-only maintenance is not inherently bad. It is the right approach for low-priority, low-cost assets where failure impact is minimal
  • The real problem arises when corrective maintenance is the default for everything, including critical equipment where failures cause serious disruption
  • A practical starting point is preventive planning for your three to five most critical assets, with corrective maintenance for everything else
  • You do not need a full CMMS to manage this - you need a consistent, structured record of what asset, what intervention, when, and what was found