CRM & reporting

Spreadsheet or CRM? When an installer outgrows Excel

Looking for a CRM for installers in the UK? The signs you have outgrown your spreadsheet, what a trade CRM must do, and how to switch without losing a lead.

Tom Spink · Founder, Attain Digital · 19 November 2026 · 7 min read
Spreadsheet or CRM? When an installer outgrows Excel

Nearly every installer starts with a spreadsheet. It is free, everyone knows how to use it, and for the first year it does the job. Then the business grows. A second salesperson joins, Facebook ads start bringing in leads at weekends, the office manager keeps her own copy, and one day you realise nobody knows which version is right.

This article covers the signs you have outgrown the spreadsheet, what a CRM for installers actually needs to do, and how to switch without losing anything.

The spreadsheet is not the problem. Until it is.

A spreadsheet is a list. It is good at storing things. It is bad at three things a growing installer needs:

  • Making things happen. A sheet does not remind anyone to call a lead back, send a quote follow-up or confirm a survey.
  • Sharing safely. Two people editing at once, copies on laptops, filters left on, rows deleted by accident.
  • Telling you what is going on. Building weekly reports by hand from a sheet takes hours, so it stops happening.

Seven signs you have outgrown it

  1. More than one person handles leads, and you cannot tell who is responsible for which.
  2. Leads arrive from three or more sources and someone copies them in by hand.
  3. You have found a lead nobody followed up, more than once.
  4. You cannot answer "what is our close rate by lead source?" without an afternoon of work.
  5. Quotes go out and nobody chases them on a set schedule.
  6. Survey no-shows are rising, because confirmations and reminders depend on someone remembering.
  7. Customer details live in several places: the sheet, the inbox, WhatsApp, the quoting tool.

If three or more apply, the spreadsheet is costing you jobs. Our article on how leads fall through the cracks shows how to measure exactly how many.

What a CRM for installers must do

Generic sales CRMs are built for office sales teams. Installers have surveys, diaries, postcodes, finance, installs and aftercare. Before you choose anything, check it can do these:

Capture

  • Pull in leads automatically from Facebook and Instagram, Google, your website and tracked phone numbers
  • Keep the original source on every lead, permanently
  • Log calls, texts, emails and WhatsApp messages against the customer

Pipeline

  • Stages that match how you sell: new, contacted, survey booked, survey done, quoted, won, lost
  • An owner and a next action date on every lead
  • Required "lost reason" so you learn why jobs go elsewhere

Diary and routing

  • Book surveys straight into the right rep's calendar
  • Route leads by postcode, so a lead in one area goes to the rep who covers it
  • Automatic confirmations and reminders to the customer

Follow-up and automation

  • Instant reply to new enquiries, including out of hours
  • Quote follow-up sequences across text, WhatsApp and email
  • Review and referral requests after the job

Reporting

  • Leads, contact rate, appointments, show rate, close rate and average order value
  • Cost per lead and cost per sale by channel (needs your ad spend connected)
  • Each rep's activity and results

Data

  • Easy export of all your data at any time
  • Access controls, so people see what they need and nothing else
  • Clear records of marketing consent

That last point matters more than it looks. Under UK GDPR, if a customer asks for a copy of the personal data you hold about them, the ICO says you must respond without undue delay and within one month. That is easy when everything is in one system and painful when it is spread across sheets, inboxes and phones.

What to avoid

  • Too much CRM. Enterprise systems with fifty fields per lead that nobody fills in. If the sales team will not use it, it does not matter what it can do.
  • No trade stages. If you have to pretend a survey is a "meeting" and an install is a "deal", reporting will never make sense.
  • Closed data. If you cannot export your customers easily, you do not own your business's most valuable list. See do you own your website and ad accounts? for the same point applied to marketing assets.
  • A CRM bolted on with no automation. A CRM that only stores data is a more expensive spreadsheet.

How to switch without losing a lead

  1. Clean the sheet first. Remove duplicates, mark dead leads as lost with a reason, and add a source column if you do not have one.
  2. Agree your stages with the people who will use them, on paper, before you configure anything.
  3. Connect the lead sources so new leads land in the CRM from day one. Stop new rows going into the sheet.
  4. Import the open pipeline: live leads, booked surveys and open quotes. Archive the rest as a reference file.
  5. Switch on the basics first: owners, next actions, survey reminders. Add quote sequences and review requests in week two or three.
  6. Run a daily ten-minute check for the first month: anything overdue, anything unassigned.
  7. Retire the spreadsheet formally. If it stays open "just in case", people will keep using it.

What Installer Flow does

Installer Flow is our own CRM, built for installers and home improvement firms. Leads from ads, forms and calls land in one pipeline. They are routed by postcode to the right rep's diary, with reminders that cut no-shows. Automations and AI follow-up reply in seconds, qualify the lead and book the survey, day, night and weekends. And the reporting dashboards cover pipeline, reps, cost per lead and cost per sale.

We set it up as part of mapping your whole business, so the stages, routing and automations match how you actually sell, not a template.

If your spreadsheet is starting to creak, book a call and we will look at what you have now and what the switch would involve.

Sources

Questions owners ask

When should an installer move from a spreadsheet to a CRM?

Usually when more than one person handles leads, when you run more than one lead source, or when you find leads that nobody followed up. At that point the spreadsheet stops being a record and becomes a guess. A CRM adds owners, reminders, automation and reporting that a sheet cannot do.

Can I just use a general CRM rather than one built for installers?

You can, but you will spend time bending it to fit: survey stages, postcode-based diaries, finance and install scheduling are not built into most general sales tools. Whatever you choose, check it can do the jobs on the must-have list in this article before you commit.

Tom Spink
Tom SpinkFounder of Attain Digital. Over ten years running Google and Facebook ads, the last five specialising in renewables and home improvement. About Attain Digital →

Book a video call

Let’s talk about growing your business

No hard sell. No pressure. A straightforward conversation about your business, your area, and whether we can help. If it is a fit, we will explain exactly how the system works. If it is not, we will tell you straight.

Calendar not loading? Open it in a new tab.

Rather message first?
Message Tom on WhatsApp
Book a call