Spreadsheet vs Database: the moment the spreadsheet stops running your business

A spreadsheet is a document: a grid people take turns editing, built for calculating and analysing a flat list. A database is a set of linked records that many people update at the same time, with rules that keep the data correct. A business outgrows its spreadsheet the moment several people need the same fact to be true at once.

What is the difference between a spreadsheet and a database?

The clearest one-line answer comes from Microsoft, which makes both kinds of tool. Its own guidance on choosing between Access and Excel says: "users of an Access database collaborate on a set of data, and users of an Excel workbook collaborate on a document."

That is the whole difference. A document has one current copy that somebody is holding. A set of data has one record per thing, and everyone works on the same record.

Question	Spreadsheet	Database
What is it?	A document made of cells	A set of linked records
Where does a customer live?	In every row someone typed the name into	In one customer record that orders, jobs and invoices point to
Can several people work at once?	Works best when people take turns	Yes, each person edits a different record
What stops a bad entry?	Mostly the care of the person typing	Rules: an invoice cannot exist without a customer
What is it best at?	Calculations, models, one-off analysis	Tracking work that changes every day

When does Microsoft itself say to stop using Excel?

Microsoft's guidance asks one question first: is the data flat or relational? Data "that you can efficiently contain in a single table or worksheet" is flat. A simple customer list with one address and one contact person each is flat, and Microsoft says Excel "might be the better choice" for it.

The moment a customer has two addresses, several contact people, or a history of orders, the data is relational. One customer now relates to many other things. Microsoft's advice is to use a database when you "anticipate many people working in the database and you want robust options that safely handle updates to your data".

The same page is plain about sharing. A workbook kept in a shared network folder can be edited by "only one user" at a time. Everyone else can look, but cannot change anything until that person closes it. Most businesses solve that by saving a copy. That copy is where the trouble starts.

What happens when a spreadsheet is used as a system?

Six years ago this week, Public Health England found that 15,841 positive COVID-19 cases recorded between 25 September and 2 October 2020 had been left out of the daily figures. The fault was identified overnight on Friday 2 October 2020. Its official statement says "some files containing positive test results exceeded the maximum file size" of the process that loaded them into central systems.

The BBC reported on 5 October 2020 that the files were in an old spreadsheet format, XLS, which holds about 65,000 rows per sheet. When a sheet was full, further cases were left off. For scale, Microsoft lists the limit of a current Excel worksheet as 1,048,576 rows by 16,384 columns.

The spreadsheet did not fail. It did exactly what a document does. It was being used as a pipeline between systems, a job it was never built for, and nothing in a spreadsheet tells you when you have crossed that line.

A small business is unlikely to hit a row limit. It hits the same wall in a quieter way: a filter left on, a sort that moved one column and not the others, a formula overwritten with a typed number, a copy saved to someone's desktop. The file still opens. It just stops being true.

What are the signs a business has outgrown its spreadsheet?

1. Somebody asks "which version is the latest?" If the question can be asked, there is more than one answer.
2. The same customer is typed into three sheets. The quote sheet, the job sheet and the invoice sheet each hold their own copy, and they drift apart. We covered that in where your team types the same fact twice.
3. One person understands the file. When they are on leave, nobody dares touch it.
4. People wait for the file. Someone has it open, so the update goes onto a sticky note or a WhatsApp message instead.
5. The totals do not match. The sheet says one thing, the invoices say another, and the owner spends an evening working out which is right.
6. The sheet has become a to-do list. Colours mean statuses, comments mean instructions, and work is being managed inside a tool built for sums.

Two or more of these and the spreadsheet is no longer recording the business. It is running it, without any of the protections a system has.

Is an Excel alternative the answer?

People who feel this pain often search for a different spreadsheet. Google's own suggestions for "excel alternatives" on 2 October 2026 are "free", "for mac", "for windows" and "for linux": the same grid at a different price or on a different machine.

That does not fix the problem, because the problem is not the brand of the grid. Any spreadsheet is still a document. Moving from one to another moves the same copies, the same retyping and the same "which version" question into a new file.

When is a spreadsheet still the right tool?

Often. Microsoft's list is a fair one: use a spreadsheet when the data is flat and mostly numbers, and when you "frequently run calculations and statistical comparisons". A budget, a pricing model, a one-off analysis of last quarter's sales, a quick list only you maintain. Those belong in a spreadsheet and will for a long time.

The rule of thumb: a spreadsheet is for thinking about the business. It is not for holding the business.

How does the Business OS remove the problem?

The Business Operating System is one system built around how your work actually moves: lead, job, invoice, payment and follow-up on one screen. Underneath it is a database, but nobody on your team needs to know that word. What they see is this:

1. Every customer, job and invoice is captured once. The details taken at the first enquiry become the record. The quote, the job card and the invoice all read from it, so nothing is retyped.
2. One record, many views. The owner sees a dashboard, the technician sees today's jobs, the admin person sees what is unpaid. Three screens, one set of facts.
3. Rules replace carefulness. A job cannot be invoiced without a customer. A status comes from a fixed list, not from a cell colour. The system refuses the mistake instead of someone finding it at month end.
4. Everyone works at once. Nobody waits for a file to close, and nobody saves a copy, because there is no file.
5. Dates do the chasing. A follow-up date or a due date on the record triggers the reminder. It does not depend on someone scrolling to the right row.
6. The spreadsheet keeps the job it is good at. When you want to analyse the numbers, they export cleanly, from one source.

We do not start by building. We map how a lead becomes an invoice in your business today, with the people who do the work, then build the system around that map and hand your team the keys. More on the idea in what a business operating system is and what a business management system must hold.

What changes for the owner?

Time, first. The hours spent reconciling versions, chasing the person who has the file, and checking a total against the invoices come back. One record, updated once, and everyone sees the same answer.

Then trust. When a customer phones, whoever answers sees the same history. When you want to know what is outstanding, you look, you do not ask. And the business stops depending on the one person who understands the formulas. If the records themselves need to be kept for a set period, the rules for that are in our guide to document management systems.

Frequently Asked Questions

What is the main difference between a spreadsheet and a database?

A spreadsheet is a document of cells that people take turns editing. A database is a set of linked records that many people update at once, with rules that keep entries valid. One is for analysing, the other for tracking.

When should a small business move from a spreadsheet to a database?

When more than one person needs to update the same information, when the same customer is typed into several sheets, or when somebody asks which version is the latest. Those are signs the data has become relational.

Is Excel a database?

No. Microsoft describes Excel as optimised for data analysis and calculation, not as a database management system. It stores flat lists well, but it cannot enforce links between customers, orders and invoices the way a database does.

Do we have to stop using spreadsheets completely?

No. Spreadsheets remain the right tool for budgets, pricing models and one-off analysis. The change is that the live records of customers, jobs and invoices sit in one system, and the spreadsheet reads from it.

Find out what your spreadsheets are costing you

If your business runs on a handful of spreadsheets and the person who understands them, a free Business Autopsy maps where the same facts are being typed twice and what to fix first. Or see how the Business Operating System works, or book a discovery call.

Sources: Microsoft Support, "Using Access or Excel to manage your data" and "Excel specifications and limits", both read 2 October 2026. Public Health England, "PHE statement on delayed reporting of COVID-19 cases", gov.uk, 4 October 2020, read 2 October 2026. BBC News, "Excel: Why using Microsoft's tool caused Covid-19 results to be lost", 5 October 2020. Google autosuggest for "excel alternatives", read 2 October 2026.