Skip to content
A glass spreadsheet grid turning into a phone app interface along a stream of light.

Web apps

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.

Written by TerapixelUpdated 7 min read

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.

SpreadsheetSmall web app
Set upMinutesDays to weeks
Cost to startLittle or noneFrom £499 with us
Several editorsMessyDesigned for it
Outside usersRiskyControlled access
Rules and checksEasy to bypassBuilt in
NotificationsManualAutomatic
FlexibilityVery highSet by the app
Dependence on one personHighLower

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.

  1. Pick one job. The one that costs you the most time or causes the most errors.
  2. Write what goes in and what comes out. Who enters what, and what do they need back?
  3. List the columns that matter. Ignore the ones nobody uses.
  4. List the rules. Required fields, limits, who may see what.
  5. Decide the first release. The smallest version that removes the pain.
  6. 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.

  • web app
  • spreadsheet
  • custom software
  • small business tools
  • mini web apps

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.

Order a websiteTalk to us

Section 2: More notes

Keep reading.

All the notes

Websites built like products. Start yours.

Scattered squares travelling into place to form the Terapixel mark