How to track leads without a CRM, and when to stop

A simple way to track leads without a CRM, the rules that keep it working, and the warning signs that tell you it's time to move to something better.

You don’t need a CRM to track leads. Plenty of businesses sell well with a shared sheet, a few habits and some discipline, and if you’re early, short of budget or still working out how you sell, that can be exactly right.

This is how to do it so it actually works, and how to spot the moment it stops.

Start with the plainest tool you’ll really use

For most small teams that’s a spreadsheet in one shared place, either Google Sheets or an Excel file on a shared drive. Don’t start with anything clever. A plain table you update beats an elaborate system you don’t.

One row per lead. Company and contact, phone and email, where it came from, who owns it, the stage, the value, the last contact date, and a next action with a date. If you’re unsure what else belongs, what to track in a sales spreadsheet covers each column and what to leave out.

Get every lead in one place

The first thing that goes wrong is that leads arrive from everywhere: the web form, an email, a phone call, a business card, a referral over lunch. If each lands somewhere different, the sheet is incomplete before you start.

Make one rule and keep it. Every lead gets a row the day it arrives. Send form submissions to a shared inbox and have one person add them each morning. Write phone enquiries down straight away, while you remember them. Ask anyone who picks up a lead at an event to send it to the same person. And be strict about source, because a lead whose origin isn’t recorded can’t teach you which channels work.

A routine that keeps it honest

A sheet is only as good as the habits around it. Three do most of the work.

Every morning, sort by next action date. Anything due today or earlier is your call list, so start at the top. After every contact, update the row before the next call, not at the end of the day, changing the stage if it’s moved and writing the next action and date. And every Friday, give it ten minutes: look for rows with no next action, leads untouched for a fortnight and anything that ought to be marked lost.

If people forget to update it, that tells you something. Making it part of the routine rather than an extra job helps. If forgetting is constant, it’s a sign you’ve reached the point where you need something that reminds people.

Keep to a few rules as well. One version, in one place. One row per lead. Drop-downs for stage and source so your data stays consistent. A weekly backup. And closed leads moved to another tab so the working sheet stays short. Leads live in the sheet, not in email, because email is a channel and not a record, and a lead that only exists in an inbox can’t be seen by anybody else.

Faking what a CRM would do

You can approximate a few things with free tools. Calendar events or a shared to-do list stand in for reminders. A short dated note, or one document per key lead, stands in for history. A form that emails a shared inbox stands in for capture, which then has to be copied across by hand. A filter on the owner column shows who owns what. A monthly pivot table gives you something like reporting.

These are workarounds, and each is one more thing somebody has to remember to do. They hold up with a handful of leads. They get harder with every person and every lead you add.

The warning signs

Watch for several at once. Follow-ups slipping, so that you find leads nobody’s contacted for weeks. People asking “what did we say to them?” and nobody being able to answer quickly. Two people working the same lead without knowing it. Several versions of the sheet, or only one person who understands it. Proposals chased by hand with nobody sure which are open. Reporting that takes hours.

We go through these in seven signs your sales team has outgrown its spreadsheet, and the broader question is in spreadsheet vs CRM.

What changes when you move

The habits carry straight over. Your columns become fields. Your next action date becomes a callback or task that reminds the right person, and the notes column becomes a full history on the lead. The Friday clean-up mostly disappears because the system keeps things tidy.

In Henkan CRM, the lead table gives you the same list view you’re used to, with search, filters and saved views. Leads can arrive from a web form, or from any tool that can send a webhook, such as Zapier or Make, through capture, with the source recorded automatically. And our team imports your spreadsheet, so the work you’ve put in isn’t wasted.

How long can you manage?

It depends on how many people sell and how many leads are live. One person can manage without a CRM for a long time. Two or three sharing leads can manage with real discipline. Beyond that, the effort of keeping everyone in step grows faster than the team does.

A typical week, done well

Picture a team of two. On Monday morning one of them sorts the sheet by next action date and works through the overdue and due-today rows, updating each straight after the call. The web form enquiries from the weekend have already been added by whoever was on the inbox. By Wednesday new leads have owners and a first call. On Friday afternoon they spend fifteen minutes on housekeeping: three rows with no next action get one, two leads that’ve gone quiet for a month are marked lost with a reason, and a lead that’s worth keeping is moved to a “nurture” tab with a date to revisit.

Nothing clever happened there. It was the same few habits, repeated. That’s what works, and it’s also why it’s fragile: miss the routine for a busy fortnight and the sheet is stale.

What to do about email

Email is where leads quietly live. Make a habit of moving anything that matters into the sheet, and use one shared folder or label for lead conversations, so a colleague can find a thread without asking. It isn’t a replacement for a record, but it keeps the trail reachable until you’ve got something better.

When you do outgrow the sheet, lead management software and CRM software explained show what you’d be moving to.

There’s no shame in staying manual. The only real mistake is staying on a system after it’s started to cost you leads. If you’re getting close, book a demo and bring your current sheet.

See Henkan CRM set up around how you sell.

Book a demo and we will show you the product with your own sales process in mind.

Book a demo
  1. 01 Book a demo Tell us a little about your business.
  2. 02 See it around how you sell We show you the product with your sales process in mind.
  3. 03 We set it up for you Our team configures your account, from fields and stages to automations.