Straight answer: yes, you can manage a CRM using just Excel, and for a solo operator or a team of two or three, it will work better than most of the paid tools you’re being sold. The trap isn’t Excel itself, it’s that spreadsheets fail silently, not loudly, so you often don’t notice the damage until you’ve already lost three months of follow-ups.
What a CRM is for (strip away the marketing)
A CRM does four jobs, nothing more. It stores who your contacts are, it tracks what stage they’re at, it reminds you when to follow up, and it shows you the total value of what’s in your pipeline. Salesforce, HubSpot, Pipedrive, they all wrap those four jobs in dashboards and automation. But the four jobs themselves are just rows, columns, dates and a filter. Excel does all four without breaking a sweat, provided your list stays a manageable size and only one person needs to touch it at a time.
I say this having built and sold plenty of CRM strategy to clients over the years. Most of them didn’t need what they bought. They needed a spreadsheet and a Monday morning habit.
The spreadsheet I ran my business on for two and a half years
When I rebuilt my consultancy from scratch, I didn’t touch a paid CRM for the first two and a half years. I ran everything, speaking enquiries, consulting leads, podcast guest requests, on a single Excel workbook with one main tab. It had 340 rows by the time I finally moved to something else, and it did the job well enough that I nearly didn’t bother switching at all.
The columns were plain: Name, Company, Email, Source, Stage, Deal Value, Last Contact, Next Action, Next Action Date, Notes. That’s ten columns. I colour coded the Stage column (New, Contacted, Proposal Sent, Won, Lost) using conditional formatting, so a glance at the tab told me where everything stood. Every Monday morning, first task, I filtered by Next Action Date and worked through anything due that week. It took about twenty minutes. That habit, not any software, was what kept deals from going cold.
How to build one (twenty minutes, no plugins)
If you want to try this yourself, here’s the exact build, step by step.
- Open a new sheet and set up columns: Contact Name, Company, Email, Phone, Source, Stage, Deal Value, Last Contact Date, Next Action, Next Action Date, Notes.
- Turn the range into a Table (Insert > Table). This gives you automatic filtering and stops your formulas breaking when you add rows.
- Set up Data Validation on the Stage column with a fixed dropdown list: New, Contacted, Qualified, Proposal Sent, Won, Lost. This stops six people typing “proposal”, “Proposal sent”, “sent proposal” and you losing the ability to filter cleanly.
- Add conditional formatting on Next Action Date: red if the date is in the past, amber if it’s within three days, no colour otherwise. This single feature does 80 percent of the “reminder” work a paid CRM charges you for.
- Build one Pivot Table on a second tab that sums Deal Value by Stage. That’s your pipeline value at a glance, updated the moment you refresh it.
- Add a simple formula in a helper column:
=TODAY()-[Last Contact Date]. Anything over 30 in that column is a contact going cold. Sort by it once a week.
That’s the whole system. No macros required, though if you’re comfortable with them, a small VBA script or a Power Query refresh can automate the weekly sort. For anyone who’s already built other structured Excel documents, an invoice template in Excel uses the same table and formula logic, so the skills carry over directly.
Where Excel holds up
Under about 200 to 300 active contacts, one user at a time, Excel is not a compromise, it’s arguably the better tool. You have zero monthly cost, complete control over the structure, and no learning curve for anyone who already knows spreadsheets. I’ve seen freelance consultants, single-location shop owners, and early-stage coaches run their entire client relationship process this way for years, and it worked because their volume never demanded more.
If you’re already tracking project timelines alongside your client list, the same discipline applies. A Gantt chart in Excel uses the same row-and-date logic as a CRM tab, just applied to tasks instead of contacts, which is why so many small consultancies run their whole operation, contacts, projects, and expenses, out of one linked workbook.
Where it quietly breaks (and nobody warns you)
Here’s the part most guides skip. Excel doesn’t fail with a crash or an error message. It fails through drift. Two people open the same file from a shared drive, both edit it, and one version silently overwrites the other. Nobody notices for six weeks, until someone asks “did we ever follow up with that lead from March?” and the answer is buried in a version that got overwritten. I’ve watched this happen to a client running a small property lettings business: two staff members both used the “master” spreadsheet, saved local copies during a system outage, and when they merged the files back the newest 40 rows from one copy simply vanished. Nobody had emailed those 40 leads in almost two months. That’s the uncomfortable bit nobody puts in the blog posts telling you Excel is “totally fine”: it’s fine right up until the moment it costs you real money, and by the time you notice, the damage is already done.
There’s no undo history worth trusting on a shared network drive copy of Excel the way there is in a proper database. No audit trail showing who changed what stage and when. No automatic reminder pinging your phone. Everything relies on a human opening the file and looking at it, which is exactly the kind of thing that stops happening the week you’re on holiday or slammed with three deadlines.
The size and headcount limit, in real numbers
From what I’ve seen across dozens of small businesses, the ceiling sits around these marks:
- Under 300 contacts, one editor: Excel works well.
- 300 to 1,000 contacts, one or two editors: Excel works but slows down, and duplicate entries start creeping in without a proper deduplication check.
- More than 1,000 contacts, or more than two people editing regularly: this is the point where a shared spreadsheet becomes a genuine liability, not a cost saver.
Once you’re above roughly 1,000 active contacts or you’ve got a sales team of three or more, the maths flips. HubSpot’s free CRM tier covers unlimited users and up to a million contacts before you pay a penny, and Pipedrive’s entry plan runs around 14 to 24 US dollars per user per month. At that point, the “free” spreadsheet is costing you more in missed follow-ups and duplicate data than the software would cost outright.
A middle path worth trying first
Before jumping straight to paid software, move your Excel file into Google Sheets. Same structure, same formulas, but now everyone edits the live version at once, changes are timestamped automatically, and you get a full version history you can roll back if someone fat-fingers a row. It costs nothing extra if you’re already on Google Workspace, and it fixes the single biggest failure mode of Excel CRMs, the silent overwrite, without you having to learn a new tool or migrate your data anywhere.
If your business has grown to the point where you’re managing this alongside expenses and reimbursements too, the same table-and-formula approach carries across cleanly, an expense report template built the same way sits happily next to your contacts tab in the same workbook.
And if you’ve hit the ceiling and want someone to map out what replacing the spreadsheet should look like, rather than guessing and paying for software you’ll half use, that’s the exact kind of project I help small businesses work through as an AI implementation coach, matching the tool to the actual volume and team size instead of the marketing pitch.
Frequently asked questions
Can Excel really replace a CRM for a small business?
Yes, for a single user or a small team under roughly 300 contacts, a well-built Excel table with dropdown stages, conditional formatting, and a weekly review habit does the same core job as most paid CRMs, storing contacts, tracking stages, and flagging follow-ups.
What’s the biggest risk of using Excel as a CRM?
Silent data loss from multiple people editing the same file, plus the lack of any automatic reminder system. The spreadsheet doesn’t warn you when it fails, you only find out weeks later when a lead has gone cold with nobody noticing.
How many contacts is too many for an Excel CRM?
Around 1,000 active contacts, or more than two people editing regularly, is the practical ceiling. Beyond that, the time lost to duplicates, version conflicts, and missed follow-ups usually costs more than a basic paid CRM would.
What should I switch to once Excel stops working?
Move to Google Sheets first if the main problem is version conflicts between two or three editors, since it’s free and fixes that specific issue. If you’ve outgrown the volume or need proper automation and reporting, a free-tier tool like HubSpot or an entry-level plan from Pipedrive is the natural next step.
