Simple CRM for Small Business: When the Spreadsheet Stops Working
Paul Boards ·
A spreadsheet stops working as a CRM when more than one person handles the same contacts, when nobody can say when a lead was last contacted, and when you have to ask someone to find out how much is in negotiation. At that point, a simple CRM solves it: a pipeline with stages, a history for each contact, forms that feed the pipeline automatically, and a conversion report.
For a small business, "simple" means the team starts using it the same week, with no consultants and no dozens of required fields. This article helps you recognize when it's time to switch, set up the minimum pipeline, and migrate the spreadsheet without losing the contacts it holds.
Five signs the spreadsheet has hit its limit
1. Two people called the same lead
A spreadsheet shows the state as of the last update, not the state right now. At a custom furniture store with two salespeople, all it takes is one forgetting to mark the row for the customer to get two different quotes on the same day.
2. The history lives in the salesperson's head
If the salesperson goes on vacation, the deal stalls. What the customer asked for, what discount was offered, and when they said they'd get back should be recorded on the contact, visible to whoever takes over.
3. Website leads arrive by email and get lost
The website form sends an email, and someone copies it into the spreadsheet when they remember. A lead that waits too long for a reply goes cold. In a CRM, the form creates the card directly in the first pipeline stage.
4. Nobody knows the conversion rate
You know how many customers you closed this month, but not how many contacts they came from or at which stage the others dropped off. Without that, you can't tell whether the problem is a lack of leads or weak proposals.
5. The spreadsheet has turned into a file with several versions
"Leads_final_v3_updated" is the clearest sign. When everyone has their own copy, there's no single source of truth anymore.
What a simple CRM needs to have
Many small businesses give up on CRM because they pick a system built for fifty-person sales teams. The useful minimum is much smaller.
- A pipeline with stages you define. For example: new contact, conversation started, proposal sent, negotiation, won, lost.
- History for each contact. Notes, date of last contact, and owner.
- Public forms. That you place on your website and that create the lead in the pipeline.
- Tags. To separate source, product of interest, or region.
- Conversion report. How many came in, how many moved forward, and how many closed.
- Control over who sees what. Salespeople see their own accounts, managers see the team.
The Scrumboards CRM includes a pipeline with customizable stages, public forms you can embed on your site, outreach scripts, tags, and conversion reports.
Set up your pipeline in an afternoon. Create the stages, paste the form on your site, and watch the first lead come in on its own. Create my sales pipeline for free.
Spreadsheet or CRM: what changes day to day
| Situation | With a spreadsheet | With a simple CRM |
|---|---|---|
| A lead fills out the website form | Arrives by email, someone copies it | Becomes a card in the first pipeline stage |
| A salesperson goes on vacation | Deals stall | Whoever takes over reads the contact history |
| The manager wants to know what's in negotiation | Asks in the group chat | Checks the "negotiation" column in the pipeline |
| A lead goes quiet after the proposal | Nobody notices | A card stuck in the stage stands out |
| End of the month | Manual totals and conflicting versions | Conversion report by stage |
How to set up the minimum pipeline
Start with six stages at most. Each stage needs a clear entry criterion that anyone on the team applies the same way.
- New contact: came in through the form, a referral, or a phone call.
- In conversation: the contact has replied.
- Proposal sent: there's a price in writing.
- Negotiation: the customer asked for a change or a condition.
- Won: formal acceptance or payment.
- Lost: with the reason noted.
The loss reason is the field that teaches you the most. After three months, it shows whether you lose on price, on timing, or on slow replies.
Example: a language school
The school has a trial-class form on its website. Each sign-up lands in "new contact" with a tag for the language. The front desk calls, moves it to "in conversation," and books the class. After the class, the coordinator sends the enrollment proposal and the card moves forward. At the end of the semester, the report shows that English converts well and Spanish stalls at the proposal stage. The school revisits the price of the Spanish package instead of buying more ads.
How to migrate the spreadsheet without losing contacts
- Freeze the spreadsheet. Pick a day after which nobody edits it anymore.
- Clean up duplicates. Sort by phone and email and merge repeated rows.
- Sort by stage. Add a column with each contact's pipeline stage.
- Bring over only what's alive. Contacts with no reply for more than a year can stay archived in the spreadsheet.
- Assign an owner. Every active card needs an owner.
The first week of use
A CRM sticks when it becomes a habit, and habits form from a few rules repeated every day. Agree on three of them with the team before you start.
- Every new contact goes into the pipeline the same day. Phone call, referral, or Instagram message, the source doesn't matter.
- Every conversation gets a short note. Two lines are enough: what the customer wants and the agreed next step.
- Every Friday, fifteen minutes of pipeline review. The manager goes through cards that have been stuck for more than a week and decides with the owner whether to advance, follow up, or mark as lost.
In the first few weeks, outreach scripts help people who are new to handling leads. Write the message that works best as a first reply to a lead and keep it available in the CRM, so a new salesperson doesn't have to start from scratch. After a month, compare the conversion report with what you estimated in the spreadsheet. The difference is usually surprising, one way or the other.
When the CRM needs to talk to the rest of the business
Closing the sale is half the work. Then comes delivery and getting paid. If the CRM is isolated, someone re-enters the customer in the task system and in finance. In Scrumboards, the same workspace has projects and tasks for delivery and a finance module with transactions, categories, and bank accounts. LEX, BrainPilot's sales intelligence agent, works with the access of whoever made the request. See the modules together on the features page.
Frequently asked questions
What is the best CRM for a small business?
The one your team uses every day. To start, all you need is a pipeline with stages, contact history, a website form, and a conversion report.
How many customers do you need before switching from a spreadsheet to a CRM?
The number matters less than the number of people. With two or more salespeople working the same customer base, the spreadsheet already causes conflicts.
Do I need to pay to get started?
Scrumboards has a Free plan with no credit card required. Paid plans are listed on the pricing table.
Can I put the form on my website?
Yes. The CRM's public forms can be embedded on your site and create the lead in the pipeline.
Does each salesperson see only their own leads?
You can restrict access by role and by assignment, so each person sees what belongs to them.
Get your pipeline out of the spreadsheet
Start with the website form, which is where the spreadsheet loses the most leads. Open a free CRM and connect your first form. To see the rest of the platform, visit the Scrumboards website.