Spreadsheet or CRM: signs you've outgrown it

You need a CRM when your sales spreadsheet stops telling you the truth. That usually happens when more than one person works the same customers, when follow-ups depend on someone’s memory, or when you can’t say what will close this month without asking around. A spreadsheet is a fine place to start. It just wasn’t built to remind anyone of anything, to keep the history of a conversation, or to stay right while three people edit it.

Below are the signs we see most often, a quick test you can run this week, and how to move without losing anything.

When is a spreadsheet still fine?

For a sole trader or a two-person team with a few dozen live customers, a well-kept spreadsheet is hard to beat. It’s free, everyone knows how to use it, and you can shape it however you like. If one person owns it, updates it the same day and checks it every morning, keep it.

The trouble starts when the sheet becomes shared, and the business starts depending on it.

Seven signs you’ve outgrown the spreadsheet

1. There are several versions. “Leads final v3” lives on someone’s laptop, another copy sits in a shared drive, and nobody is sure which is current.
2. Follow-ups happen when someone remembers. There is a “next action” column, but nothing tells anyone when it’s due. Good leads go quiet because nobody chased them.
3. The history lives in inboxes. To see what was said to a customer, you search three people’s email. The sheet shows a status, not the conversation.
4. Two people call the same customer. Or nobody does, because each assumed the other had it.
5. You can’t answer “what closes this month?” Not without a meeting, a filter and some guessing.
6. Someone leaves and takes the pipeline with them. Their contacts, notes and promises were in their head and their mailbox.
7. Updating the sheet has become a job. People copy details from emails, web forms and calls into rows by hand, and some of it never makes it in.

If three or more of these sound familiar, the spreadsheet is costing you deals, even if you can’t see which ones.

Run a one-week test

Before buying anything, try this:

• Count the chases. For one week, note every time someone asks “did anyone get back to them?” or “where are we with this one?”
• Check the gaps. Pick ten live opportunities. For each, can you see the last conversation and the next step with a date? Note how many you can’t.
• Time the update. Ask the team how long they spend each week keeping the sheet current, including copying from email.

The answers tell you whether the problem is the tool or the habit. If the sheet is complete and current and nobody chases, you don’t need a CRM yet. If it isn’t, a better spreadsheet rarely fixes it, because the missing piece is reminders and history, not columns. Our post on why leads go cold covers the follow-up habits that matter whichever tool you use.

What a CRM does that a spreadsheet can’t

• One record per person and company, with every call, email and note attached, so anyone can pick up where a colleague left off.
• Reminders. A follow-up with a date becomes a task in someone’s day, not a cell in a column.
• A pipeline you can see. Deals sit in stages you define, so the month ahead is a glance, not a meeting.
• Several people at once, each seeing what they should, with no version to overwrite.
• Less copying. Forwarded emails and imports land on the right record, and your website forms can be connected on request.

That is what we built Nine Kites Rapport around: contacts, deals and follow-ups done well, shaped to the way a small team already sells.

How to move without losing anything

1. Write down your stages. How does a lead become a customer in your business? Four to six stages is plenty. Use your own words.
2. Clean the sheet. One row per contact, one column per field, consistent company names, dates in one format, duplicates removed.
3. Decide what history to bring. Open deals and the last note on each matter most. Five years of closed rows can come later, or not at all.
4. Import, then check together. Look at ten records as a team before anyone starts using the CRM for real.
5. Retire the sheet on a set date. Two systems running side by side is how the old problems come back.

Most of the work is the thinking in steps one and two. A good CRM setup starts there, not with the software.

Questions to ask before you choose a CRM

• Does it fit our stages and our words, or do we bend to fit it?
• What does it cost when we hire three more people, and does the price follow headcount or use?
• Where does our data live, and can we export all of it whenever we like?
• Can it take our web form enquiries and forwarded emails without copying by hand?

If you’re weighing up a CRM and would rather own one shaped to how you sell than rent one per person, see how Rapport works.