The sales spreadsheets that fail are almost always the long ones. Somebody has an idea, a column appears, and six months later nobody can see the leads for the columns.
We build a CRM, but we’ll say it plainly: a well-kept spreadsheet is a fine way to start selling. The skill is in keeping it short. And what you track here is exactly what you’d want in a CRM later, so none of this is wasted if you move on. (Our guide to moving from Excel to a CRM shows how it carries across.)
One test for every column
Before you add a column, ask what you’ll do differently because it’s there. If the answer is “call this person first”, “send a quote” or “chase on Thursday”, it earns its place. If the answer is “nothing, but it might be useful one day”, leave it out.
A sales sheet exists to decide who to contact next and what to say. Anything that doesn’t help with that belongs somewhere else.
The columns that earn their place
For most small teams the whole sheet is these eleven: company, contact, phone, email, source, owner, stage, value, last contact, next action and next action date.
Source matters more than people expect. Record it from the first lead and within a few months you’ll know which channels produce customers and which only produce enquiries. Owner matters because a lead with no named person is a lead nobody is calling.
The last two columns are the valuable ones, and the ones most often missing. Without a next action and a date, a sheet is a list of names. With them it becomes a to-do list that tells each person who to contact today.
A few extras are worth having if you’ll actually use them. A reason-lost column, even one word, becomes a quietly useful pattern after a few months. A “product of interest” column helps if you sell more than one thing. Everything else, add later.
What to leave out
Long notes in a cell are the usual culprit. A cell is a poor home for a conversation. Notes pile up, nobody can tell who wrote what or when, and the row grows until it fills the screen. Keep a short next action in the sheet and put the longer story somewhere with dates.
Colour coding feels helpful until you remember that colours mean different things to different people, and you can’t filter or count them. A stage column does the same job and can be sorted.
Then there are the columns nobody has filled in for a month (delete them), the same fact held in two places (one will go stale) and the clever calculated column that only one person understands. That last one is how you end up with a sheet that nobody but its author can run. If you can’t explain a formula in a sentence, take it out.
Habits that matter more than the columns
A good layout won’t rescue a sheet that’s used badly. These are the habits that make the biggest difference, in the order we’d introduce them.
Fill in the next action and date before you close a row. Every time, no exceptions. Sort by next action date each morning, and that sorted list is your day. Use drop-downs for stage and source, because free text gives you “Google”, “google” and “Google ads” in one column and you can’t count any of them. Keep one version in one shared place, with one person responsible for keeping it clean, and never email copies around. Spend ten minutes each Friday archiving dead leads and finding rows with no next action. Move closed leads to a second tab so the working sheet stays short.
When a sheet like this is enough
It works well for one or two people selling, a few dozen live leads, a process with few stages and no need to restrict who sees what. In those conditions it costs nothing extra and does the job.
And when it isn’t
The edges of what a spreadsheet can’t do show up quickly once you’ve set it up properly. It can’t remind anyone that the next action date is today, which is what tasks and callbacks are for. It can’t keep a dated history of every call and email behind a row, which a lead profile does. It can’t show one person only their own leads. Filtering, saving views and working on twenty leads at once get awkward fast, which is the lead table’s job. And your own details, like fleet size or renewal month, become fiddly columns, where in a CRM they’re searchable custom fields.
If you’ve started to feel those, seven signs your sales team has outgrown its spreadsheet is worth ten minutes, and so is our straight comparison of spreadsheet vs CRM.
Starting from scratch? Copy this header row and adjust it: Company, Contact, Phone, Email, Source, Owner, Stage, Value, Last contact, Next action, Next action date. Put lost leads on a second tab with a reason.
Dates are the quiet hero
Most of a sheet’s value comes from its dates, and they’re the first thing to go wrong. Pick one date format and stick to it. Keep “last contact” and “next action date” as two separate columns, because they answer different questions: how long it’s been, and what’s due. If your spreadsheet lets you, add one rule that colours a row when the next action date has passed. It’s the only colour we’d recommend, and it works because it means the same thing to everybody.
Protecting the sheet
A shared sheet needs a few guards. Lock the header row so columns aren’t renamed by accident. Use data validation on stage and source so only the agreed options can be entered. Limit who can edit if it’s a large team, and keep a read-only copy for anyone who only needs to look. These small things stop most of the damage that makes people lose faith in a shared sheet.
If you’d like to see a sheet like this inside Henkan CRM, book a demo and bring yours.




