Most businesses start tracking leads the same way: a spreadsheet, a phone notes app, or a dog-eared notebook. There is nothing wrong with that. The problem is not where you track leads. The problem is what you track and whether the system survives contact with a real sales team.
This guide covers what a leads sheet is, what it should contain, when to stick with one versus moving to a CRM, and the mistakes that turn a useful tool into a spreadsheet graveyard.
What is a leads sheet?
A leads sheet is a structured document – usually a spreadsheet – that records every potential customer your business is actively in conversation with. It captures the basics: who the person is, where they came from, what they need, and where they sit in your sales process.
It is not a database of cold contacts you bought online. A leads sheet tracks active prospects – people who have raised their hand in some way. Filled out a form, responded to an ad, came through a referral, attended a webinar.
The key word is active. If nobody on your team is going to do something about a contact in the next 30 days, they should not be on your leads sheet. Move them somewhere else. Your sheet should only contain people worth acting on.
What a leads sheet should actually capture
A good leads sheet has seven columns. Not twenty-three. Seven.
- Name and contact details – full name, phone, email. That is it.
- Lead source – where did this person come from? Paid ad, referral, organic search, cold outreach?
- Business type or industry – what do they do and what sector are they in? This changes how you talk to them.
- Lead status – new, contacted, qualified, proposal sent, closed won, or closed lost.
- Next action – what happens next and who is responsible. This is the column most sheets are missing.
- Notes – one or two sentences from the last conversation. What is their real problem?
- Date added – so you can see how long a lead has been sitting without movement.
That is it. If you find yourself adding columns for “LinkedIn followers” or “estimated company revenue” before you have even spoken to the person, you are building a research project. Not a sales tool.
Leads sheet vs CRM – which should you use?
A leads sheet is better than a CRM until it is not.
Use a leads sheet when:
- Your team has fewer than three people managing leads
- You are handling fewer than 40 active conversations a month
- You do not yet have a repeatable sales process you run for every deal
Move to a CRM when:
- Leads are falling through because two people assumed the other was following up
- You cannot see, at a glance, where every active deal sits right now
- You have no idea which lead source is converting and which is burning budget
The transition point is usually around 50 active leads a month. Before that, a well-maintained sheet beats a neglected CRM every time.
The mistakes that kill most leads sheets
Too many columns. Every extra column you add is another reason not to update the sheet. Keep it under ten fields until you have a specific reason to add more.
No “next action” field. A sheet without a next action is just a contact list. The whole point is knowing what needs to happen tomorrow morning.
No date on the next action. “Follow up” is not an action. “Call Thursday at 11am” is. Without a date, it will not happen.
Shared but not managed. Everyone adds to the sheet but no one owns it. Assign one person to review it weekly and flag any lead that has been sitting in the same status for more than ten days with no update.
Not sorting by status. Sort by lead status every Monday morning. New leads at the top. Dead leads at the bottom. Your team should see what needs attention first, not scroll past twenty closed deals to find the three that are still in play.
From leads sheet to a proper pipeline system
A leads sheet is a starting point, not a ceiling. As your pipeline grows, you will want something more structured – a way to see not just contacts but the health of your entire sales funnel. How long deals take to close. Which lead sources convert at what rate. Where conversations typically fall apart.
That is when a structured lead tracker becomes important – either a more organised version of your spreadsheet, or a lightweight CRM with proper pipeline views.
If your sheet is full but your calendar is not, the problem is usually not the system. It is the quality and volume of leads entering it. Our lead generation service is built specifically for that – putting qualified, ready-to-talk prospects into your pipeline so your sheet actually has something worth working.
Book a free strategy call and we will map your current funnel, find where leads are getting lost, and tell you honestly what the right next move is.