We are not here to sell you a move away from Excel. For many small businesses a well-organised spreadsheet does the job for years. This guide explains how to tidy yours up, how to measure whether it still costs you time, and what exists beyond it — from free options to custom-built tools.
Excel or Google Sheets is enough while one person runs the work and every piece of information has exactly one place. It stops being enough when several people work in their own copies, when the same detail is retyped in two or three places, when deadlines depend on someone’s memory, and when a customer has to wait for you just to learn their appointment time or order status. Before any new software, tidy up the spreadsheet — it is free and often enough.
01Excel isn’t the problem — five copies of it are
A spreadsheet is an excellent tool for one person who knows where everything is. Trouble starts when the business grows and the spreadsheet stays the same. A quote goes out as an email attachment, a colleague edits it on their own computer, and suddenly there is quotes_final.xlsx and quotes_final_2.xlsx. A customer sends a new address on WhatsApp or Viber, and the spreadsheet keeps the old one. A technician keeps their own notebook because the file won’t open on their phone.
None of this is Excel’s fault. It is a sign that the same work is handled by several people, in several places, with no agreement on which version is the correct one. New software doesn’t fix that on its own — introduce it without that agreement and you get one more place where the data can drift apart.
02Five signs you’ve outgrown the spreadsheet
Go through the list honestly. Each sign on its own is a reason to look at how you work, not a reason to buy something straight away.
There are several versions of the same file
The file travels by email or message, everyone has their own copy, and every decision starts with checking “which one is the latest”.
The same information lives in several places
The appointment is in the spreadsheet, the note is in a chat, the address is in a notebook. When one changes, the other two stay out of date.
Deadlines depend on memory
Nobody gets a reminder. An unanswered quote, a service that is due, a customer you promised to call back — it all sits in someone’s head.
The customer has to wait for you to get an answer
To find a free slot or an order status they have to call or write, and you have to open the spreadsheet and reply.
Nobody dares touch the formula
One person understands the spreadsheet. When they are away, everyone else only reads it — and nobody knows who changed what.
03Free first: how to tidy up the spreadsheet
This is an afternoon’s work and needs no new software. For many businesses, the story ends here.
- One file in the cloud instead of copies by email. When the file is on OneDrive or Google Drive, everyone works in the same document and earlier versions can be restored — both Microsoft and Google describe this in their help pages (sources at the bottom of the page).
- One row = one job. Not one customer, not one day — one job. That way every job can be followed from the first contact to the end.
- The same columns for every job: date received, customer, request, status, next step, who is responsible, deadline. If a column always stays empty, you probably don’t need it.
- Status from a drop-down list, not free text: for example New · Quote sent · Booked · Done · Cancelled. Only then do filters really work.
- A form in front of the spreadsheet. Instead of copying messages, send the customer a link to a short form with required fields. Google Forms can write responses into a linked Google Sheet.
- Lock the columns that hold formulas, so nobody overwrites them by accident.
- One morning rule: filter “deadline = today or earlier”. Five minutes a day, and you don’t have to remember everything.
04Example: an air-conditioning service with three technicians
An invented example, to show what the problem looks like in practice. It is not a specific client’s story and it contains no measured savings.
Assumptions: the owner takes enquiries by phone, chat apps and Instagram. The schedule lives in a spreadsheet on the owner’s computer. Technicians get addresses by message, and one of them also keeps their own notebook.
The technician arrives at 11 am at the old address. Nobody made a mistake on purpose — the information was simply in three places.
The first step is free: a spreadsheet built on the template from section 03, in the cloud, and a rule that every change is recorded there. That solves the old-address problem. Where the spreadsheet stops helping: technicians need to see only their own jobs for today on their phones and mark them “done”, and the customer should get an appointment confirmation without a phone call. A spreadsheet can do that only with a lot of improvisation. That is where it makes sense to think about a system — but only there.
05Measure one week before you decide
The feeling that “admin is eating my time” is useful, but it isn’t enough for a decision. One week of tallying gives you a number instead of an impression. Next to the spreadsheet or on paper, keep a tally:
I looked for something that was already written down
Every time you scrolled through messages or files to find an address, a price or an arrangement.
I retyped the same information
From a message into the spreadsheet, from the spreadsheet into a quote, from the quote into a message to a technician.
Something was late or fell through
A forgotten call, a missed deadline, a double booking, a customer left waiting for an answer.
Next to each tally mark, note roughly how many minutes it took. At the end of the week you have three numbers and a total time. If C is empty and A and B come down to a few times a week, stay with the spreadsheet and don’t spend money. If C happens several times a week, it is a cost your customers can see — and it is no longer a question of comfort.
06What exists beyond the spreadsheet
When a tidy spreadsheet no longer covers the work, there are four realistic paths. None of them is “the best”; they differ in who adapts to whom.
Of these four paths, we build the last one — business apps for appointments, work orders, enquiries and orders. That is exactly why we tell you the first three are often enough. If what you need is visibility rather than organising the work, you don’t need a system — the right question then is what a small business website needs.
07The most common mistake: two systems at once
When you introduce anything new — off-the-shelf software, a database or an app — the biggest risk isn’t the technology. It is the period when the old record and the new one live side by side. In one Reddit discussion a customer describes booking a massage online and receiving a confirmation and an email reminder, only for reception to open a paper notebook and say there was no booking, because the manager had not copied it over (r/AskSerbia, 2025). Online booking worked. The notebook was the problem.
- Set the day the old record is retired, not just the day the new one starts.
- One person is responsible for the new record being correct for the first few weeks.
- If something is still agreed by phone, it goes into the new system — not “later”.
08How people who have the problem describe it
Before writing, we read discussions in which owners, their staff and their customers describe this problem. These are not statistics or proof of a trend, just examples that keep coming up:
- A company that ran stock, work orders and deliveries in spreadsheets: missed orders and parts made to the wrong spec (r/smallbusiness, 2023).
- A home bakery takes orders on three apps and spends 10–15 minutes messaging back and forth to get the flavour, the address and the date; the top-rated advice in the comments suggests a form with required fields (r/smallbusiness, 2026).
- The owner of a car repair shop asks for free record-keeping software, and the replies send them back to Excel and Google Sheets (r/serbia, 2022).
- Asked whether they would move from Excel to a system, commenters defend Excel — asking what a system would have that Excel doesn’t — and say that a specific problem calls for a specific small solution (r/AskSerbia, 2026).
The last example matters most to us, because it goes to the heart of it: if you don’t know exactly which problem you are solving, a new tool won’t solve it for you.
09FAQ
Is Google Sheets better than Excel?+
For working together they are very similar: both let several people work in the same file and keep earlier versions, as long as the file is in the cloud. More important than the choice is having one file, not copies by email.
I have one or two employees. Do I need a system?+
Probably not. Start with section 03 and the test in section 05. If nothing was late after a week and the minutes spent searching and retyping (tallies A and B) are small, the spreadsheet is doing its job.
Can I keep Excel and just add something?+
Yes, and it is often the best first step. A form in front of the spreadsheet handles intake, and the spreadsheet stays the place where you run the work.
How much does a custom app cost with you?+
Business apps aren’t a standard package. The estimate is made like this: a short brief → a written scope with clear limits (“this is included, this isn’t”) → a price and timeline for that scope, before any work starts. If the system stays in use, ongoing maintenance is agreed with you. Details are on the business apps page.