When is it time to replace spreadsheets with a custom web app?

Nearly every internal tool we have built started life as a spreadsheet. That is a good thing: a spreadsheet proves the process works before anyone writes code. But there is a point where the spreadsheet stops helping and starts costing you.

Six signs you have outgrown it

1. Version confusion. "Final_v3_REAL.xlsx" exists, and people argue about which copy is right.
2. Copy-paste between systems. Someone spends hours a week moving data from the sheet into accounting, email or a CRM.
3. Different people need different views. Sales should see their deals, managers should see everything, customers should see only their own records.
4. Mistakes are expensive. A wrong formula or a deleted row has already cost you money or a client.
5. You need an audit trail. Who changed this price, and when?
6. The sheet is slow. Thousands of rows, dozens of tabs and lookups that take seconds to recalculate.

Options before writing code

A custom application is not always the answer. Consider, in order:

• An existing SaaS product built for your industry — often cheaper than building.
• No-code tools such as Airtable or SharePoint lists for simple forms and approvals.
• A custom web app when your process is a competitive advantage, involves customers directly, or needs integrations off-the-shelf tools can't do.

What a good first version looks like

Keep the first release small: the five to ten screens people use every day, sign-in with roles, an admin area, data export, and one integration — usually accounting. Everything else waits for version two, informed by how people actually use version one.

The goal of version one is not to replace every tab of the spreadsheet. It is to replace the parts that hurt.

Protect yourself as the buyer

• Get a written specification and a fixed price before development starts.
• Make sure you own the source code and the hosting accounts.
• Ask for a bug-fix period after launch and documentation for your team.

Our Discovery & Technical Specification package produces the specification, wireframes and a fixed-price proposal, so you know exactly what you are buying.