Home Tutorial Pricing Contact
Language
Start Free

Lead Tracking Spreadsheet Template The columns, stages and formulas that actually work

A free spreadsheet can run your pipeline for a while. Here is how to build one in Excel or Google Sheets, and the moment it starts costing you deals.

CRM · · 6 min read
Key takeaways
  • 11 core columns cover everything: company, contact, email, phone, source, stage, owner, value, next action, date and notes
  • Six pipeline stages (New, Contacted, Qualified, Proposal, Won, Lost) keep every lead in exactly one place
  • COUNTIF, SUMIF and a TODAY check turn a flat list into a live dashboard with overdue alerts
  • A spreadsheet scales to roughly 300 to 500 leads and one or two people, then a CRM pays for itself
Definition

What is a lead tracking spreadsheet?

A lead tracking spreadsheet is an Excel or Google Sheets file with one row per lead and columns for company, contact, source, pipeline stage, deal value and next action. It lets a small team see who to follow up with and where every deal stands, with zero software cost, until volume outgrows it.

It is the most popular first version of a customer relationship management system. Before any team buys software, they almost always start with a sheet, and for good reason: it is free, flexible and everyone already knows how to use it. The structure mirrors a real sales pipeline, just rendered in rows and columns instead of a dedicated app.

It works because most teams begin with a discipline problem. According to Vonsel internal data (2026), the average paying team enriches a new lead list every nine days, which a spreadsheet handles fine, right up until two people edit the same file at once.

Build it

How to build the spreadsheet, step by step

You can build a working tracker in under 15 minutes. These six steps map one to one to the HowTo above:

1

Create the core columns

One row per lead. Add company, contact name, email, phone, source, stage, owner, deal value, next action, next action date and notes.

2

Define your pipeline stages

Decide the path a lead travels and write it once. Six stages cover most B2B sales without overcomplicating the sheet, and every lead sits in exactly one of them.

3

Add data validation dropdowns

Turn stage, source and owner into dropdown lists with Data Validation. Free-typing "Qualified" and "qualified" breaks every formula; dropdowns keep values clean and filterable.

4

Add tracking formulas

Count leads per stage, total pipeline value and flag overdue follow-ups automatically. The formulas are in the table below, copy them straight in.

5

Build a one-row summary dashboard

Add a small block above the data with total leads, leads per stage, weighted pipeline value and overdue count. This is your at-a-glance pulse every morning.

6

Set a weekly hygiene routine

Once a week, update stages, clear closed deals, fix overdue actions and kill duplicates. A tracker is only as honest as your last update, much like using Google Sheets as a CRM at any scale.

Skip the blank spreadsheet, start with real leads
Search Maps, collect published website contacts and organise your prospects in the CRM. Free extraction covers 200 businesses a month; AI and export depend on your plan.
Start Free
The stages

Pipeline stages: the six columns of status

Keep stages simple. Every lead should be in one, and only one, stage at all times so your COUNTIF math always adds up to your total:

New › Contacted › Qualified › Proposal › Won / Lost

This is a textbook sales process compressed into a dropdown. If you sell across very different deal types, add a "Nurture" stage for long-shot leads, but resist the urge to invent ten micro-stages: the more granular the list, the less reliable the data entry.

The columns

The 11 columns every lead tracker needs

ColumnWhat it holdsWhy it matters
CompanyBusiness nameThe unit you actually sell to
ContactDecision maker nameWho you address and follow up with
Email / PhoneVerified contact detailsThe whole point of the list
SourceWhere the lead came fromTells you which channel pays off
StageNew to Won/Lost dropdownDrives every dashboard formula
OwnerRep responsiblePrevents leads falling between people
ValueEstimated deal sizeFeeds your pipeline forecast
Next action + dateWhat to do, and whenThe single most ignored, most important pair
NotesContext and historyYour only memory in a flat file

A spreadsheet will not remind you when that next action date arrives, log the email you sent, or stop two reps from chasing the same company. Customer database software exists to fill that gap.

The formulas

5 formulas that turn a list into a dashboard

These work identically in Excel and Google Sheets. Assume your stage column is F, value is G and next action date is I:

GoalFormula
Leads in a stage=COUNTIF(F:F,"Qualified")
Pipeline value in a stage=SUMIF(F:F,"Proposal",G:G)
Win rate=COUNTIF(F:F,"Won")/(COUNTIF(F:F,"Won")+COUNTIF(F:F,"Lost"))
Overdue follow-ups=COUNTIF(I:I,"<"&TODAY())
Total open pipeline=SUMIFS(G:G,F:F,"<>Won",F:F,"<>Lost")

Then add one rule with conditional formatting: highlight any row where the next action date is earlier than today. Now your overdue leads turn red on their own.

11
core columns to track any lead end to end
~21%
of a rep's day lost to manual data work and admin (HubSpot sales research)
300-500
active leads before a spreadsheet starts dropping deals
The free part of a lead tracking spreadsheet is the file. The expensive part is every follow-up that slipped because nothing reminded you, and every deal two reps chased into the same dead end. Spreadsheets store leads; they do not move them.
Limits

Where a spreadsheet breaks (and what to watch for)

A spreadsheet is genuinely good enough for a solo founder or a two-person team running a few hundred leads. The trouble starts quietly. These four signals mean you have outgrown it:

No reminders

The next action date column is honest only if a human reads it every day. Miss a week and warm leads quietly go cold.

Version conflicts

The moment two people edit, you get overwrites, stale copies and "which file is current?". Shared sheets help but do not fully fix it.

No activity history

A notes cell is not a timeline. You cannot see who emailed when, what was said, or how many touches a deal took.

Duplicates creep in

Paste the same company twice and nothing stops you. At scale, deduping a sheet by hand becomes its own weekly chore.

For a deeper breakdown of these ceilings, our guide on the CRM Excel template and its limits walks through each one with examples.

A spreadsheet is a brilliant place to start tracking leads. It is a terrible place to scale them.
How Vonsel helps

From spreadsheet to a CRM that follows up for you

Search Google Maps and press Start. Vonsel gathers the business results as you explore the map, going beyond the pins you can see at a glance. Pause, continue and save your search when you are ready. Google Maps does not provide business emails. Vonsel visits the available business websites to find published emails, additional phone numbers and links to up to 118 supported social networks and other platforms. What it finds depends on what each website publishes. Keep businesses on a map, organise them by stage, edit their details and use a Kanban board, calendar, notes, actions, tags and custom fields. Basic holds 400, Pro 2,000 and Scale 10,000.

In short:

  • Start with the 11 columns, six stages and five formulas above, it is free and fast.
  • Keep it honest with a weekly hygiene routine and dropdown data validation.
  • Move to a CRM once you pass roughly 300 to 500 leads or add a second person.
Find local businesses with Vonsel
Search Maps, collect published website contacts and organise your prospects in the CRM. Free extraction covers 200 businesses a month; AI and export depend on your plan.
Start Free

If you would rather fill the sheet with real prospects than type them in, the Vonsel pricing page shows which plan fits your volume, and you can watch the tutorial video to see a Google Maps extraction from search to saved leads.

Frequently asked questions

What is a lead tracking spreadsheet?
A lead tracking spreadsheet is an Excel or Google Sheets file with one row per lead and columns for company, contact, source, pipeline stage, value and next action. It lets a small team see who to follow up with and where each deal stands without paying for software.
What columns should a lead tracking spreadsheet have?
The core columns are company, contact name, email, phone, lead source, pipeline stage, owner, deal value, next action, next action date and notes. Optional columns include industry, city, last contact date and close probability for a weighted forecast.
What pipeline stages should I use?
A simple, reliable set is New, Contacted, Qualified, Proposal, Won and Lost. Each lead sits in exactly one stage so you can count how many are in each step with a single COUNTIF and spot where deals get stuck.
What formulas should a lead tracker include?
Use COUNTIF to count leads per stage, SUMIF to total pipeline value per stage, COUNTIFS for win rate, and a formula comparing the next action date to TODAY to flag overdue follow-ups in red with conditional formatting.
Is a spreadsheet enough to manage leads?
A spreadsheet works well up to a few hundred leads and one or two people. Beyond that, missing reminders, version conflicts and no activity history start costing deals, which is the signal to move to a CRM that automates follow-ups.
When should I move from a spreadsheet to a CRM?
Move when more than one person edits the file, when you pass roughly 300 to 500 active leads, when follow-ups slip through the cracks, or when you need automatic reminders, email logging and reporting that a manual sheet cannot provide.

Related reading

Sources

Recommended for you
CRM CRM Excel Template & Limits A free Excel CRM template and the exact point it stops scaling. CRM Google Sheets as a CRM Pros, cons and how far a Sheets-based pipeline really goes.
Discover more
Product Vonsel Features Google Maps scraper, map-based CRM, AI and one inbox.