What a CRM actually does
A customer relationship management (CRM) system is a shared record of your customers and prospects: who they are, what you discussed, what you promised, and what happens next. Most CRMs add three things on top of a contact list:
- A history. Every email, call and note attached to the person or company, so anyone on the team can pick up the thread.
- A pipeline. A view of deals by stage, so you can see what is likely to close and what is stuck.
- Reminders. A list of who to contact next, so follow-ups do not depend on memory.
What a CRM does not do: find you customers, fix an unclear offer or make a sales process that does not exist. It makes an existing process visible and harder to forget.
Five questions that decide it
Answer these honestly for the last three months. You are looking for patterns, not one-off mistakes.
| Question | If the answer is yes |
|---|---|
| Have you forgotten to follow up with someone who was interested? | You need reminders. A CRM or a disciplined task list both solve this. |
| Do you ever have to search several places to remember what you told a customer? | You need one place for history. This is the strongest reason for a CRM. |
| Does more than one person talk to customers? | Shared context becomes hard to keep in a spreadsheet. A CRM pays off sooner. |
| Do deals take weeks or months, with several steps? | You benefit from seeing stages and stuck deals. |
| Do you want to know which source brings your best customers? | You need consistent records of where each lead came from. |
As a rule of thumb, not a law: zero or one “yes” suggests you can wait. Two or three suggests starting small. Four or five suggests the cost of staying on a spreadsheet is probably higher than the cost of a CRM.
Signs a spreadsheet is no longer enough
- You keep several versions of the same sheet, and nobody is sure which is current.
- Notes about a customer live in email threads, text messages and a notebook.
- You lose time deciding who to contact today instead of just contacting them.
- A colleague needs to cover for you and cannot tell where each deal stands.
- Your sheet has so many columns that nobody fills them in consistently.
- You are managing a few dozen active relationships at once and some are slipping.
Signs you probably do not need one yet
- You have a small number of customers and know each one well.
- Most sales are one-off and finish in a single conversation.
- You work alone and a simple task list already tells you what to do each day.
- You do not yet have a repeatable way of selling. A CRM will not create one.
Adopting a CRM too early has a cost too: time spent configuring it, records nobody updates and a monthly bill for something you do not use.
What a good spreadsheet setup looks like
If you stay on a spreadsheet, make it work properly. A minimal setup that covers most of what small businesses need:
- One row per person or company, and one sheet for contacts.
- Columns for name, company, email, phone, source, stage, next action and next action date.
- A rule: no contact leaves a conversation without a next action and a date.
- A weekly ten-minute review: sort by next action date and clear the list.
If you already have contacts in a messy file, the CSV Cleaner, Duplicate Contacts Finder and CSV to Table help you tidy it, and the Sales Pipeline Designer helps you decide what your stages should be.
Three illustrative scenarios
These are invented examples to show the reasoning, not case studies.
A freelance designer with a handful of clients
She has around ten active clients and gets two or three new enquiries a month. A sheet with a next action column and a weekly review is enough. A full CRM would add overhead without solving a problem she has.
A two-person home renovation company
They get enquiries from phone calls, a website form and referrals. Quotes are sent, then nothing happens for weeks. Both partners talk to customers and keep losing track of who promised what. This is a good moment for a simple CRM: shared history, a pipeline of quotes and follow-up reminders.
A consultant with long sales cycles
Deals take three to six months and involve several meetings with different people at the same company. Here the history and stage view matter more than the number of contacts. Even one person benefits from a light CRM, because the risk is forgetting context over a long period.
What a CRM really costs
The subscription is only part of it. Plan for:
- Setup time: importing contacts, cleaning duplicates and creating your stages.
- Learning and habit: a CRM is only useful if people record things in it every day.
- Add-ons and integrations: email, calendar and forms often cost extra on some plans.
- Price changes: plans and prices change over time, so always check the vendor's current page.
The CRM Total Cost Calculator puts these together over one, three and five years, and the CRM ROI Calculator estimates what you might get back. Both use your own estimates, so treat the results as a planning aid, not a promise.
If the answer is yes, start small
- Write down what problem you are solving. For example: “no follow-up gets forgotten.” Judge any tool against that.
- Define five to seven pipeline stages that match how you really sell.
- Clean your contacts before importing: remove duplicates and fix emails and phone formats. The CRM Import Validator checks a file before you import it.
- Import a small batch first and check it before importing everything.
- Use it daily for two weeks before adding fields, automations or integrations.
The CRM Implementation Checklist walks through the same steps in more detail, and the CRM Migration Planner helps if you are moving from a spreadsheet.
Common questions
Is a free CRM enough?
Often, for a small team or one person. Free plans usually limit users, features or records, and those limits change, so check what the current plan includes against your list of must-haves.
How many contacts is “too many” for a spreadsheet?
There is no fixed number. The better signal is not size but behaviour: missed follow-ups, duplicated work and not knowing where a deal stands.
Will a CRM remind me to follow up automatically?
It will remind you if you record the next action and date. It cannot know what you promised unless it is written down.
Can I switch later?
Yes, and that is a good reason to start with a clean, consistent spreadsheet: a tidy file imports into almost any CRM, while a messy one makes any move harder.
A note on this guide
CoreCRMHub is exploring a free personal CRM, so we have an interest in this topic. That product is a concept and not available. This guide contains no product ratings and no affiliate links, and it is general guidance rather than a review of specific software.