When a spreadsheet stops being enough to hold your leads

The file called leads, and the other one called leads final

It starts sensibly. Somebody opens a sheet, adds a name column and a number column, and for a while it is the best record the business has ever had. Then a second person needs it, so a copy goes out on WhatsApp. Somebody adds a column for city because they were doing a delivery run. Somebody else adds one for source because of an ad campaign that ended nine months ago. A version with the word final in the filename appears, followed shortly by another.

The tell is not the mess. The tell is that people have stopped acting from it. When a salesperson picks up their phone and works from memory instead of opening the file, the sheet has quietly become a place where leads are stored after the decision, not a place where the decision gets made. At that point it is an archive with a misleading name.

None of this means spreadsheets are the wrong tool. It means this particular sheet was never given a job it could do.

What a spreadsheet is genuinely good at

Be fair to the tool before replacing it. A sheet costs nothing, everyone in the building already knows how to use one, it belongs to you rather than to a vendor, it can be shaped in an afternoon, and you can export the whole thing in one click if you ever move. Those are real advantages and a surprising number of businesses give them up too early.

What a sheet cannot do is the part people quietly expect it to do. It will not tell anyone that a customer has been waiting six days. It handles two people typing in the same row badly. It keeps no history, so when a number changes there is no record of who changed it or when, and the argument that follows has no evidence in it. It accepts a phone number in six different shapes without complaint, which means you can never reliably match a row to a chat.

Above all, a sheet is a list of what happened. Selling needs a list of what to do next, and those are different documents.

Six signs you have outgrown the sheet

Any one of these on its own is fixable. Three or more together usually means the sheet is now costing more attention than it saves.

• Two people have to agree who is editing before either of them opens it
• Nobody can tell you what changed in it last week
• The same customer appears more than once under slightly different spellings
• Someone maintains a private list on their phone because they do not trust the shared one
• Reporting from it means a manual clean up first, every single time
• A follow up gets missed and there is no way to tell whether the sheet was wrong or whether nobody looked

The free fix: five columns and a next action date

Before spending anything, try running the sheet with real discipline for a month. This is not a compromise version of a system. It is the smallest thing that actually works, and plenty of businesses never need more than it.

Cut the sheet down to five columns and refuse to add a sixth without a conversation. Name. Number, stored one way, with the country code, every time. What they asked for, in the customer's own words rather than a category. Date of last contact. Next action and the date it is due.

The next action column is the whole trick. Every morning, sort by that date. Everything at or before today is your work list, and when the list is empty you are finished, which is the first time a sheet has ever told anyone that. A row without a next action date is not a lead, it is a note, and it should either get a date or get marked closed.

Three rules keep it alive. One named person owns the file and is the only one who deletes anything. New rows arrive through a short form rather than by typing directly into the grid, so the format cannot drift. The status column uses data validation with a fixed list, so nobody invents a new status on a Tuesday.

• One owner, named, who is the only person allowed to delete a row
• New enquiries entered through a form, never straight into the grid
• A locked list of statuses, agreed once, changed rarely
• Numbers stored in one format so a row can be matched to a chat later
• A morning sort by next action date, which is the only report anyone needs

What a real system adds, and when it is the wrong answer

The things a proper lead system gives you are precisely the things a sheet cannot. It remembers on your behalf and chases the person who owes a reply. It keeps a history of every change, so a disagreement has evidence. It connects the row to the actual conversation, so the chat, the call and the quote sit together. And it produces the same number twice, which no manually cleaned sheet has ever reliably done.

None of that is worth buying before the process exists. This is the mistake worth naming plainly: if nobody fills in the sheet today, nobody will fill in a system tomorrow. Software does not create the habit of writing things down. It only makes an existing habit faster and harder to lose. A business that installs a lead system on top of a sheet nobody updates ends up paying a subscription for the same empty rows in nicer colours.

There are also businesses where the sheet is simply the correct answer and should be left alone. If your enquiries arrive at a pace two people can discuss out loud every morning, the coordination cost of a system is higher than the coordination it saves.

If your sales cycle is one conversation and one delivery, there is nothing to track between the two. And if you are about to change how you sell, or add a channel, wait until that settles, because encoding a process you are replacing next quarter is work you will throw away.

A lead list sorted by what happened is an archive. A lead list sorted by what is due today is a job.

If the five columns hold for a month, keep them

The free fix is not a lesser version of a system, and the honest recommendation is to run it with your own team for a month before spending anything. Five columns, a next action date, and one person who works the date column will beat most software a business of this size could buy, because the discipline is the mechanism rather than the software. Where it holds, keep it in-house permanently. Where it collapses in the second week, you have learned something worth more than the month cost you.

The thing a sheet gets right, and the thing to insist on from anything replacing it, is that it belongs to you. Whatever gets built sits in accounts under your own logins with an export that actually works, so you own the system and the lead history stays reachable if the arrangement ends. A lead record you cannot get out of a supplier's product is a worse position than the sheet you were escaping from.

What a system adds is the remembering, and the remembering is where the stop belongs. It chases whoever owes a reply and it stops the moment the lead responds, handing it to a person rather than sending a third message. Any price outside the published list, any complaint and any negotiation wait for human approval. A lead system that holds conversations with customers on its own is a different purchase from the one described here, and it is worth knowing which of the two is being quoted.

The published version of this is Patel Group, where growth had outrun the systems, leads were being managed informally and follow ups were missed, and an AI driven CRM was built around exactly those bottlenecks. Culligan Pakistan, delivered through East River, took 140 leads in a single month behind the same kind of layer. Haad owns growth and client solutions at Wobble, which works from Karachi, bills month to month and carries 25 engagements across six countries.

Common questions

How many leads a month before a spreadsheet stops working?

Volume matters less than how many people touch the record and how long the sale takes. A single person handling a large volume of same day sales can run a sheet indefinitely. Three people sharing a slow, multi step sale will break a sheet at a much lower volume, because the failure is in coordination rather than in row count.

Can Google Sheets remind me to follow up?

Not on its own in a way anyone will notice. You can approximate it with conditional formatting that colours any next action date at or before today, which turns the sheet into something you can scan in seconds. That is enough for one person. It stops working when the reminder needs to reach somebody who is not looking at the file.

Should each salesperson keep their own sheet?

It removes the editing conflicts and creates a worse problem, because the business no longer has a single view and nothing is portable when someone leaves. If people need their own space, give them a filtered view of one shared file rather than separate files. The record should belong to the company, not to the person holding it.

What columns do I actually need?

Name, number in a single format, what they asked for in their own words, the date you last spoke, and the next action with its due date. Anything else should have to justify itself. Every extra column is another field somebody leaves blank, and a sheet with blank columns teaches everyone that the sheet is optional.

We bought a CRM and nobody uses it. What now?

Go back to the sheet for a month and get the discipline working there first, because the failure is almost never the software. Find out which single field people refuse to fill in and why. Usually it is a field that helps management and does nothing for the person entering it, and a system built entirely of those fields will be abandoned no matter what it cost.