
A spreadsheet can run a one-truck pool service for a while. It holds customer addresses, chemical readings, and who paid last month, and for a solo operator, excel pool service tracking might be the whole system. It breaks the day a second truck joins, a call gets missed, or a customer asks for a text instead of a phone tag game. Knowing where that line sits matters more than switching too early, or waiting until the spreadsheet itself causes a missed job.
Can a spreadsheet actually run route scheduling and chemical logs?
Yes, for a while. A spreadsheet can hold an address list, a service day, and a column for last chlorine and pH readings. What it can't do is tell you the cost of running it that way once the list grows. PoolDial's routing guide estimates that a 300-pool route with disorganized, sign-up-order routing (rather than grouped by geography) burns $900 to $1,500 a month in unnecessary fuel and truck time (2026). A spreadsheet doesn't surface that cost. It just lists the stops in whatever order you entered them.
The spreadsheet isn't wrong, exactly. It's just not built to catch that kind of drift. Nobody notices until the fuel bill does.
What a pool service spreadsheet should track, at minimum
If you're still running on one, here's the floor. EZ Pool Biller's routing guide makes the case that routing only works when it's tied to the rest of the account, not planned in isolation.
Start with the address, the gate code, and any access notes like a dog in the yard or an HOA's quiet hours. Add the service frequency, so a weekly account never gets treated like a biweekly one. Track the last chemical reading and what got added. Update payment status after every visit, not at the end of the month. Note customer preferences on timing, because the office that keeps that in someone's head loses it the day that person is out sick.
Most spreadsheets hold the first two or three of those well. They fall apart on the rest, because nothing in a spreadsheet reminds you to update it, and nothing in it can act.
What are the real signs it's time to move off Excel?
The spreadsheet usually survives the first truck fine. The strain shows up later, and it shows up in a handful of specific places, not as a general sense that "things feel disorganized."
The clearest sign is the one owners describe after the fact, not before: it replaces the whiteboard, the shared spreadsheet, and the four apps techs half-use, because by the time a business is juggling all four, the spreadsheet was never really running the business. It was one piece of a system nobody had actually built.
Is there a free pool service Excel template, and what are its limits?
Yes. Templates and toolkits for pool route and chemical tracking exist, built in Excel or Google Sheets and shared on forums like r/excel and MrExcel. A well-built one is a real upgrade over a blank sheet: it standardizes the columns, pre-builds a few formulas, and saves the trial and error of designing a tracker from scratch.
Its limits don't change, though, no matter how well it's built. A template is still a file, not a system. It can log a chemical reading, but it can't text the customer that reading. It can list a route, but it can't call back the lead who phoned during a service call. It can store a payment status, but it can't remind anyone that an account is overdue. The ceiling isn't the quality of the spreadsheet. It's what a spreadsheet is.
What a system replaces the spreadsheet with
This is where KeptBlue's feature set answers the question a spreadsheet can't. Instead of a flat list of rows, a CRM pipeline tracks each customer by stage: new lead, scheduled, active, overdue, lost. That's a status a spreadsheet column can fake but not really hold, because nothing updates it automatically when a job gets booked or a payment clears.
Scheduling and routing live in the same system as that pipeline, not a separate tab that has to be kept in sync by hand. And the parts a spreadsheet simply cannot do at all: when a call comes in after hours or during a service call, Voice AI answers it, checks the live calendar, and books the appointment, instead of the call going to voicemail and the spreadsheet never finding out it happened.
None of that makes the business better at pool service. It just means the system catches what the spreadsheet was always going to miss: the call that came in at 6 PM, the appointment reminder nobody sent, the account that's been thirty days overdue since nobody flagged it.
Where to go from here
A spreadsheet is a fine place to start a pool service business, and plenty of owners run one for a year or more without trouble. The real question isn't whether Excel can do the job on day one. It's whether the business is still small enough that nothing falls through the gap it leaves: no missed call, no customer wanting a text, no second truck needing the same file. KeptBlue's roadmap for new pool service owners covers the systems worth setting up before that gap opens, not after.