Almost every small business I work with started on spreadsheets, and that was the right call. They are free, flexible and everyone knows how to use them. But there is a point where the spreadsheet stops saving time and starts costing it. This guide is for owners and managers in Cambridge, Kitchener-Waterloo, Guelph and across Ontario who are wondering whether to replace spreadsheets with a web app: the signs you have outgrown them, what a custom system actually replaces, what it costs, and when you should not bother. I will be honest about the cheaper options too.
Signs your business has outgrown spreadsheets
One of these on its own is normal. If three or four sound familiar, the spreadsheet is probably now the bottleneck rather than the helper.
- You type the same thing more than once. A customer's details go into an email, then the spreadsheet, then an invoice, then a calendar. Every copy is a chance for a typo.
- Nobody is sure which file is current. “Schedule FINAL v3 (Sam's edits).xlsx” is a warning sign, and so is two people overwriting each other in a shared file.
- Customers are your error checking. You find out about a double booking, a missed order or a wrong price when someone phones to ask what happened.
- One person holds it all together. If the person who built the spreadsheet is away, the formulas, colour codes and hidden tabs become a mystery.
- Customers have to email you to get anything done. Booking, registering, checking a status or updating their details all go through your inbox.
- Reporting takes an afternoon. Answering “how many did we do last month?” means filtering, copying and pasting before you can trust the number.
- Everyone can see everything. A shared sheet usually means staff, contractors or volunteers see personal information they do not need.
The underlying problem is the same in every case: a spreadsheet stores data, but your business runs on a process. A spreadsheet cannot enforce the rules of that process, send the next message or stop two people from claiming the same slot.
What a custom web app actually replaces
A web app is software you use in a browser, on a computer or a phone, with a database behind it instead of a file. When people talk about replacing spreadsheets with a web app, they usually mean replacing a whole bundle of tools at once:
| Today | In a web app |
|---|---|
| A shared spreadsheet several people edit | One database, with each change recorded and no conflicting copies |
| Copying details between email, sheet and invoice | Enter it once; every screen and email uses the same record |
| Remembering to send confirmations and reminders | Emails sent automatically at the right moment, with a log of what went out |
| Customers emailing to book, register or check status | A customer login or form where they do it themselves |
| Colour codes and notes that only one person understands | Clear statuses and rules the system enforces |
| Everyone seeing every tab | Roles and permissions, so each person sees only what they need |
| An afternoon of filtering to answer a question | A dashboard with the numbers you check every week |
The point is not the technology. It is that the rules of your business, like “a slot can only be booked once” or “an order needs approval over a certain amount”, live in the system instead of in someone's head.
A real example: from a spreadsheet to online booking
Leap Into Lessons is a family-run swim school in Puslinch, Ontario. Before I worked with them, a full summer of private lessons was managed by phone, email and spreadsheet on top of an aging WordPress site. Parents had to get in touch to find a time, and the owner had to keep the whole season straight by hand.
I replaced that with a custom web app in about two months. Parents now book in three steps (child, date, time), a slot is held during checkout so two families can never get the same time, confirmations and reminders go out on their own, and the owner has an admin area to change the schedule, look up families and email everyone at once. You can see screenshots and the details in the Leap Into Lessons case study.
What made it worth building was not that spreadsheets are bad. It was that the business had rules (seasons, coaches, breaks, several children per family) that a spreadsheet could record but not enforce, and the owner was spending the season coordinating instead of coaching. If your situation is closer to standard appointments, read off-the-shelf vs custom online booking first, because a ready-made tool may be all you need.
Cheaper fixes to try before you build
Custom software is not the only answer, and for many businesses it is not the first one. Before you spend money on a build, check whether one of these solves most of the problem:
Tidy the spreadsheet you have
One sheet per kind of thing (customers, orders, bookings), one row per item, drop-down lists instead of free typing, and data validation to block obvious mistakes. This costs an afternoon and can buy you a year.
Move to a shared online spreadsheet
If the main pain is emailing files back and forth, a cloud spreadsheet with proper sharing settings fixes version confusion today. Add a simple online form in front of it so customers stop emailing you their details.
Use an off-the-shelf tool built for your industry
Clinics, salons, trades, gyms and lesson providers all have ready-made software. If your process looks like everyone else's in your industry, a subscription is often faster and cheaper than anything custom, at least for the first few years.
A quick test
Write down your process as numbered steps, from the customer first getting in touch to the job being done and paid. If a ready-made tool handles every step without a workaround, use it. If you keep writing “then I check the spreadsheet and email them manually”, that is where custom software earns its keep.
What it costs to replace spreadsheets with a web app
Cost depends almost entirely on how many workflows you include and how many kinds of user log in. The ranges below are rough estimates for Ontario small businesses, not survey data.
| Option | Upfront cost | Ongoing cost | Best for |
|---|---|---|---|
| Tidied or shared online spreadsheet, plus forms | Usually $0 plus your time | Usually little or nothing | Small teams with a simple process |
| Off-the-shelf industry software | Usually $0 to set up | Monthly subscription, often per user or location | Processes that match your industry standard |
| Custom web app for one core workflow | From $7,500 | Hosting and a care plan, no per-user fees | One painful workflow with your own rules |
| Larger custom system with portals and reporting | Scoped after a discovery session | Hosting, care plan and planned improvements | Several connected workflows and user types |
My Custom web app package includes a written technical scope, user accounts and roles, an admin panel, automatic emails and full ownership of the source code. To weigh it fairly, compare a three to five year total: the build plus hosting and care on one side, and subscriptions plus the staff hours lost to copying, checking and fixing mistakes on the other. Software needs looking after once it launches, which I cover in website maintenance cost.
How to start without betting the business
The projects that go well start small. Rather than replacing every spreadsheet at once, pick the one workflow that costs the most time or causes the most mistakes, build that properly, and add more once it is working.
Before you talk to a developer
- Which single workflow wastes the most time or causes the most errors?
- Who uses it: staff, customers, contractors, volunteers? What should each be able to see and change?
- What rules does the spreadsheet rely on people remembering?
- Which messages do you send by hand that could go out automatically?
- What numbers do you need to see every week?
- Can you export your current spreadsheet cleanly, so existing records can be brought across?
- Who will own the code, the hosting account and the data when it is done?
If the system will hold personal information about customers or staff, ask how it is stored, who can see it and how it can be deleted. Most private businesses in Ontario fall under PIPEDA, the federal private-sector privacy law, so privacy is part of the design from the first day, not an add-on at the end.
You can read more about how I approach this kind of project on the web apps and custom software page. If you are not sure whether you need custom software at all, tell me how your spreadsheet is used today. If a tidier sheet or a ready-made tool will do the job, I will say so, and an hour of consulting at $45 plus HST is often enough to decide.
Frequently asked questions
When should a small business stop using spreadsheets?
When several people edit the same file, information is copied between spreadsheets and emails, mistakes are reaching customers, or only one person understands how it works. Those are signs a shared system with built-in rules would save time.
How much does it cost to replace a spreadsheet with a web app?
A custom web app covering one core workflow is typically a project in the several-thousand-dollar range, plus hosting and ongoing care. Larger systems with customer portals and reporting cost more and should be scoped in writing first.
Can my existing spreadsheet data be moved into a web app?
Usually, yes. If the spreadsheet is reasonably consistent, existing customers, orders or bookings can be imported. Messy data takes extra cleanup, so tidying the sheet first can lower the cost.
Is off-the-shelf software better than a custom web app?
Often, especially if your process matches what is standard in your industry. Custom software pays off when your rules are unusual, the subscriptions and workarounds add up, or the workflow is central to how you earn money.
Written by
Corey Paskewitz
Corey is a full-stack web and software developer in Cambridge, Ontario. Through Corvian Labs he designs and builds websites, booking systems and custom web apps for businesses across Kitchener-Waterloo, Guelph and beyond.