CRM vs spreadsheet for tradespeople: when to make the switch (UK 2026)

Almost every UK trades business starts on a spreadsheet. A list of customers, a tab for jobs, a tab for quotes, maybe a colour-coded sheet of expiring documents. It works. It is free. It is what you already know. Then at some point it stops working, but it is rarely obvious exactly when. This guide walks through honest comparisons of running a trade business on spreadsheets vs a proper CRM, when to stay on the spreadsheet, and the specific signs that mean it is time to move on.

What spreadsheets are genuinely good at

Defending the spreadsheet for a moment, before bashing it. Spreadsheets are excellent at a small number of jobs and pretending otherwise will not get this right.

Free. Already on your computer. No subscription.
Familiar. Most people who run a trade business have used them since school. No learning curve.
Flexible. Want a column for "deposit paid"? Add it. Want a tab for "ones I do not like"? Add it. No one stops you.
Local control. The file lives on your computer. No internet needed. No third party can lock you out.
Scales to about 50 customers. If your business has up to about 50 active customers and 1-3 people working in it, a well-organised spreadsheet can hold the whole business comfortably.

Be honest. Most UK trades businesses with one founder and a few crew members on the road are not held back by spreadsheet limits. They are held back by other things.

What spreadsheets break at

Spreadsheets fall apart at specific friction points. Once you start hitting these regularly, the spreadsheet has stopped being an asset and started being a liability.

Two people editing at once

Even with cloud-saved Excel or Google Sheets, the moment two people try to edit the same row simultaneously, conflicts happen. Your colleague writes "quote sent" while you are still typing "callback Monday" and one of you wins. Real CRM software handles concurrent edits properly with row-level locking, change history and notification. A spreadsheet does not.

Searching across thousands of rows

Excel's filter is fine for 100 rows. At 1000 rows it gets sluggish. At 10,000 rows it is unworkable. Worse, finding "every quote we sent to the Trent estate ever" requires searching multiple tabs, copying and pasting, and praying the colour-coding system is still consistent. A CRM treats the customer as a single entity with all related records on one screen.

Reminding you of things

Spreadsheets do not send reminders. Excel does not ping you on the morning of a quote follow-up. Google Sheets cannot text you that an insurance certificate expires next week. The closest you get is a "due date" column that you check manually. That manual check happens until it does not, and then critical things slip. CRMs send proactive notifications precisely because human attention is unreliable.

Tracking emails sent

You sent a quote on Tuesday. Did the customer open it? You have no idea unless they reply. Did your colleague follow up? You do not know unless you ask them. A CRM tracks every email sent, every open, every click, with a timestamp that lives forever on the customer's record. Spreadsheets cannot do this without manual updates that always get skipped.

Working on a phone

Spreadsheets on a phone are awful. Tiny cells, fat fingers, accidental edits. A good CRM is built phone-first with screen layouts that make sense for one-handed use in a van or on a roof. Trades work happens away from desks and the spreadsheet is a desk-bound tool.

Generating documents

You need to send a branded quote. From your spreadsheet, that is "open Word, find the template, copy the data row by row, save as PDF, attach to email, hope the formatting did not break". From a CRM, that is "click Send Quote, choose template, hit send". The time saving compounds across hundreds of quotes a year.

Onboarding a new team member

Spreadsheets carry the founder's mental model of how the business works. New team members spend weeks figuring out what the colour-coding means, why this tab is named "John's stuff", and what the rules are for filling in column G. CRMs come with a structure that makes the workflow obvious.

Disputes and audit trails

A customer claims you never quoted £24,000 for that job. Your spreadsheet says you did - if you remember to write it down. A CRM has the email open record, the click record, the version history, the timestamps. When disputes happen and they will, the CRM is the side of the conversation with proof.

Compliance documents

Insurance, accreditations, RAMS, training records, vehicle MOTs - tracking these in a spreadsheet works until you forget to update one. The day you forget is also the day a contractor asks for proof and you have nothing live to send. Compliance-aware CRMs (like Complys) treat these as live records with expiry alerts built in.

The specific signs you have outgrown the spreadsheet

Watch for these in your week. Two or more is "almost certainly time to switch". Three or more is "you have been ready for months but not noticed".

You found yourself searching the inbox for a quote you sent because the spreadsheet had it but you forgot which tab.
You sent a quote twice or quoted the wrong number because the spreadsheet had two entries for the same customer.
A document expired without being renewed because nobody noticed.
A customer accused you of not following up and you could not prove you had.
You spend more than 30 minutes a week tidying the spreadsheet itself rather than using it.
Your colleague has their own version of "the spreadsheet" because they did not like yours.
You have started using WhatsApp and a spreadsheet together because the spreadsheet is too clumsy for live updates.
You forgot to send a quote because the customer's enquiry was on a sticky note that fell off your monitor.
You missed a follow-up that turned into a lost job and the lost job would have paid for a year of CRM subscription.

What you would gain from switching

Cards on the table. A CRM gives a UK trades business:

Time back. Sending a quote drops from 15 minutes to 2 minutes. Logging a call drops from "I will write it down later" to 10 seconds.
Lost-job recovery. Most CRMs show paid-back-by-month-three because of jobs you would have lost without follow-up reminders.
Professional appearance. Branded quotes, hosted public links, automatic delivery tracking. The customer thinks you are bigger and more organised than you are.
Compliance peace of mind. Insurance and accreditation alerts before they expire, not after.
Team scale. Adding a second admin or estimator does not break the system. Adding a 30-strong workforce does not break it either.
Audit trail. When disputes happen, you have proof.

What you would NOT lose

Worth saying clearly. Switching to a CRM does not mean losing the spreadsheet flexibility, the local control, or the cost savings. Modern CRMs:

Export everything to CSV at any time. Your data is not held hostage.
Cost £30 to £100 per month for a whole trades business, not the £600+/month that big-team enterprise CRMs charge.
Take an afternoon to set up, not a week. Import your customer CSV and you are running.
Live in the cloud so you and your team can access from any device, anywhere with signal.

When to stay on the spreadsheet

Honest answer: if you have under 30 active customers, you are running the business solo, you are not yet sending more than 2-3 quotes a week, and your compliance is genuinely simple, the spreadsheet may still be the right tool. The hidden cost of CRM software is the time spent not running your business while you set up and learn it. For a single-person business handling small volume, that cost can outweigh the benefit.

The moment you hire a second person, or hit 50+ customers, or send 10+ quotes a week, the spreadsheet starts costing more than a CRM does.

How to switch without losing your mind

The painful part of switching is mostly imagined. Here is how it actually goes.

Export your spreadsheet to CSV. Most CRMs (including Complys) accept CSV import. 5 minutes.
Create your CRM account. Sign up. Confirm email. Done. 5 minutes.
Import the CSV. Map columns to fields. The CRM tells you what fits where. 15 minutes.
Add your first quote. Send it from your real email. Watch it track. Realise this is going to work. 10 minutes.
Tell the team. Send them the URL and the password. Show them where to log calls. 30 minutes.

Total time: about an hour. The whole switch happens in one afternoon. The team takes a couple of weeks to fully form new habits, but they can use the new system from day one.

Why Complys is built for this transition

Complys imports CSV customer data, gets you set up, and has your first quote sent within the first hour. The 90-day free trial includes full feature access so you can run a real customer through the system before paying anything. After day 90, plans start at £30/month for the whole business (no per-user pricing).

Beyond the standard CRM features (customer database, quote pipeline, email integration, call logging, follow-up reminders), Complys adds the compliance side that trades businesses actually need: insurance tracking with expiry alerts, AI-generated RAMS in 30 seconds, worker passports, training matrix, GPS clock-in, and live compliance sharing with main contractors. One platform replaces three or four old ones.

See the Complys CRM features or start the 90-day free trial and import your spreadsheet today.

FAQ

What about Google Sheets - is that better than Excel?

Google Sheets is better at concurrent editing and works on phones a bit better than Excel. It is still a spreadsheet though. None of the structural problems (no reminders, no email tracking, no audit trail) are solved by switching from Excel to Google Sheets.

Can I keep the spreadsheet AND have a CRM?

Yes, but most people stop using the spreadsheet within 2 weeks because the CRM does the same job better. Some keep the spreadsheet for ad-hoc analysis or specific lists the CRM does not handle. That is fine.

Will my team actually use the new CRM?

The honest answer is: only if it is faster than what they were doing before. Spreadsheets are slow to maintain but free, so people stick with them. CRMs that are slower or more complicated than spreadsheets get abandoned. CRMs that are faster (3 clicks to log a call instead of 5 minutes typing into Excel) get adopted naturally.

Is my data safe in a cloud CRM?

Modern UK cloud CRMs have higher security than the average laptop. Your data is encrypted, backed up, and protected by 2-factor authentication. The bigger risk is the spreadsheet on a laptop that gets lost in the back of a van.

Related guides

Do you need a CRM for your construction business? - the original 9-minute guide to whether a CRM makes sense for a UK contractor
CRM for trades: the UK guide for 2026 - prices, features and what actually matters when choosing a trades CRM
Construction CRM software UK: a buyer's guide for 2026 - what to look for, what to avoid, and real prices for UK construction
CRM vs spreadsheet for tradespeople: when to make the switch - honest comparison and the specific signs you have outgrown the spreadsheet