Spreadsheet or custom web app: how to decide

By Shenzee Tech · Published 14 October 2026 · 2 min read

Almost every business starts in a spreadsheet, and that is usually the right call. The question is when the spreadsheet stops being the cheapest way to run the work.

Where spreadsheets shine

• One person or a very small team uses the file.
• The process is still changing and you are working out what you need.
• The volume is small enough that mistakes are easy to spot.
• You need a quick answer today and not a system next quarter.

Signs you have outgrown it

• Several people edit the file and you have copies named final, final2 and final-new.
• Different people need to see different information, and some of it should not be shared.
• You keep fixing the same formula errors or broken links between sheets.
• You rely on one person who understands how the workbook works.
• You need approvals, reminders or an audit trail of who changed what.
• Customers or staff need to use it from their phones.
• The file is slow, large, or crashes.

What a custom web app gives you

• One shared version of the truth, with user accounts and permissions.
• Rules built in, so required fields and calculations cannot be skipped.
• Automatic reminders, notifications and approvals.
• Access from any device, with a record of changes.
• Reports and dashboards that update from live data.

What it costs you

A web app needs scoping, building, testing and some ongoing care, so it costs more at the start than a spreadsheet. It pays off when the time lost to errors, rework and waiting is larger than the cost of the system.

A way to decide

1. List the three most annoying things about the current spreadsheet.
2. Write down roughly how many hours a week they cost.
3. Ask whether a better-built spreadsheet or a small automation would fix them.
4. If the problems are about people, permissions, approvals or access, scope a web app.
5. Start with the smallest version that solves the worst problem, then grow it.

A good developer will tell you honestly when a spreadsheet or a simple script is enough. Start with a written scope so both sides agree what is being built and what it will cost.