Skip to content
Manage IT

Software

When Excel is no longer enough to run your business records

Nikola CerićFounder & CEO, Manage IT

Seven signs that running records in Excel has become a risk, and how to move to software without losing the data you already have.

Almost every company we meet has “that spreadsheet”. One file holding customers, orders, hours or stock, with dozens of columns and colours that mean something only to the person who made it. Excel is not the problem. The problem is when one spreadsheet becomes the system the company runs on.

Seven signs it is time for a change

There are versions: “sheet_final”, “sheet_final2”, “sheet_NEW”. Nobody is sure which one is right.

Only one person knows how the spreadsheet works. When they are on holiday, everyone else waits.

The same information is entered in two places, in the spreadsheet and in a document, and the two differ.

Several people should work at the same time, but the file cannot handle it or edits overwrite each other.

A formula was accidentally deleted and nobody noticed for a month.

Workers in the field cannot access it, so they report data by message and someone retypes it.

At the end of the month someone spends hours building a report from the spreadsheet by hand.

What software does better than a spreadsheet

One source of truth: everyone works on the same data at the same time, without versions.

Rules that cannot be bypassed: the software will not allow an order without a customer or hours entered on the wrong date.

Role-based access: a worker sees their own data, a supervisor their team, the owner everything. In a spreadsheet, everyone sees everything or nothing.

History: it is clear who changed what and when.

Phone access: the worker enters data where it is created, without a middleman.

What Excel still does brilliantly

Analysis, one-off calculations, planning and what-if scenarios. There is no reason to move that into software. A good system even exports to Excel, so the data can be analysed just as before.

The difference is that Excel becomes a tool for thinking rather than the place where the truth about the business is stored.

How to switch without losing data

Existing spreadsheets are gold: they hold the structure of the work the company has built over years. The switch does not start with empty software but with importing those spreadsheets.

First the data is cleaned (duplicates, empty fields, the same customer spelled differently), then imported. For a few weeks both run in parallel, and then the spreadsheet is locked as read-only so nobody accidentally keeps working in it.

How long it takes

It depends on how many spreadsheets there are and how connected they are. One spreadsheet for time tracking is a matter of weeks; five interlinked spreadsheets that run the whole company is a more serious project. It is always smarter to start with the one that hurts most.

Nikola Cerić

Founder & CEO, Manage IT

More than 10 years of software development experience — in his own company and in major IT companies across the Balkans.

Have a project in mind?

Request a proposal