5 Signs Your Team Has Outgrown Spreadsheets

A spreadsheet is a fine way to track maintenance. It is free, everybody knows how to use one, and for a long stretch it does exactly what you need. Plenty of small facilities run on one for years without a real problem.

What makes it tricky is that a spreadsheet does not fail all at once. It never throws an error or shows you a warning. It just slowly stops being the thing holding your operation together, and starts being one more thing your team has to keep up with. The work still gets done. The sheet just stops reflecting it.

Here are five specific signs that shift has already happened, drawn from what actually goes wrong in small maintenance departments.

1. Somebody has to be the spreadsheet person

There is one person who knows how the sheet is organized. They know that column J is the one that matters, that the tab named "Old" is actually current, and that the filter has to be cleared before anybody sorts anything or the rows come apart.

When that person is on vacation, the sheet stops getting updated. When they are out sick, somebody sorts a column without selecting the whole range and now the dates belong to the wrong rooms. Nobody notices for a week.

The tell is not that the sheet is complicated. It is that keeping it correct has quietly become somebody's job, on top of the job they were hired to do. When maintaining the record costs real hours every week, the record has started charging rent.

2. Your techs are not the ones filling it in

This is the most common sign, and the most telling. The spreadsheet lives on a computer in an office. Your techs are in a mechanical room, on a ladder, or in a resident's apartment. They are not walking back to the office to type a row.

So what actually happens is that the tech tells the supervisor what got done, and the supervisor types it in later. Sometimes a day later. Sometimes from memory, or from a note scrawled on the back of a receipt.

Every one of those handoffs loses detail. "Fixed the AC in 214" is what makes it into the sheet. What the tech actually did was replace a capacitor, notice the drain line was starting to clog, and make a mental note to come back to it. The mental note dies at the end of the shift.

If the person doing the work is not the person recording it, the record will always be thinner than the work.

3. You cannot answer a simple question quickly

Try this one. Without opening anything, answer these:

• How many work orders are open right now?
• Which ones are overdue?
• What has this specific rooftop unit needed in the past two years?
• What did we do the last three times this resident called about the same thing?

On a healthy system, all four take under a minute. On a spreadsheet that has been running for a couple of years, the first two require filtering and some judgment about which rows are still current. The last two require reading.

The asset history question is the one that hurts most. A spreadsheet is organized by date, because that is the order things get typed in. It is not organized by equipment. So finding everything that ever happened to one rooftop unit means scanning for the times somebody happened to write "RTU 3" the same way, which they did not, because sometimes it is "rooftop 3" and sometimes it is "AC unit, roof."

4. There are two versions and nobody knows which is real

It starts innocently. Somebody makes a copy before a big edit, just to be safe. Somebody else emails a version to the administrator for a budget meeting. A third person keeps a personal tracking sheet because the main one does not have the column they need.

Now there are three, and they disagree. Not dramatically, just enough. One has last week's completions, one has the updated due dates, one has notes nobody else has seen.

Shared cloud files help with this, but they do not solve it, because the pressure that created the copies is still there. People make their own version when the main one does not fit how they work. That is a signal worth listening to.

The moment somebody in your building asks "is this the current one," you have lost the single source of truth, which was the entire reason to keep a sheet.

5. A surveyor asks for something and your stomach drops

This is the sign that turns an annoyance into a risk.

A state surveyor asks for the last two years of fire drill documentation, or the monthly generator test records, or proof that hot water temperatures have been checked at resident fixtures. You know the work happened. You were there for most of it.

But the drills are in a binder, the generator reports are PDFs the vendor emailed, the water temps are in the spreadsheet if somebody remembered to add them, and the last six months of everything are in a tech's notebook in the shop.

Most facilities that get cited did the work. They could not prove it fast enough, in one place, with a name and a date attached. That gap is not a paperwork problem. It is what the entire inspection is measuring.

If you want the specifics on what surveyors actually ask for in Alabama, we wrote that up separately in the ADPH survey readiness guide.

What to do if you recognized more than two of these

First, do not panic and do not rush out to buy something. Recognizing two or three of these does not mean your operation is broken. It means the tool stopped fitting, which happens to every growing team eventually.

Second, be honest about which problem you actually have. If the issue is that techs cannot enter work from the field, no amount of reorganizing the spreadsheet will fix it, because the problem is the location of the record, not its layout. If the issue is that you cannot pull asset history, the problem is structure. Naming it correctly saves you from solving the wrong thing.

Third, whatever you move to, the bar is simple. The person doing the work should be able to record it from where they are standing, in under a minute, and anyone who needs it later should be able to find it without asking a colleague. A system that clears that bar will hold. One that does not will slowly turn back into three spreadsheets and a notebook.

The spreadsheet was not a mistake. It carried you to the point where it stopped working, which is more than most tools do.