Excel is not a business management system. How to tell your company has outgrown it, and what to replace it with

Excel is the best calculation tool most companies have. A financial model, a margin analysis, a pricing simulation or a one-off report for the management board – nothing can replace it here.

The trouble starts when a spreadsheet becomes the place where many people work on the same process. Excel then has to keep track of deadlines, permissions, decision history and the order of steps, and it was not designed for that. The table below sorts out the typical uses.

None of the signs below is conclusive on its own. But if you recognise three or more, your spreadsheet is most likely costing you more than the budget shows.

It is also worth honestly separating problems with Excel from problems with how the file is stored. In Microsoft 365 with OneDrive or SharePoint, several people can work in a file at the same time, and the version history lets you undo changes. These features cannot, however, replace notifications, an approval sequence or permissions for individual rows.

Almost every company starts with a customer spreadsheet: name, phone, email, status. With a few dozen customers and two salespeople, that is enough. The problem appears when there are more customers and more people.

Take a hypothetical wholesaler with five salespeople. Each has their own file. A customer calls about a quote and reaches a different salesperson, who does not know what was agreed a week earlier. The customer repeats everything from the beginning – or calls a competitor.

A CRM, or customer relationship management system, solves this simply. Every contact, quote and agreement is linked to the customer in one place. The system sends reminders about the next step, and the sales director can see all open sales opportunities without asking for reports.

In many companies a quote is created by copying the previous one and changing a few items. The price list is also in Excel, and each salesperson has a version from a different month. One item left unchanged is enough for the company to fulfil an order at a lower margin than it expected.

Such mistakes are rarely visible in the results, because they disappear into the average. You can estimate them, though. The formula: number of quotes per year × percentage of quotes with a pricing error × average margin lost on such a quote.

A hypothetical example: a company sends 400 quotes a year, 2% of them contain an error, and each error costs an average of PLN 3,000 in margin. That is 400 × 0.02 = 8 quotes and 8 × PLN 3,000 = PLN 24,000 a year. Plug in your own figures – you can check the error rate by comparing a few dozen recent quotes with the current price list.

The solution is a single price list in a single place and a quote template that takes its prices from it. This can be a quote configurator or a quoting module in the CRM.

A task list in a spreadsheet works as long as the project is small. Once there are several dozen tasks and several people, the statuses stop being up to date. A task marked “in progress” sits there for three weeks because nobody remembered to update it.

The management board then has a second problem. To see the status of all projects, someone has to open a dozen or so files with different layouts. A project management tool shows the same information in a single view, with deadlines and the people responsible.

Approvals are similar. An “invoices to approve” spreadsheet will not send a reminder, will not pass the case to a deputy during a holiday and will not record who approved the amount. A document workflow in SharePoint with Power Automate, the automation tool in Microsoft 365, does all this automatically.

The biggest cost is the time spent maintaining files: merging versions, retyping data between spreadsheets, fixing formulas and looking for up-to-date information. Ask your team how many hours a week this takes, and check it on a sample over two weeks.

The formula: number of people × hours per week spent maintaining files × number of working weeks per year × hourly labour cost. A hypothetical example: 6 people each lose 4 hours a week over 46 weeks, at a cost of PLN 70 an hour. That is 6 × 4 × 46 = 1,104 hours, or PLN 77,280 a year.

Add to this the cost of errors in quotes, calculated earlier. Only then compare the total with the cost of licences and implementing new tools. Remember that not all the time saved will turn into other work, so to be cautious, count only part of it in your calculation.

The most common mistake is trying to replace everything at once. The team then has to learn several tools at the same time and easily slips back to the old files. It is safer to move processes one by one, following the steps below.

Resistance from the team usually comes not from a love of Excel but from habit. So show what each individual employee gains: no more asking for the latest version, reminders arrive automatically, and the customer’s history is in one place.

Not every company needs a new system. If one or two people run a process, the data changes rarely and a mistake does not cost much, a well-built spreadsheet in Microsoft 365 is a sensible choice.

A spreadsheet is also enough when a process is still taking shape. It is better to refine it in Excel for a few months and only then move it into a system. Otherwise you risk locking a way of working that is about to change into a new tool.