The short answer
A spreadsheet works for a solar company until leads arrive from more than two channels, more than one person touches a lead, or follow-up needs to happen without somebody remembering. Those are the three hard limits. Below them a spreadsheet is faster, cheaper and more reliable than a badly implemented CRM.
- 01A spreadsheet everybody updates beats a CRM nobody updates.
- 02Three hard limits: multi-channel capture, shared access, and automated sending.
- 03The middle option is automating capture and first response while keeping the sheet.
- 04Switch when the limits bite, not when a salesperson tells you to.
Spreadsheets get sneered at in software marketing, which is unfair. A well-kept sheet is instant, free, flexible and understood by everybody. Plenty of solar companies run profitably on one for years.
What is worth being precise about is where it stops working, because the failure is gradual and by the time it is obvious you have usually lost a quarter of leads to it.
What does a spreadsheet genuinely do well?
- It is immediate. No configuration, no onboarding, no vendor.
- Everyone can use it. Nobody needs training to read a table.
- It changes in seconds. A new column is a decision, not a support ticket.
- It is honest. Nobody believes a spreadsheet is complete, so nobody trusts a report built on one more than it deserves.
That last point is underrated. A CRM produces confident reports from incomplete data. A spreadsheet produces obviously incomplete reports from incomplete data, and the second is safer to make decisions with.
Where does a spreadsheet stop working?
- 01
Multi-channel capture
Once leads arrive from a web form, the phone, a Business Profile message, Facebook and a vendor portal, somebody has to type them all in. That person will miss some, always. Whichever channel is most annoying to enter will look like it produces the fewest leads.
- 02
Shared access and ownership
Two people in one sheet produces overwritten rows, two calls to the same customer, and an argument. There is no record of who did what, and customers notice long before you do.
- 03
Automated sending
A spreadsheet cannot text somebody at minute one or email them on day seven. It can remind a human to, which works until the week the crew is behind. This is the limit that costs the most.
A comparison that is actually fair
| Spreadsheet | CRM | |
|---|---|---|
| Cost | Free | Subscription plus setup plus an owner |
| Time to start | Ten minutes | Two to six weeks |
| Multi-channel capture | Manual, and it will slip | Automatic, if configured |
| Automated follow-up | None | The main reason to have one |
| Shared use | Poor past two people | Designed for it |
| Communication history | None | Complete, on the record |
| Reporting | As good as the data entry | Also as good as the data entry |
| Failure mode | Visibly incomplete | Invisibly incomplete |
The middle option
You do not have to choose between a manual sheet and a full CRM migration. The two limits that cost real money, capture and automated sending, can be fixed on their own.
- 01One inbox for every channel, so nothing depends on somebody retyping. See the all-in-one inbox.
- 02Instant response and missed-call text-back, running automatically.
- 03The follow-up sequence automated, with calls queued for a person.
- 04The spreadsheet kept, for pipeline, until volume genuinely demands more.
That takes days rather than weeks, changes nothing about how the sales team works, and removes the two leaks that are actually costing you jobs. Pipeline management can follow later. See do solar companies need a CRM.
When should you actually switch?
Switch when two or more of the three limits are biting weekly, not when a demo is persuasive. In practice that is usually around twenty leads a month with two or more people selling.
And when you do, migrate carefully: run the new system for new leads first and bring history over afterwards, so nothing arriving today falls into the gap between the two. See choosing a CRM for a solar company.
Making the spreadsheet as good as it can be
If you are staying on a sheet for now, three changes make it dramatically more useful and take about twenty minutes.
- 01Add a next action date column, and sort by it every morning. This single column is most of what a CRM does for a one-person sales operation.
- 02Add a source column with a dropdown, not free text. Free text produces Google, google, GOOGLE and Google Ads as four separate sources and destroys the reporting you were trying to build.
- 03Add a loss reason column, also a dropdown. Six months of these is the most useful sales data a small installer can collect, and it costs nothing.
Do those three and the sheet will carry you considerably further than most people expect, which is the point: the decision to move should be forced by the hard limits above, not by the sheet being untidy.
A spreadsheet everybody updates beats a CRM nobody updates, every single time.
Stop reading, start booking
Volt builds and runs the system this article describes: the site, the follow-up, the inbox and the review funnel, for $297 a month.
No contracts. Cancel anytime.
Common questions
- Is a spreadsheet good enough for a small solar company?
- For pipeline tracking with one person selling and under about twenty leads a month, yes. What it cannot do is capture leads from five channels or send follow-up on time, and those two gaps can be filled without abandoning the sheet.
- What should be in a solar lead spreadsheet?
- Date, source, name, address, phone, bill range, stage, last contact date, next action date and a notes column. The two date columns are what make it a working tool rather than a list.
- How do I move from a spreadsheet to a CRM?
- Clean the sheet first, since bad data imported is bad data forever. Then run the CRM for new leads only for two weeks, and import history once the new process is stable. Never cut over both at once.
