Business software

7 signs your company has outgrown Excel

Quentin Debray
Written by Quentin Debray
Published 23 September 2026 · 9 min read
Article updated 25 September 2026

In brief

Three files for the same customer, a macro nobody dares open any more, a colleague who has become indispensable. Seven concrete situations to tell whether your spreadsheet is now carrying more weight than it can bear.

Monday, 8:40 am. You open the tracking file to prepare the 10 o'clock meeting. The margin column does not add up. You call the admin assistant, who exported the figures from the invoicing software on Friday evening, then pasted the result into the "consolidation" tab. Except that in the meantime, two orders have changed. You redo the export. You paste again. It is 9:25. This scene, repeated every week, is the most ordinary sign that a company has outgrown Excel: the spreadsheet no longer describes the business, it runs behind it.

This article is not an argument against the spreadsheet. Excel is probably the most profitable tool ever installed in a small business. It starts in three seconds, it asks nobody's permission, and it adapts to any trade. Plenty of companies with 10 to 80 employees run very well on a few well-kept workbooks, and that is perfectly legitimate. The question is not whether Excel is good. It is whether, in your organisation, it now carries more weight than it can bear.

Here are seven concrete situations. They come up in meetings, almost word for word. Read them as a grid, not as an indictment.

The 7 signs your company has outgrown Excel

1. The same data exists in three files, with three spellings

The customer is called "Dupont & Fils" in the sales file, "Dupont et fils" in production tracking, "DUPONT SARL" in the accounting export. Nobody did their job badly. Each department created its file when it needed one, and nobody ever decided who held the reference version.

The cost is not visible straight away. It appears when you want to answer a simple question: how much has this customer brought us this year, across all jobs? You then have to reconcile the three lists by hand, settle the duplicates, and cross your fingers. A manual consolidation that takes half a day a month adds up to six days a year to get a figure you should be able to read in three clicks.

2. Nobody knows which version is the right one

"Order_tracking_v3_final_DEF_ok_reviewed_MB.xlsx". You have that file. Everyone has it. And the day two people work on it the same afternoon, one of the two versions disappears, usually without anyone noticing for two weeks.

Online sharing has eased the problem, not removed it. As soon as a file leaves as an attachment to be annotated, commented on or completed by a third party, the chain breaks. This is not a discipline problem. It is the normal consequence of a tool designed for one author and used by a team.

3. A colleague has become indispensable because they "know how it works"

This is the most serious sign, and the hardest to admit. One person built the planning file, or the margin file, or the hours file. They have improved it for four years. They know the hidden tabs, the exceptions, row 412 that must never be sorted.

That person is valuable. The problem is not them, it is what happens the day they go on maternity leave, change role or leave the company. Unwritten knowledge becomes an operational dependency. And that dependency shows up on no dashboard, until it costs a great deal.

4. The same copy-paste comes back every week

Every Monday, someone exports, pastes, formats, checks. Every Friday, someone starts again. Nobody complains: it has become routine, and that routine holds the company up.

A gesture repeated on a fixed date is a strong signal. It means two tools do not talk to each other, and a human serves as the bridge between them. The bridge works very well, as long as the person is there, as long as the export format does not change, as long as the volume stays manageable. Three conditions, three weaknesses.

5. The same information is re-entered at every step

The customer asks for a quote. It is entered. The quote is accepted: it is re-entered for the order. The order is delivered: it is re-entered for the invoice. The invoice goes out: it is re-entered for payment tracking. Then the accountant asks for a summary, and it is re-entered again.

Each re-entry is a chance for a keying error. A reversed reference, a wrongly carried quantity, a forgotten discount. These errors cost almost nothing individually. They cost a lot cumulatively: credit notes, customer disputes, reconciliation time, and a diffuse distrust of internal figures. The day the owner starts saying "I prefer to recalculate it myself", the company is already paying the full price.

6. An Excel file was created to work around software you are paying for

This one is revealing. You have an ERP, invoicing software or a sales management tool, under licence, with annual maintenance. And alongside it, a workbook that redoes the job tracking, because the software does not handle your deposits, your lots, your volume pricing or the way you count hours.

In other words, you pay twice: the subscription on one side, human time on the other. The workaround spreadsheet is often the best free diagnosis there is. Look at it closely. It contains exactly what is specific to your business and what standard software never managed to absorb. That is where the trade-off described in build or buy software is played out.

7. Macros multiply and nobody dares open them

At first, a macro to save ten clicks. Then a second to generate the monthly summary. Then a third, written by a gifted intern, that works but that nobody can read.

A workbook with macros is no longer a spreadsheet. It is software. Software without documentation, without tests, without version backups, and without anyone to maintain it. The day an office update breaks a macro, the company stops while it works out why. That file has become critical, although no decision was ever made to give it that role.

How many signs before you move?

One or two signs is not a project. It is a file to clean up, a naming convention to set, a shared space to tidy. Many companies would gain more from seriously structuring three workbooks than from launching an IT project.

Three or four signs is the time for an inventory. Often, a well-chosen market tool covers 80% of the need. A sales management package, a site-tracking tool, an invoicing solution suited to your sector. It is cheaper, faster, and perfectly sufficient if your business does not stray from the beaten track. Our overview of what management software is helps frame this sorting.

Five signs or more, especially if signs 3, 6 and 7 are present, change the nature of the problem. You no longer have a question about office tooling. You have a business running on an undocumented mechanism, dependent on one or two people, and impossible to grow without increasing the manual work in the same proportion.

Number of signsWhat it meansUseful reflex
1 to 2Normal disorder of growthTidy, name, centralise the files
3 to 4The spreadsheet is doing a software's jobLook for a market tool suited to the business
5 and moreOperational dependency has set inMap first, then choose

What a critical Excel file really costs

The cost of a spreadsheet at the end of its tether falls under three headings, and none appears in the accounts.

Time, first. Not keying time, which would exist anyway. The time spent reconciling, checking, correcting. The time nobody bills and everyone spends in the evening.

Reliability, next. When two sources give two figures, the decision waits. A quote goes out two days late, a customer follow-up slips through, stock is ordered twice. These are not disasters. They are permanent friction.

Risk, finally. A key person, a corrupted file, a broken macro. These three events have a low probability and a high impact. An SME of 30 employees generally has no plan B.

At Ateliers d'Art, an art school, this is exactly what was happening. The enrolment software gave wrong figures: number of students, breakdown by gender, by age, by category. No clean statistics could be drawn from it, so a manager recalculated everything by hand. To hand the year's figures to the accountant, it took two weeks to rebuild them in Excel, then two more to spot the errors and rebuild the files. The software did not handle special cases either (a change of class, an absence, a modified file): it had to be worked around. And as the website kept crashing, half of the previous years' students had to come in person to enrol on site. See the Ateliers d'Art project.

The problem may no longer be Excel

If you recognised yourself in five situations out of seven, the issue is not the spreadsheet. Excel does exactly what it was designed for: calculating, sorting, reporting. It cannot do what has been asked of it for three years, namely play the role of a shared, traceable tool, accessible to several people at once, with business rules written once and for all.

That role is the role of business software. Not necessarily custom, not necessarily expensive, not necessarily long to set up. But a tool whose function is explicitly to carry your process, not to document it after the fact. To understand what this notion covers and where it differs from a standard tool, see what custom business software is.

The good news is that your workbooks are not lost. They make up the most honest specification there is. The columns you have added over the years, the control tabs, the margin formulas: all of it describes your business better than a forty-page specification document. A project that starts from your existing files begins several months ahead.

Where to start, concretely

Before comparing solutions, do three simple things.

  • List your critical files. Those whose unavailability would block the business within the day. There are usually two or three, rarely more.
  • Identify who maintains them. Only one person per file? Note it. That is your real risk exposure.
  • Put a figure on the weekly consolidation time. Add up the exports, the copy-pastes, the checks. Multiply by 46 weeks. The total is often surprising.

This small inventory is enough to decide between tidying up, buying or building. Above all, it avoids the most common mistake: launching an IT project to solve an organisational problem, or the other way round.

If you ticked five boxes or more, the next step is not to choose a tool. It is to lay out the map of your files, your software and the people who link the two. It is a conversation, not a project.

To do this review, Magram offers a free diagnosis: an online questionnaire of several questions, which gives a score out of 100. We then discuss it in a call, to dig into your situation. Take the diagnosis

A question about your situation?

Ask Quentin, he replies personally.

Your details are used only to reply to you. Learn more

We use audience-measurement cookies to improve the site. Learn more.