When to replace your spreadsheet with an internal tool (usually month three)

We like spreadsheets. They are the fastest way to find out what a process actually needs, and we often start a project by watching how the team uses one. The problem is not the spreadsheet. The problem is month three.

What month three looks like

Somebody made a copy to try something. Somebody else downloaded a version to work offline on a trip. The original is still open on the office machine. Each of the three is now slightly different, and the person who built the first formula has left. When a number looks wrong, nobody can say which sheet is right or when it changed.

None of this is anyone’s fault. A spreadsheet has no owner, no history and no rules about who can change what. It was never built to be a system of record; it was built to be a calculator.

Signs you have outgrown the spreadsheet

Build the process in a sheet first, because it is cheap to change while you are still learning what the process is. Move off it when you see any of these:

1. Two people disagree about which copy is current. There is more than one version, and nobody is sure which one the numbers came from.
2. A formula breaks and nobody can fix it. The person who wrote it has moved on, and the sheet is now something everyone is afraid to touch.
3. You type the same thing into two places. The enquiry goes into the sheet and again into the booking system, the invoice template or the accounts.
4. Nobody can say who changed a number, or when. There is no history, so every mistake becomes a conversation instead of a lookup.
5. People need different permissions. The person taking bookings should not be able to change the price the manager set, but in a sheet everyone can edit everything.
6. You need it on the phone, in the field. Staff away from the desk are working from a screenshot or calling the office to ask.

Spreadsheet or database

A spreadsheet mixes data, calculations and layout in one grid, which is why it is so quick to start. A database keeps the data in one place with rules about what each field can hold, and lets several screens show it in different ways. An internal tool is simply a few of those screens, built for the way your team works, on top of one database.

What a small internal tool changes

A small internal tool is not a big piece of software. It is usually a few screens over one database, built to match the sheet the team already understands. What it adds is exactly what the sheet lacks:

• One truth. There is one copy. Everyone sees the same thing at the same time, on the phone or at the desk.
• One owner per field. The person who books cannot accidentally change the price the manager set. Rules that lived in people’s heads live in the tool.
• A log. Every change is recorded with who and when. When a number looks wrong, you look at the history instead of asking the room.
• Connections. The tool can receive the enquiry from the website and send the invoice to the accounting system. A spreadsheet can only be typed into.

After the switch

The sheet does not disappear; it becomes the export, not the source. Anyone who still wants a spreadsheet can download one, but the numbers come from one place. If that sounds like where your business is, this is the kind of custom internal tool for service businesses we build.