
Spreadsheet vs Web App: When a Small Business Should Switch
Spreadsheets are brilliant until they are not. Seven signs it is time for a small web app, where spreadsheets still win, and how to scope a first version.
Spreadsheet vs web app: keep the spreadsheet while one or two people use it and mistakes are cheap. Switch to a small web app when several people edit the same data, outsiders need to see part of it, statuses should trigger actions, or only one person understands the file.
A web app is a website that does a job, such as taking bookings or tracking jobs, rather than only showing information. It keeps the same information in one place with forms, permissions and rules built in. It does not have to be big: a first version can do one job well.
Where are spreadsheets still the right tool?
For calculations, personal lists and early experiments. Be fair to the spreadsheet: it is flexible, familiar and quick. It is a good choice for:
- Calculations and one-off analysis.
- A personal list or tracker for one person.
- Planning and budgeting, where the numbers change shape often.
- Early experiments, before you know what you need.
If your sheet works and nobody is struggling, leave it alone.
What are the seven signs it is time to switch?
Several editors, outside users, statuses that should act, repeated typing, a fragile file, missing rules and customers who could help themselves. Each is explained below.
1. Several people edit the same sheet
Overwritten cells, conflicting filters and copies saved as "final_v3" are the first symptoms. A web app keeps one record and tracks who changed it.
2. Outsiders need access
Sharing a whole internal sheet with a customer or supplier shows them more than they should see. A web app can show each person only their own part.
3. Statuses should do something
A "Pending" cell that someone changes to "Approved" does nothing by itself. A web app can send an email, assign a task or update a record when the status changes.
4. You repeat the same typing
If the same information is copied from an email to a sheet to a quote, a form can capture it once and fill in the rest.
5. The sheet is fragile
Broken formulas, hidden columns and macros that only one person understands are a risk. If that person leaves, so does your knowledge.
6. You need rules and checks
Required fields, valid dates, no double bookings. Spreadsheets can approximate these, but they are easy to bypass.
7. Customers should do the work
A booking form, a quote calculator or a status page lets customers help themselves, which saves you phone calls.
Spreadsheet vs web app: which suits your business?
It depends on how many people use the data and how many rules it needs. This table sets the two side by side.
| Spreadsheet | Small web app | |
|---|---|---|
| Set up | Minutes | Days to weeks |
| Cost to start | Little or none | From £499 with us |
| Several editors | Messy | Designed for it |
| Outside users | Risky | Controlled access |
| Rules and checks | Easy to bypass | Built in |
| Notifications | Manual | Automatic |
| Flexibility | Very high | Set by the app |
| Dependence on one person | High | Lower |
What is a small web app, in practice?
A website that does a job and keeps its data in a database. A database is an organised store of records, such as customers, jobs or bookings, that a program can search and update. A web app might be a calculator that gives a price range, a booking form that checks availability, or a job tracker with a status each customer can see. It runs in the browser, on a phone or a computer.
Some tools are small enough to count as mini web apps. See mini web app ideas for small businesses for examples. Terapixel is a web design studio, and our mini web apps service page explains how we build them.
How do you scope a first version?
Pick one job and build the smallest version that removes the pain. You can add features later, and a tight first version is cheaper, quicker and easier to test.
- Pick one job. The one that costs you the most time or causes the most errors.
- Write what goes in and what comes out. Who enters what, and what do they need back?
- List the columns that matter. Ignore the ones nobody uses.
- List the rules. Required fields, limits, who may see what.
- Decide the first release. The smallest version that removes the pain.
- Keep the spreadsheet as a fallback until the app has proved itself.
What other routes should you consider?
A better spreadsheet, an off-the-shelf tool, a no-code platform or a custom web app.
- A better spreadsheet. Clean up, protect cells, add forms.
- An off-the-shelf tool. For common jobs such as bookings or invoicing, a ready-made product may fit.
- A no-code platform. Useful for simple data and forms, though flexibility and long term cost vary.
- A custom web app. Best when your process is specific and you want it to work your way.
Choose by fit. If a ready-made tool does most of what you need, use it. If you work in a way that no tool matches, custom is worth a look. Our website development page covers the wider build if the app needs a public site around it.
What should you ask before you commit?
Ask who owns the app and the data, and how you would leave. These questions apply to any supplier.
- Who owns the app and the data?
- Can I export my data at any time?
- Who fixes it if something breaks?
- What does it cost to run each month?
- How do I add features later?
If the app will hold customers' details, data protection rules apply, and the ICO publishes advice for small organisations. The NCSC's cyber security guidance for small organisations covers backups and protecting devices and accounts, which matter just as much for a business tool.
Our website quote checklist has more questions that apply here too. Custom web apps start from £499 with us, and our about page explains who we are.
How do you tidy a spreadsheet before you move?
Give every column a clear name and put one kind of thing in each column. Whatever you decide, a cleaner sheet helps. Dates should all be dates and prices all numbers. Remove duplicate rows and blank columns. Keep one row per job or customer, rather than several lines scribbled in one cell. A tidy sheet is easier to run in the meantime, and if you do build an app, tidy data moves across with far less fuss and fewer surprises.
Frequently asked questions
Is a web app better than a spreadsheet?
Not always. A web app is better for shared, rule-based work: several editors, outside users, automatic emails and checks that are harder to bypass. A spreadsheet is better for flexible calculation, quick experiments and personal lists. Choose by the job, and if your sheet works and nobody is struggling, there is no need to change it.
How much does a custom web app cost?
It depends on what it needs to do, and the size of the first version is the biggest factor. Terapixel's custom web apps start from £499. A tight first version that does one job costs less and is quicker to test than an app that tries to replace the whole spreadsheet at once, and you can add features later.
Can a web app import my spreadsheet data?
Often yes, though it depends on how tidy the data is. Clean columns with one kind of thing in each, such as dates in a date column and prices as numbers, move across with far fewer surprises. Tidying your sheet first is worthwhile whatever you decide, because it also makes the sheet easier to run in the meantime.
Do I need a mobile app or a web app?
Most small business tools work well as a web app, which runs in the browser on any phone or computer with nothing to install. A native mobile app is one you download from an app store, and it is rarely needed for a first version. Start with the web app and see whether anyone asks for more.
What should I ask before paying for a web app?
Ask who owns the app and the data, whether you can export your data at any time, who fixes it if something breaks, what it costs to run each month and how new features are added. Written answers protect you if you later want to change supplier, and they make quotes from different suppliers comparable.
Next step
If a spreadsheet is slowing you down, describe it to us and we will tell you whether an app is worth it. Get in touch or see the mini web apps service.
Was this note useful?
Pass it on
Know someone planning a website? Send them this note.
Ready when you are.
See the price for a website in pounds before you commit, or tell us what you need and we will reply.
Section 2: More notes
Keep reading.

Web apps
Mini Web App Ideas for Small Businesses: Ten Small Tools That Save Time
Price calculators, booking forms, quote builders, product finders and more. Ten small web tools a small business can use, and how to pick the first.

Content and social
Blog Topic Ideas for Small Business: How to Find Questions Worth Answering
Where to find topics your customers really search for, free ways to check them, eight post types that work and a list of ideas to steal.

Running your site
Website Maintenance Checklist for Small Businesses: Weekly, Monthly, Yearly
A light routine that keeps a small business website working, accurate and secure after launch, split into jobs for a week, a month and a year.