7 Signs Your Business Has Outgrown Excel, and What to Replace It With

Your business has outgrown Excel when a spreadsheet has quietly become the system of record for something it was never designed to run: several people editing the same data, the same figures retyped into other systems, and decisions that depend on formulas only one person understands. The fix is rarely a big ERP. It is usually the smallest step that removes the actual problem: a tidier workbook, an off-the-shelf tool, a no-code database or a small custom application.

To be clear, Excel is an excellent tool. It is flexible, almost everyone knows the basics, and for analysis, budgets, quick calculations and short lists it is hard to beat. Plenty of businesses should stay on it, and we tell clients so. The question is not whether Excel is good. It is whether one shared file has become the place where your bookings, stock, jobs or customers actually live.

This guide is for owners and managers of small and medium businesses in Greece: hotels and rentals, restaurants and tavernas, shops, trades firms and service companies. It covers seven warning signs, a short self-assessment, the realistic options from lightest to heaviest, and how to move off a spreadsheet without losing data or annoying your staff. If you already know you need something new and are weighing building against buying, our guide to custom software vs SaaS goes deeper.

When Excel is still the right tool

Before the warning signs, the honest counter-case. Excel is usually the right choice when:

• One or two people maintain the file, and everyone else only reads it.
• The data is small: hundreds or a few thousand rows, not years of transactions.
• The work is analysis or planning (a budget, a pricing model, a season forecast) rather than daily operations.
• Mistakes are cheap to spot and fix, because nothing customer-facing depends on the file.
• The process changes often and you are still working out how it should run.

That last point matters. A spreadsheet is a good place to prototype a process. Many of the best internal systems start life as a well-used workbook that proved what the business actually needed. Moving too early just freezes a process you have not finished designing.

Seven signs your business has outgrown Excel

One sign on its own is normal friction. Several together usually mean the spreadsheet is costing you more in time and errors than a better tool would.

1. There are several versions of the “real” file

A shop with two branches keeps its stock list in Excel. One copy lives on the office PC, another was emailed to the second branch, and a third sits on the manager’s laptop as “Stock_FINAL_v3_new.xlsx”. Every Monday someone spends an hour reconciling them, and a customer is still told an item is in stock when it sold on Saturday. When people have to ask “which file is the right one?”, the spreadsheet is no longer a single source of truth.

2. Only one person understands the formulas

A small hotel runs room allocation and the cleaning rota from a workbook the owner’s nephew built three summers ago. It works, mostly. Nobody else knows why column R turns red, which tab feeds the housekeeping printout, or what happens if you insert a row. That is key-person risk: when that person is on holiday in August, ill, or leaves, the process stops or breaks silently. If you would hesitate to let a new employee edit the file, you have this problem.

3. You type the same data into several systems

A plumbing and heating firm in Pieria logs each job in an Excel job sheet, then types the customer and amounts again into its invoicing software, again into a shared calendar, and sometimes into a courier website to send parts. Each retyping costs minutes and is a fresh chance for a typo. It matters more now that invoices flow to AADE’s myDATA platform, and electronic invoicing between businesses is becoming mandatory. Businesses with 2023 gross revenue above €1 million have had to issue e-invoices since March 2026. For all others the obligation starts on 2 November 2026, with a transition period until 31 January 2027. From 1 February 2027, invoices between businesses can reach myDATA only through a certified e-invoicing provider or AADE’s free timologio and myDATAapp apps (AADE, 30 September 2026). These dates have already moved more than once, so ask your accountant which ones apply to you. The more hands your figures pass through between the job sheet and the invoice, the more likely they are to disagree.

4. Nobody can see today’s numbers without building a report

A taverna owner wants to know how last week compared with the same week last year, which suppliers raised prices, and whether August is on track. The answers exist, spread across the POS, a supplier price list and the accountant’s monthly figures, but getting them means someone copying, pasting and checking for an evening. When reporting is a project rather than a glance, decisions get made on gut feel or on numbers that are weeks old. A simple KPI dashboard fed directly from your systems usually answers these questions in seconds.

5. Errors are found later, usually by someone else

Spreadsheet errors are not a sign of careless staff. They are a known property of the tool. Raymond Panko, a leading researcher on the subject, wrote that fifteen years of research studies had “concluded unanimously that spreadsheet errors are both common and non-trivial” (Panko). A 2009 audit of 50 operational spreadsheets by researchers at Dartmouth found that 43 contained at least one error that produced a wrong result, and that roughly 1% to 2% of formula cells were in error, depending on how strictly an error was defined (Powell, Baker and Lawson). One percent sounds small until you remember that a costing workbook can easily hold thousands of formulas.

Public cases make the same point. In 2013, economists at the University of Massachusetts Amherst found that a formula in the spreadsheet behind an influential paper by Reinhart and Rogoff left five countries out of a key average. Together with other data choices they disputed, their recalculation put average growth in high-debt countries at 2.2% rather than the −0.1% originally reported (Herndon, Ash and Pollin). At a smaller scale, a taverna’s dish costing sheet that still points at last year’s olive oil price will happily price a whole season on the wrong cost, and nobody notices until the margin does not add up.

6. Personal data sits in shared files with little control over who sees it

Customer lists with phone numbers, emails, allergies or payment notes often live in a workbook shared by link, copied to laptops and forwarded by email. Former staff may still have a copy, and there is usually no record of who changed or exported what. The GDPR does not ban spreadsheets. It does require personal data to be processed with appropriate security, including protection against unauthorised processing and accidental loss (Article 5(1)(f)). It makes the business responsible for compliance and able to demonstrate it (Article 5(2)). And it asks for measures that keep systems confidential, intact and available, and that let you restore data after an incident (Article 32) (GDPR on EUR-Lex).

A loose file makes all of that harder to show. Storing the workbook in OneDrive or SharePoint helps, because it adds sharing controls and version history. But in practice access applies to the whole file: anyone who can open the customer list sees every customer, and can download a copy.

7. The file is slow, crashes or hits limits

A modern Excel worksheet holds up to 1,048,576 rows by 16,384 columns (Microsoft), so few small businesses ever reach the hard limit. They reach the soft ones first: a workbook that takes a minute to open, lookups across linked files that break when someone renames a folder, and a file that will not open properly on the phone in the storeroom. When people avoid opening the file, they start keeping side notes, and you are back to sign 1.

Limits can also bite silently. In October 2020, Public Health England reported that 15,841 positive COVID-19 cases from 25 September to 2 October had been left out of the daily figures, because some files exceeded the maximum size the system could load (GOV.UK). Press reports traced it to the older .xls format, which holds only 65,536 rows per sheet (The Register). Nothing crashed. The rows past the limit were simply not there.

Score yourself: a quick self-assessment

Give yourself one point for each statement that is true today.

1. People regularly ask which version of a file is the current one.
2. Only one person can safely change the main workbook.
3. The same customer, order or job is typed into two or more places.
4. Weekly or monthly figures take someone more than an hour to put together.
5. In the last year, a spreadsheet mistake reached a customer, a supplier or your accountant.
6. Customer personal data sits in a file shared by link or copied to personal devices.
7. You cannot tell who changed a figure, or when.
8. Staff keep their own side lists because the main file is too slow or awkward.
9. The file is hard to use on a phone or tablet where the work actually happens.
10. You have delayed hiring, a second location or a new sales channel because the spreadsheet would not cope.

0–2 points: stay on Excel and tidy it up. 3–5 points: tidy the workbook and replace the most painful part with a dedicated tool. 6 or more: the spreadsheet is running your business, and it is time to plan a proper replacement.

What to replace Excel with: the options, lightest first

There is no single “Excel replacement”. Think of it as a ladder, and climb only as far as the problem requires. The first rung costs almost nothing: convert ranges into Excel tables, add drop-down lists so that “Katerini”, “katerini” and “Κατερίνη” stop being three different towns, use Power Query to clean the monthly POS export instead of pasting it by hand, and keep one copy in OneDrive or SharePoint so people work on the same file at the same time.

“Excel or ERP?” is usually the wrong question for a small business. A full ERP covers accounting, stock, purchasing, sales and more in one product, and it is often more than a ten-person business needs or will configure properly. Most end up with a mix: standard tools for accounting, invoicing and payments, and something purpose-built only where their way of working is genuinely different. That hybrid approach is covered in our build-or-buy guide.

Which sign points to which fix

How to move off Excel without losing data or goodwill

Most failed replacements fail on the move, not on the software. A careful switch looks like this:

1. Map the process before the file. Who enters what, when, on which device, and who reads it afterwards. The spreadsheet shows the data; it rarely shows the workarounds.
2. Decide one home for each kind of data. Customers in one place, stock in one place, invoices in the accounting software. Write it down.
3. Clean before you migrate. Remove duplicates, split merged cells, turn free-text dates into real dates and agree on one spelling for each supplier.
4. Migrate the history you actually use. Often the last two seasons, so year-on-year comparisons still work. Keep older files read-only as an archive.
5. Keep Excel as an export. The new system should produce a spreadsheet whenever your accountant or manager wants one.
6. Run both in parallel for a few weeks. Compare totals daily or weekly until they match and people trust the new numbers.
7. Train where the work happens. Sit with staff during real shifts, not in a meeting room.
8. Switch the old file off. Rename it as an archive and make it read-only, or side lists will creep back.

Training is the step people underestimate, ourselves included. In our five-venue ERP case study, where inventory had lived in one Excel file per kitchen, we found that senior staff needed more time side by side during live service than we had first budgeted. Fifteen years of habit is fast, and the new system has to be faster.

What replacing a spreadsheet costs

Tidying an existing workbook is usually days of work rather than weeks, and the tools it needs are often already included in a Microsoft 365 subscription. Off-the-shelf software is mostly a monthly fee per user or per location, so compare the total over three to five years, not the first month, and include the time spent adapting your process to it.

For custom work, our software projects start from €1,000 (Essential), with Growth from €3,000 and Signature from €10,000 for larger systems. Where the need is mainly reporting or automating existing data, our Data & ML work starts from €1,200 (Insight) and €3,500 (Automation). Every project gets a fixed written quote. For wider market ranges and what drives them, see how much custom software costs in Greece.

For the smallest businesses, the spreadsheet is often just income and expenses. Tameio, our income and expense app for small businesses, records each sale and bill in seconds and shows the profit for today, the week and the month, without building a single formula.

How Orya One can help

Orya One is a software house founded in 2026 in Paralia Katerinis by data scientist Dimitris Kampouridis. We build custom software and data and reporting systems for businesses across Greece, and you work directly with the people building them. We start with how the work actually flows, not with the file, and we will tell you if a tidier spreadsheet or an existing product is the better answer. When we do build, you get a fixed written quote, GDPR by design and full ownership of the code.

If you scored three or more on the self-assessment, send us a short description of the spreadsheet and what it is used for. A screenshot with the personal data blurred out is enough to start, and we will tell you honestly which rung of the ladder you need.