When to replace a spreadsheet with a custom app

The signs a spreadsheet has become a liability, two UK failures to learn from, the cheaper options to try first and when a custom app is justified.

Replace a spreadsheet when it has stopped being one person’s working tool and become a system that several people depend on. The usual signs are more than one version in circulation, figures typed across by hand from somewhere else, no record of who changed what, and personal data sitting in a file that gets emailed around.

That doesn’t mean going straight to bespoke software. Most firms should try an off-the-shelf product or a low-code tool first, and commission a custom app only when the process is specific to them and important enough to justify the cost.

  • Spreadsheets are excellent for analysis and one-off work. They are weak as shared systems of record.
  • Two well-documented UK failures, at Public Health England in 2020 and the Police Service of Northern Ireland in 2023, came from using spreadsheets to move and publish data.
  • HMRC’s Making Tax Digital rules already restrict copying and pasting VAT figures between spreadsheets.
  • Try packaged software, then low-code tools such as Airtable, Power Apps or AppSheet, before commissioning a custom build.

Signs your spreadsheet has become a liability

  • Several versions exist. “Jobs FINAL v3 (Sam’s copy)” is a warning in a filename. Nobody is sure which is right.
  • People re-key data. Orders are typed from emails into the sheet, then from the sheet into the accounts package. Every transfer is a chance for an error.
  • There’s no audit trail. A number changed last month and you can’t tell who changed it or why.
  • One person understands it. The formulas were built by someone who has left, or who can never take a fortnight off.
  • It holds personal data. Customer names, addresses, staff records or health details live in a file with no access control beyond who has the link.
  • It’s slow or breaks. The file takes a minute to open, or two people can’t safely edit it at once.
  • The business runs on it. If the file were deleted tomorrow, you couldn’t invoice, schedule or deliver.

One or two of these is normal. Four or five means the spreadsheet is doing a job it wasn’t designed for.

Two UK spreadsheet failures worth learning from

Public Health England, October 2020

Public Health England announced on 4 October 2020 that 15,841 positive Covid-19 cases, with dates between 25 September and 2 October, had been left out of the daily reported figures. Its statement said some files of test results had exceeded the maximum size the loading process could handle. The cases were passed to contact tracers late as a result.

The BBC reported the next day that the cause was the use of Excel’s old XLS file format to pull lab results into the system. Each template could hold only about 65,000 rows, and “when that total was reached, further cases were simply left off”. A current Excel worksheet holds 1,048,576 rows, according to Microsoft, so the limit that caused the loss was a choice of format that nobody had revisited.

The spreadsheet didn’t calculate anything wrongly. It failed without telling anyone, which is the more dangerous way to fail. A database import would normally have thrown an error.

Police Service of Northern Ireland, August 2023

On 8 August 2023 the PSNI published a spreadsheet in response to a freedom of information request. A hidden worksheet in the file held the surnames, initials, ranks and roles of all 9,483 officers and staff. The original data worksheet was still in the file as a hidden tab, and nobody checking it before release noticed.

The Information Commissioner’s Office fined the PSNI £750,000 in October 2024, and said the figure would have been £5.6 million without its reduced approach for public bodies. The ICO said that “simple-to-implement procedures could have prevented the serious breach”.

The PSNI spreadsheet breach in numbers
9,483officers and staff whose details were exposed
£750,000fine issued by the ICO in October 2024
£5.6mwhat the fine would have been without the public sector approach

Source: Information Commissioner's Office, 3 October 2024

You may never answer a freedom of information request. You will send spreadsheets to customers, suppliers and accountants, and hidden tabs, hidden columns and old data in pivot tables travel with the file.

What Making Tax Digital says about spreadsheets

HMRC doesn’t ban spreadsheets. VAT Notice 700/22 says a spreadsheet can be a component of “functional compatible software” when used with other programs. What it restricts is how data moves between the pieces.

Under the notice, transfers of VAT data between software must be “digital links”, made electronically without manual intervention. HMRC says plainly that it does not accept “cut and paste” or “copy and paste” as a digital link, and that manually transferring data between programs is not acceptable. Linked cells between spreadsheets count. So do CSV imports and exports, file uploads and API transfers. Emailing a spreadsheet so that someone can import it into another product also counts.

So if your VAT process involves copying totals from one workbook and pasting them into another, it has been outside the rules for some time. The same direction of travel now applies to income tax. Sole traders and landlords with qualifying income over £50,000 have had to use Making Tax Digital for Income Tax since 6 April 2026. The threshold falls to £30,000 from 6 April 2027 and to £20,000 from 6 April 2028, according to GOV.UK.

Making Tax Digital for Income Tax: qualifying income threshold by start date

Qualifying income from self-employment and property, based on the tax year two years before the start date

Source: GOV.UK, Check if you need to use Making Tax Digital for Income Tax

View data
 Making Tax Digital for Income Tax: qualifying income threshold by start date
April 2026£50,000
April 2027£30,000
April 2028£20,000

This is general information, not tax advice, so check your own position with your accountant.

The middle options before bespoke software

Work through these in order. Each step costs more and fits better.

Before you commission a custom app

Step 1 of 5

Tidy

Move to one shared file with version history, protected formulas and restricted access.

Step 2 of 5

Buy

Try a subscription product built for the job, such as a CRM or scheduling tool.

Step 3 of 5

Database

Use a spreadsheet-like database such as Airtable that stores records properly.

Step 4 of 5

Low-code

Build a simple app in Power Apps or AppSheet on top of your existing data.

Step 5 of 5

Custom

Commission a bespoke app when you hit a limit you can name.

  1. Tidy the spreadsheet. One shared file with version history, protected formula cells and restricted access solves the version problem for nothing.
  2. Buy software built for the job. For common processes such as CRM, job scheduling, stock, bookings and accounts, a subscription product will usually beat anything you’d build. Our post on whether to build or buy goes through that decision.
  3. Use a database with a friendly face. Airtable looks like a spreadsheet but stores records properly, with forms, views and permissions.
  4. Build a low-code app. Microsoft Power Apps suits firms already on Microsoft 365. Google AppSheet can sit on top of an existing Google Sheet and give staff a phone-friendly app for entering data. Both let a capable non-developer build something useful.

Low-code tools have limits. Costs can climb as more people use them, complicated logic gets awkward, and you can end up with the same single-person dependency you had with the spreadsheet. They are still the right answer more often than agencies like to admit.

When a custom app with AI features is justified

We’d look for most of these before recommending a bespoke build.

  • The process is specific to how you work, and it’s part of why customers choose you.
  • You’ve tried packaged or low-code tools and hit a wall you can name.
  • Several systems need to exchange data automatically, and the re-keying between them is costing real hours.
  • Enough people use it, often enough, that small time savings add up.
  • There’s a compliance reason: you need proper access control, an audit trail or reliable deletion of personal data.

AI earns a place when the work involves reading and writing as well as arithmetic. Typical examples are pulling figures out of supplier invoices or emailed orders so nobody types them in, letting a manager ask a question of the data in plain English, drafting quotes or reports from the records, and flagging entries that look wrong. These are the tasks spreadsheets are worst at and people find most tedious.

Two cautions. AI features have a running cost that scales with use, and any tool that sends customer or staff data to an AI model needs the checks in our UK GDPR checklist for AI agents. It also helps to have agreed rules for staff, which is what an AI policy for a small team is for.

A custom internal app doesn’t have to be large. Many are web apps with a handful of screens, and our post on what drives app costs in the UK shows how to estimate one.

Common questions

Is Google Sheets or Excel online safer than a file on a laptop?

It fixes versions and gives you an edit history, which is a real improvement. It doesn’t add validation, proper permissions per record or a reliable audit trail, and a share link can still expose everything in the file.

Should we get rid of spreadsheets altogether?

No. They remain the best tool for analysis, modelling and one-off questions. The aim is to stop using them as the place where the master copy of your data lives. A good system exports to a spreadsheet whenever you want to explore the numbers.

How do we move years of data out of a spreadsheet?

Slowly and with checks. Clean the data first, import it, then run the old and new side by side for a few weeks and compare totals before you switch. Our CRM data migration checklist works for most systems, not only CRMs.

What if the spreadsheet is really a customer list?

Then the answer is usually a CRM rather than a custom app. We list the warning signs in signs your business has outgrown spreadsheets and needs a CRM.

If you’re weighing this up for a process of your own, our internal tools and portals page explains how we scope them.

Sources

→Keep reading

Related guides.

All insights
Software reviews

Microsoft 365 or Google Workspace: which suits a UK business?

Microsoft 365 and Google Workspace compared for UK businesses: 2026 prices excluding VAT, storage, desktop apps, Copilot and Gemini, and who each suits. Read
Software reviews

Xero, QuickBooks or FreeAgent: UK accounting software compared

Xero, QuickBooks and FreeAgent compared for UK businesses: 2026 prices excluding VAT, plan limits, Making Tax Digital for Income Tax and who each suits. Read
Software reviews

Notion, ClickUp or monday.com: which suits a UK small team?

Notion, ClickUp and monday.com compared for UK teams: current prices in pounds, free plan limits, AI features and the honest downsides of each tool. Read

→Get in touch

Got a question? Ask us.

Tell us what you’re trying to do. Every project starts with a free audit: someone who does the work replies with a few ideas, an honest view and a written plan with prices.

What happens next

  1. 1
    You send the formIt takes about two minutes.
  2. 2
    We do our homeworkWe look at your website and your market.
  3. 3
    You get a short planWhat we’d do first, with prices. Yours to keep.
  • Free, with no obligation
  • We won’t add you to a mailing list

We only use your details to reply to you. See our privacy policy.