How to run a sales pipeline in Excel (and when to stop)
The five columns that matter
Most sales spreadsheets fail because they track too much and decide too little. A working pipeline needs five things per lead before anything else: the stage, the owner, the expected value, the date of the last contact and the date of the next follow-up. Everything else, including notes, is optional. If a column does not change what someone does tomorrow morning, it can go.
Stages should describe what the customer did
Write stages as facts you can verify: contacted, meeting held, quote sent, negotiating. Avoid stages like "interested" or "hot", because two people will never agree on them. Keep Won and Lost as the last two stages, and record lost deals honestly. A win rate that ignores lost deals is a guess, and our comparison of CRM and Excel explains why this number is the first to go wrong in a spreadsheet.
The follow-up date is the whole system
A lead without a next follow-up date is a lead nobody owns. The template's status column exists for one reason: every morning, the red rows are the calls that should have happened already. Clear them before anything else. If the list of red rows keeps growing, the problem is capacity or discipline, not the sheet.
Mistakes that break a sales spreadsheet
- Several copies of the file on different laptops, each slightly different.
- Free text where a dropdown belongs, so the totals stop matching.
- Deleting lost deals instead of marking them, which hides the real win rate.
- Leads that live only in a salesperson's WhatsApp and never reach the file.
- Nobody owns the file, so nobody cleans it.
When Excel is no longer enough
Excel works well for one to three people who sell and update the file themselves. The signs that you have outgrown it are clear: two people edit at the same time and overwrite each other, you need reminders that reach people instead of waiting for someone to open the file, managers want to see each person's pipeline without asking, or most of the conversation happens on WhatsApp and never gets logged. At that point a CRM system pays for itself, and the move is easier than it looks: the same columns become the import file. Our guide to moving from Excel to a CRM covers the cleanup step by step, and if WhatsApp is where your deals happen, read about a WhatsApp CRM next.