Spreadsheet or CRM: when a small business needs one.

The short answer

A spreadsheet is a list. A CRM, customer relationship management software, is a list that also remembers: who each person is, every call and email, who on your team owns them and what happens next, with a reminder when the next step is due. The question is whether your business needs that memory.

Stay with a spreadsheet while one or two people handle enquiries, everyone can see the whole list at a glance and nothing waits more than a day without someone noticing. Move to a CRM when follow-ups start to depend on someone's memory, because that is the part a spreadsheet cannot do for you.

The first automations to set up recommends a spreadsheet as the first home for enquiries, and it still is. This guide is about the point where you outgrow it. Before you buy anything, look at the software you already use: many trades and clinics have a CRM without calling it one.

Signs the spreadsheet has stopped working

If two or more of these sound familiar, it is time to look at a CRM:

• An enquiry sat for days because each of two people thought the other had it.
• Two of you called the same lead in one afternoon, or a customer got two different quotes.
• Nobody can say how many quotes are waiting for an answer without scrolling and counting.
• Most rows have no next action date, so follow-ups happen when someone remembers.
• A customer's history lives in one person's inbox, where nobody else can see it.
• Someone keeps a private list on the side because the shared sheet is too messy to trust.
• Colours in the sheet mean different things to different people.
• When the person who looks after the sheet is on holiday, follow-ups stop.

Size alone is not a sign. A spreadsheet with two thousand rows works if one person owns it and the follow-ups are kept. A sheet with forty rows fails if three people work it and nobody owns a row.

Check the software you already have

Many businesses already pay for a tool that keeps customer records, sends reminders and shows what is due. Use it fully before you add another one:

• Trades and cleaning companies often run on job software such as Jobber, which keeps each client's details, quotes, jobs, invoices and history in one record and can follow up quotes that get no answer.
• Salons, clinics and studios keep client records, visit history and notes in their booking software.
• Accountants and bookkeepers often have client records and task lists in their practice software.
• Online stores have every customer and order in the store platform.

If most of your customers already have a record in one of these, a separate CRM means two places to update and two versions of the truth. Ask instead what is missing, such as enquiries that never became jobs, and whether the tool you have can hold them.

A separate CRM earns its place when the selling happens before the booking or the job: quotes, proposals, site visits and calls that go on for weeks, as they do for builders, agencies, consultants and firms that sell to other businesses.

Or make the spreadsheet work harder first

If only one of the signs applies, a better spreadsheet may be enough. A shared Google Sheet, or an Excel file in Microsoft 365, works when it follows a few rules:

• One row per enquiry, one sheet for all of them, and no copies saved on laptops.
• Columns for the date, name, phone, email, where it came from, the service, the owner, the stage, the next action and the next action date.
• Dropdown lists for the owner and the stage, so nobody types Quote Sent in one row and quoted in another.
• A rule that colours a row when its next action date has passed.
• A filtered view for each person, showing only their open rows, oldest first.
• New enquiries added by the website form or an automation, so nobody copies them by hand.

Then look at it at the same time every day. A spreadsheet with a daily five-minute check beats a CRM nobody opens.

A three-person team, before and after

A bathroom fitting firm in home services has three people: the owner, who visits and quotes, a fitter, and an office manager who answers the phone. Enquiries arrive from the website form, phone calls and Facebook messages.

Before, the office manager added each enquiry to a shared sheet, and the owner kept his visit notes on his phone. In one week a customer was called twice by different people, a quote went unanswered for three weeks because nobody owned the follow-up, and nobody could say which enquiries came from the new Google Ads campaign.

After, each enquiry is a record in a CRM with five stages: new, visit booked, quote sent, won and lost. The website form creates the record with its source attached. The office manager books the visit, and the record moves to the owner, who adds his notes and photos from his phone after the visit, sends the quote and sets a follow-up date. If the date passes with no answer, the CRM reminds him, and the office manager can see it too. Each lost job gets a reason, such as price or timing.

On Monday the three of them look at one screen: what came in, what is waiting and why jobs were lost. The old spreadsheet stays, read-only, for the history. Saving the campaign with each enquiry is covered in how to track leads from Google Ads.

What a CRM costs a three-person team

CRMs publish their prices, so compare the plans yourself. These are what decide the bill for a team of three:

• Users. Most CRMs charge per user per month, so count everyone who needs to add or change records, including part-time office help.
• Free plans and their limits. HubSpot's free CRM covers up to two users and 1,000 contacts, so a third person who edits records pushes you onto a paid plan. Zoho CRM's free edition covers three users. Limits change, so check the vendor's page before you decide.
• The plan with the features you need. Automated follow-ups, web forms, email sync and custom fields often sit on a higher plan than the one advertised first.
• Add-ons such as texting, calling, e-signatures or extra storage.
• Connections. If the CRM has no ready-made link to your website form or booking tool, you need an automation platform or a developer to connect them.
• Your team's time to set it up, move the data, learn it and keep it tidy. It is the cost people forget, and it comes first.

Price the CRM for a year at the number of users you expect next year. Then work out what one extra won job is worth to you, and how many quotes went quiet last year. If the CRM saves a few of them, you can see whether it covers itself. If you want the website form and your other tools connected to it, our own prices for that are on the prices page.

What to check before you choose one

Try two or three with your own real enquiries rather than the demo data. Check that each one:

• Imports your spreadsheet as a CSV file and lets you match each column to a field.
• Exports everything back out, so you can leave later with your data.
• Works on a phone, for whoever is on site or between appointments.
• Connects to your email and calendar, so calls, emails and visits land on the record without copying.
• Can take enquiries from your website form, through a ready-made form, an integration or its API.
• Lets you set stages, required fields and who can see what.
• Says where it stores your data, if your customers are in Europe.
• Can sit on an account in the business's name, with more than one admin.

Pick the simplest one that passes. A CRM with more features than your team uses is harder to keep tidy, and an untidy CRM is a spreadsheet that costs more.

What to move first

Do not move the whole history on day one. Move what someone has to act on:

• Open enquiries that have not had a reply or a quote yet.
• Quotes sent and still waiting, with the date sent and the amount, so follow-ups start at once.
• Customers with something booked or due, such as a service visit or a renewal.
• Regular customers you want to keep in touch with.

Leave closed and old rows in the spreadsheet, set to read-only, and bring them across later if you need them. Before the import, clean the rows you are moving: remove duplicates, put phone numbers in one format, split full names if the CRM wants first and last names, and give every row an owner and a stage.

Switch over in one go

Running the spreadsheet and the CRM side by side for long means updating both, and soon neither is right. Plan a clean switch:

• Agree the stages and what each one means, in one sentence each.
• Set up the fields you need and no more. Every field nobody fills in makes the rest harder to trust.
• Import the open items and check a handful of records by hand against the sheet.
• Point the website form and any automation at the CRM, and send a test enquiry through each route.
• Pick a switch day. From that day new enquiries go only into the CRM, and the spreadsheet becomes read-only.
• Look at the open records together every day at first, then once a week, until the habit holds.

If someone keeps going back to the spreadsheet, ask what is missing: a field, a view or an easier way to add notes on a phone. Each of those can be fixed.

Rules that keep a CRM useful

• Every open record has an owner and a next action date. A record without a date is a record nobody will look at again.
• Calls and messages are logged on the record, not kept in someone's head or private notes.
• One person owns the CRM itself: the stages, the fields and who has access.
• Lost deals are closed with a reason, so you can learn from them.
• Nobody keeps a second list on the side.
• Duplicates are merged when they appear, not once a year.

Mistakes that make a team give up on a CRM

• Buying for the team you might have in three years. Set it up for the people you have now.
• Copying every column from the old sheet, including the ones nobody filled in.
• Stages named after the software's defaults instead of how your work runs.
• The person who quotes never updating a record. If they skip it, nobody else will keep it up either.
• Moving the whole archive first, so the first week goes on cleaning old data instead of answering new enquiries.
• Connecting five tools before anyone has used the CRM by hand.

Customer details in a CRM

A CRM gathers personal details in one place, which makes them easier to look after than a spreadsheet copied to laptops. Keep it that way:

• Store what you need to serve the customer and no more. A builder needs an address and access notes. Nobody needs a date of birth to quote for a kitchen.
• Give each person access to what their job needs.
• Record each customer's answer about marketing messages on their record, and make your emails and texts respect it.
• Know how to find, export and delete one person's records, because customers can ask, and in Europe the GDPR gives them the right to.
• Remove a leaver's access on their last day.

What you may store, for how long and on what basis depends on where you and your customers are. Ask whoever advises you on data protection before you import anything.

Connect it once it works

A CRM pays off most when nobody types into it what another tool already knows. Once the team uses it every day, connect it:

• The website form creates a record with the source attached.
• A new enquiry sends the owner an alert and the customer an instant confirmation.
• A quote with no answer by the follow-up date sends one polite follow-up, then a task for a person. How to follow up on a quote has wording to copy.
• A won job creates the booking or the job in your scheduling tool.
• A finished job triggers a review request.

Each connection depends on what both tools' APIs allow, so check before you plan around one. Enquiry follow-up shows the first two in detail, and Zapier, Make or n8n compares the platforms that connect them. We connect forms, inboxes and CRMs where their APIs allow, with an alert when a connection fails: see automation.