Excel as your ERP: 7 signs it is time to move on

Cover: Excel as your ERP, 7 signs it is time to move on

In many small and mid-sized companies the real management system is not software they bought: it is an Excel workbook. It started as a customer list or an order tracker, then came new columns, new sheets, a few macros. Today it runs an important part of the business.

There is nothing wrong with that: Excel is flexible, everyone knows it and you can start right away. The problem is that Excel was not designed to be an ERP, and sooner or later the workbook starts to show its limits. Here are the seven most common signs.

1. There are several versions of the same file

"Orders_2026_final.xlsx", "Orders_2026_final_v2.xlsx", "Orders_2026_Mark.xlsx". When the file travels by email or across shared folders, nobody knows which version is the right one. Every copy is a different source of truth, and rebuilding the correct data costs time and mistakes.

2. Two people cannot work on it at the same time

The file is "locked for editing", or two colleagues update it in parallel and one overwrites the other's work. The bigger the team, the more the workbook becomes a bottleneck.

3. Everyone can see (and change) everything

Access control in a spreadsheet is minimal: whoever opens it also sees margins, purchase prices or customers' personal data, and can change any cell. A real business application lets you decide who sees what and who can edit what.

4. You don't know who changed a value, or when

An amount is wrong, a delivery date has moved. Who changed it? Excel does not keep a reliable per-record history of changes. Without an audit trail, every mistake turns into an investigation.

5. The file is slow, heavy or breaks

Thousands of rows, chained formulas, VLOOKUP everywhere: the workbook takes minutes to open and occasionally gets corrupted. At that point the risk is not just speed, it is losing data.

6. Backups depend on someone remembering

If the file lives on one person's laptop or a USB stick, a hardware failure or a theft can wipe out years of work. Often a backup exists only "when someone remembers".

7. Only one person really understands the file

There is always someone who "knows how the file works": the hidden formulas, the sheets you must not touch, the macros. When that person is on holiday or leaves the company, the process stops.

What to do: don't throw the file away, transform it

The instinctive reaction is to buy a traditional ERP. But that often means months of implementation, high costs and software that forces the company to adapt to it. Above all, it throws away the work already done: your workbook already contains your data structure and your business rules.

The alternative is to start from there. With Nitor you upload the Excel file you use every day and we turn it into an online business application, hosted and maintained by us:

  • Data in the cloud, kept safe: one up-to-date version, with managed backups.
  • Users and permissions: everyone sees and edits only what they need.
  • Real-time collaboration: no more locked files or conflicting copies.
  • Extensions: as the company grows, the application grows with it.

In short

If you recognised yourself in two or three of these signs, your workbook is already doing the job of an ERP, without the guarantees of one. The next step is not starting from scratch: it is giving your file the security and control it is missing today.