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

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

CRM · Updated June 2026 · 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 do not have a data problem at the start, they have 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:

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. That is the whole backbone.

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.

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.

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.

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.

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 any city or industry and export verified companies, emails and phones straight into your tracker, no manual data entry.

Start Free Trial

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

Column	What it holds	Why it matters
Company	Business name	The unit you actually sell to
Contact	Decision maker name	Who you address and follow up with
Email / Phone	Verified contact details	The whole point of the list
Source	Where the lead came from	Tells you which channel pays off
Stage	New to Won/Lost dropdown	Drives every dashboard formula
Owner	Rep responsible	Prevents leads falling between people
Value	Estimated deal size	Feeds your pipeline forecast
Next action + date	What to do, and when	The single most ignored, most important pair
Notes	Context and history	Your only memory in a flat file

Notice what a spreadsheet cannot do here: it will not remind you when that next action date arrives, log the email you sent, or stop two reps from chasing the same company. That gap is the whole story of customer database software.

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:

Goal	Formula
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, and the sheet starts to feel alive instead of static.

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. Here are the four signals that 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

When the sheet starts dropping deals, the Mapped CRM from Vonsel is the natural next step, the first CRM with a built-in GPS map, so your leads live on a map instead of in rows. It logs every email and call automatically, reminds you when a follow-up is due, flags duplicates and shows each deal's full history, the exact four things a spreadsheet cannot do. Feed it directly from Business Finder, which searches millions of verified businesses across 120+ countries with 85-95% email accuracy and 90%+ phone accuracy. Plans on the pricing page start at €17.99/month, and you get 20 verified leads when you start the free plan, enough to fill a tracker on day one.

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.

Fill your tracker with verified leads in minutes

Search any city or industry, export companies with verified emails and phones, then manage them on a map with Mapped CRM. See plans.

Start Free Trial

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.