Do I need a CRM? The signs, and when a spreadsheet is enough
Do I need a CRM for my small business? A ten-minute test, the signs a shared spreadsheet has stopped working, and the problems a CRM will not fix.
Written by OpenRated Team If you have typed "do I need a CRM for my small business" into a search box, you already know what came back: mostly pages written by companies that sell one, about half of them ending in a free trial. That is a poor place to make a decision. This post gives you a test you can run in ten minutes on the conversations you have open today, the signs that a shared spreadsheet has stopped doing the job, and the honest cases where it has not.
The short answer, since a page that hides it is wasting your time: you need a CRM when more than one person needs the same customer's history, and the follow-ups have started to slip. Until then, a spreadsheet and a disciplined inbox are enough. The rest of the post is how to tell which side of that line you are on.
What a CRM does that a spreadsheet cannot
Strip the marketing off and a CRM (customer relationship management software) is three things joined together: a record for every person and company you deal with, the history of every conversation with them, and a list of what is due next. A spreadsheet can hold the first. It holds the second only if someone types it in. It can do the third only if someone builds it and keeps it current, and it will never remind anyone.
The part that matters in practice is the email sync. A CRM that connects to your Gmail or Outlook mailbox files each message against the right contact on its own, so the history builds without anyone doing data entry. That single feature is the reason a CRM gets used and a "notes" column does not: the notes column depends on the busiest person in the business remembering to fill it in at the end of the day.
Everything else on the feature list (a pipeline board, forecasts, dashboards, automation, quotes) is built on those three things. If you do not need the three, you will not use the rest.
Do I need a CRM for my small business? Four questions first
Answer these on paper, with real numbers from today. Each one points at a spreadsheet or at a CRM, and the tally at the end is your answer. The thresholds are this post's own judgement rather than a study's finding, so treat them as a starting point.
1. How many open conversations do you have right now? Count every lead or customer you have spoken to who has neither bought nor said no. Under about 20, with one person handling them, a spreadsheet is fine: you can see all of it on one screen. Past 50, or past 20 per person, nobody can hold it in their head and the sheet stops being scanned.
2. How many people need to see the same customer's history? One: spreadsheet. Two or more who both talk to customers: this is the question that decides most cases. A shared spreadsheet gives two people the same list, not the same conversation.
3. What happened the last time someone was away for a week? If nothing, because everything they were working on was visible to the person covering, you do not need a CRM yet. If a lead went quiet because the thread lived in one inbox, you have your first sign.
4. How is the next follow-up chosen? By memory, by scrolling the sheet, or by a list of what is due today? The first two work up to roughly the number in question one. When the honest answer is "whoever emailed most recently gets a reply", follow-ups are being chosen by the customers, not by you.
Two or more answers pointing at a CRM means you are ready for one. One means you are close, and the spreadsheet routine later in this post buys you a few more months. Zero means keep the spreadsheet and put the money elsewhere.
The test on two made-up businesses
Both of these are invented to show the test working, so the numbers are illustrative. First, a three-person joinery firm: the owner quotes, one fitter also takes calls, and an office manager sends the invoices. On the day they count there are 34 open quotes across the two people who quote, so question one is borderline. Question two: all three need the history, because the office manager cannot invoice without knowing what was agreed. Question three: the owner took a week off in July and two quotes were never chased; one went to a competitor. Question four: follow-ups happen when a customer rings. Three answers point at a CRM, and the July week, more than the count of open quotes, is what gave it away.
Now an equally hypothetical freelance designer with eight active clients and two proposals out. One person, eight relationships she can recite, follow-ups done on a Friday from a list in the sheet. Zero answers point at a CRM, and one would be an expensive way to store eight names.
Signs your business has outgrown the spreadsheet
The test above is the deliberate version. These are the same signs as they show up in a normal week, in rough order of how early they appear. Three of them and you have already answered the question.
The signs arrive in roughly this order, and the costly one arrives last: a lost deal you hear about from the customer.
"Where are we with them?" gets answered by searching email. The relationship lives in inboxes, and the spreadsheet is a summary somebody last updated a while ago.
Two people contacted the same lead in the same week. Or worse, sent two different prices. The sheet told neither of them the other had been in touch.
A deal was lost because nobody followed up, and you found out from the customer. The sign that costs the most, and the one that arrives last.
The notes column is wider than the screen, and there is a tab called "old". The sheet is a database and a diary at once, and it is bad at both.
You cannot say how many quotes are out, or what they add up to, without an hour's work. Reporting breaks first, because it needs every row current at the same time.
A new starter needs a day of someone explaining where things are. The system lives in someone's head rather than in a file.
Revenue, headcount and "you are growing" are left off that list on purpose. Plenty of five-person businesses with long, repeat relationships run happily on a spreadsheet, and plenty of two-person businesses with a hundred short-lived leads a month cannot. What decides it is the shape of the conversations; the size of the company is a weak guide.
When a spreadsheet is still enough
Most of the pages that rank for this query give this part a paragraph at most, because the company writing them does not benefit from it. A spreadsheet is the right tool when:
One person talks to customers, and will for the next year. Every question in the test collapses to that one.
The relationships are few and long. A consultancy with a dozen clients on retainer knows each one by name. There is no pipeline to manage, so pipeline software has nothing to do.
Sales are transactional and the shop already holds the record. People ask whether they need a CRM with an online store, and the answer is no until you start doing something the order history does not cover. Your store platform already keeps every customer, every order and the email address that goes with them. The moment you add wholesale accounts, quotes, or outreach to people who have not bought yet, the question changes.
The volume is real but the follow-up is not. A cafe does not follow up with a customer; it hopes they come back. A loyalty scheme and an email list serve that, and a CRM does not.
A spreadsheet does not run out of room, either. Microsoft's own Excel specifications and limits page puts a worksheet at 1,048,576 rows by 16,384 columns, and Google's Drive limits page puts a Sheets file at up to 20 million cells (both read 2026-09-24). No small business will fill either. What runs out is people: the sheet fails when a second person needs it to say what the first one did, and no number of rows fixes that.
If you are staying on the spreadsheet, make it last. One row per open conversation. A "next step" column with a date in it, and the sheet sorted by that date every Monday morning. Nothing deleted, only moved to a "closed" tab with the reason. That is most of what the first month of a CRM gives you, for nothing, and it is exactly the data you will import when the day comes.
What about building your own?
"Can I build my own CRM" is a question people really ask, and the honest answer is that the building is cheap and the keeping is not. A spreadsheet with a form on the front and a few scripts, or a low-code database tool, can look like a CRM by Sunday evening. What it will not have is the email sync, the mobile app, the duplicate check, or anyone to call when it breaks; and when the person who built it leaves, so does the manual. Build one if the business is unusual enough that nothing off the shelf fits it. Never build one to save the price of a seat.
What it costs, and what not having one costs
Three routes, with a worked cost. The figures are round numbers chosen to make the comparison visible, not any vendor's price list; every CRM's entry price is on its own pricing page, and it changes without notice.
The cash cost is the small number on each route. The real cost is the second line, and it is paid whether or not you notice it.
Route | Cash cost | The real cost | Right when |
|---|---|---|---|
Shared spreadsheet | None | The hours spent searching email, and the follow-ups that slip | One person sells, or the relationships are few and long |
Free CRM plan | None | Caps on seats or contacts; the upgrade arrives with the next hire | Two or three people, testing whether a CRM gets used at all |
Paid CRM, per seat | Illustrative $20 a seat a month: $60 a month for three, $720 a year | Setup, the import, and a month of double entry | The test says yes and more than one person will use it every day |
The arithmetic for the joinery firm: three seats at the illustrative $20 is $720 a year. One quote lost in one July week was worth more than that, and if the CRM saves one chased follow-up a quarter it has paid for itself. That is the honest case for a CRM: one recovered follow-up against one seat's price, in your own numbers. One of the vendor pages that ranks for this query makes the case with percentages instead (27% more retention, 29% more revenue, "up to 300%" more lead conversions), each attributed to a "CRM statistics" roundup post rather than to a study you can open, which is why none of them is printed here as a fact.
Free plans deserve a word. Many CRM vendors offer one, and "Free CRM plan" is one of the 18 rows every product on OpenRated's CRM software listing is compared on, so you can see at a glance which have one. The catch is in plain sight: the free tiers on the vendor pages that rank for this query stop at two or three users, and one at 1,000 contacts, so the price to plan for is the first paid tier rather than zero.
What to look for, if the answer is yes
"What do I need in a CRM" is the next search, and for a small business the answer is shorter than the feature lists suggest. The CRM listing judges every product on the same 18 rows. Five of them do the job on day one:
Two-way email sync with Gmail and Outlook. Without it, the CRM is a spreadsheet with a login. This is the row to check first.
Contact and company records, with duplicate detection and merge, so the import from your sheet does not create two of everyone.
A visual sales pipeline, one column per stage, so "how many quotes are out" is a glance rather than an hour.
Activity and task logging with reminders, so the next follow-up is chosen by a date and not by memory.
A native mobile app, if anyone sells away from a desk. A fitter in a van will not log a call on a laptop that evening.
Rows you can ignore in year one: territory assignment rules, weighted pipeline forecasts, custom objects, and a REST API. They matter at 20 seats. Paying for them at three is how "easiest CRM to use" becomes the search you run next year, because the easiest CRM is the one with the fewest things your team has to ignore.
What a CRM will not fix
A CRM does not create leads, and it does not make anyone follow up. It makes the follow-up visible, which is a different thing. If the two people who talk to customers will not log what they said, the CRM becomes a more expensive spreadsheet within a month. The email sync is the only feature that lowers that risk, because it does the logging for them.
It will also cost you a month. Exporting the sheet, cleaning it, deciding what the stages are called, and running both systems while people get used to the new one is real work, and the businesses that abandon a CRM usually did so in that month. Plan for it, do the import in a quiet week, and make the spreadsheet read-only on a fixed date rather than keeping both alive.
The one thing to do
Run the four questions on this week's numbers. Zero or one pointing at a CRM: tidy the spreadsheet the way described above and check again in six months. Two or more: compare products on the rows that matter to you at the CRM software listing, and start with the email sync column. The wider software categories index holds the neighbouring kinds of tool a CRM is often confused with, which is worth a look before you pay for the wrong one.
