Do you actually need a CRM, or would a well-run spreadsheet do?

Sooner or later, most growing businesses hear the same advice: "You really need a CRM." It might come from a software advert, a business adviser or a friend who swears by theirs.

It's a fair question to ask. But the honest answer for many established businesses is that they don't need one yet, and some never will. A well-run spreadsheet, or a shared inbox with clear habits, can handle more than people expect. A CRM earns its place when the way you work has genuinely outgrown those tools, not just because it feels like the grown-up thing to have.

This article is about the tool decision itself. If you're still working out what should happen to an enquiry once it arrives, start with our guide to what should happen after someone enquires through your website. The process comes first; the tool should fit around it.

What a CRM actually does

A CRM (customer relationship management system) is a shared, structured record of the people and businesses you deal with, and where each conversation is up to. In practice, most businesses use one to:

• keep contacts, enquiries and notes in one place rather than in individual inboxes
• track each enquiry or quote through a set of stages
• remind someone when a follow-up is due
• show the whole pipeline at a glance: what's new, what's quoted, what's won and what's gone quiet

None of that is magic. A spreadsheet can do a surprising amount of it. The difference is mostly in reminders, history, permissions and how well it copes when several people are working on it at once.

Signs a spreadsheet or shared inbox is enough

You probably don't need a CRM if most of these are true:

• One or two people handle enquiries and quotes. Everyone knows who is dealing with what, without having to ask.
• Volume is manageable. You can scan the list in a few minutes and see what needs attention.
• Follow-ups rarely slip. When they do, it's occasional, not a pattern.
• Your sales cycle is short. Most enquiries become a yes or a no within days or a few weeks, rather than dragging on for months.
• Repeat customers are easy to remember. You don't need a detailed history to serve them well.
• The information lives in one place. Even if that place is a single shared sheet.

If that sounds like your business, a better-organised spreadsheet will almost certainly give you more value than new software, at a fraction of the effort.

Signs you've outgrown it

On the other hand, these are the patterns that suggest a spreadsheet is starting to hold you back:

• Several people follow up, and it isn't clear who owns what. Customers get two replies, or none.
• Follow-ups are being missed. Not because people don't care, but because nothing prompts them.
• You have no clear view of the quote pipeline. You can't easily say how many quotes are outstanding, roughly what they're worth, or which have gone quiet.
• Information is scattered. Some details are in the sheet, some in individual inboxes, some on paper and some in someone's head. When that person is off, things stall.
• The spreadsheet has become fragile. Multiple versions, overwritten rows, columns nobody understands, and a general reluctance to touch it.
• Enquiries are retyped by hand. Every website form submission gets copied from an email into the sheet, and mistakes creep in.
• Longer relationships matter. Quotes that take months to decide, or repeat customers whose history genuinely affects how you serve them.

One or two of these on their own aren't necessarily a reason to buy anything. Three or more, recurring week after week, usually are worth taking seriously.

Try this first: tidy the spreadsheet

Before you spend money or time on a CRM, give a properly structured spreadsheet a fair trial for four to six weeks. Many of the problems people blame on "not having a CRM" are really problems of inconsistent habits, and those follow you into any software.

Set fixed columns

Agree one sheet, in a shared location, with the same columns every time. For example:

• Date received
• Name and business
• Contact details
• Source (website form, phone, referral, repeat customer)
• What they need
• Owner (one named person)
• Status
• Quote value, if quoted
• Next action
• Next action date
• Outcome and reason (won, lost, not a fit)

Use a short list of statuses

Keep statuses to a handful and use a dropdown so they can't drift. Something like: New, Contacted, Quote sent, Follow-up due, Won, Lost, Not a fit. If you find yourself inventing new statuses every week, that's a sign the process needs agreeing before the tool does.

Make every row have a next action

The single most useful habit: no open row without a next action and a date. Sort or filter by next action date, and the sheet becomes a to-do list rather than an archive.

Hold a weekly review

Set aside fifteen minutes a week, ideally with whoever handles enquiries. Go through anything overdue, anything quoted but quiet, and anything without an owner. Close off rows that are finished.

Then judge it honestly

After a month or so, ask: are follow-ups still slipping? Can we see the pipeline? Is anyone still keeping their own private list? If the tidy sheet has fixed the problems, you've saved yourself a software project. If it hasn't, you now know exactly what a CRM needs to do better, which makes choosing one far easier.

What to check before choosing a CRM

If you do decide a CRM makes sense, these questions matter more than any feature list.

Who will actually use it?

A CRM only works if the people handling enquiries keep it up to date. Involve them early, and be realistic about how much time they'll spend in it. A simple system everyone uses beats a powerful one that only the owner logs into.

Can you get your data out?

Your customer records belong to your business. Before signing up, check that you can export contacts, notes and history in a standard format, such as a spreadsheet file, at any time and without extra charges. Check what happens to your data if you stop paying, and whether there's a minimum contract term.

Will it connect to your website forms?

One of the main benefits is enquiries arriving already logged, rather than being copied across by hand. Check how your website forms would feed into it, what happens if that connection fails (enquiries should still reach an inbox as a fallback), and who will look after it. Our guide on what should connect to your website, and what shouldn't covers that decision in more detail.

Does it fit your process, or will you be bending to fit it?

Map your stages from the tidy-spreadsheet trial onto the system. If you'd need to change how you work just to suit the software, think carefully.

UK GDPR basics for contact data

Moving contacts into a CRM doesn't change your data protection responsibilities, but it's a good moment to check them. The ICO sets out seven data protection principles under UK GDPR, including keeping data accurate, secure and limited to what you need. In practical terms:

• Have a lawful basis for holding each type of contact data. The ICO's guidance on lawful basis explains the options.
• Tell people how you use their data, usually through a privacy notice linked from your website forms.
• Don't keep it forever. The ICO's guidance on storage limitation says you shouldn't keep personal data longer than you need it, and should review what you hold periodically.
• Control access. Make sure only the right people can see customer records, and remove access when someone leaves.

These apply just as much to a spreadsheet as to a CRM. If you're unsure about anything specific to your business, the ICO's own guidance is the place to check.

A worked example (hypothetical)

The following is an invented scenario, not a real business.

Imagine a long-established kitchen and joinery workshop in Dorset. The owner handles most enquiries, a designer prepares quotes, and an office manager looks after repeat customers and aftercare. Enquiries arrive through the website form, by phone and through referrals. Everything is tracked in a spreadsheet that has grown untidy over the years.

The owner has been told more than once that they need a CRM. Before buying anything, they tidy the sheet: fixed columns, a status dropdown, one owner per row, a next action date on every open enquiry, and a fifteen-minute review on Monday mornings.

Outcome one: after six weeks, follow-ups are no longer slipping and the owner can finally see which quotes are outstanding. For a business of this size, they decide the spreadsheet is enough and revisit the question in a year.

Outcome two: alternatively, the review shows that quotes often take months to decide, the designer and office manager keep separate lists, and website enquiries are still being copied in by hand. Here, a CRM connected to the website form starts to make sense. Because of the trial, the owner already knows the stages, the columns and who will use it, so choosing becomes much simpler.

Either outcome is a good one. The point is that the decision is based on how the business actually works.

The honest answer

Many businesses don't need a CRM, and there's nothing second-rate about running things well on a spreadsheet. Equally, a new website isn't automatically the answer to messy lead handling; sometimes the fix is behind the scenes, and sometimes it's a refresh rather than a rebuild. What matters is choosing the smallest change that solves the real problem.

At Westward Digital, we build websites and connected lead systems for established businesses across Somerset, Devon, Dorset, Bristol, and Bath & North East Somerset. Marcus plans the work directly, and Digital Discovery, our planning stage before a full build, looks at how enquiries reach you and whether a CRM is genuinely worth it. Projects start from £4,500, and if a tidy spreadsheet is all you need, we'll tell you.

If you're weighing up a CRM and want a straight answer on whether it's worth it, get in touch and tell us how you handle enquiries today.