Lead Scoring Spreadsheet Template: Build One in 5 Steps
A step-by-step lead scoring spreadsheet you can build in Google Sheets or Excel, with columns, formulas and thresholds.

A lead scoring spreadsheet is the fastest way to rank leads before you buy any software. You list your leads in rows, give each one points for fit and behavior, and sort by the total. The leads at the top get a call first. It takes an afternoon to build, and it works in Google Sheets or Excel.
This guide shows you how to build a lead scoring spreadsheet in five steps. You get the columns, a set of example point values, the formulas and a simple rule for when a lead goes to sales. The point values are examples. Replace them with numbers based on your own closed deals.
What is lead scoring?#
Lead scoring gives each lead a number that shows how likely they are to become a customer. Higher means more promising. The idea is described in general terms on Wikipedia's lead scoring page. Most models split the points into two groups:
- Explicit (fit) points. Who the lead is: job title, company size, industry, country.
- Implicit (behavior) points. What the lead does: visits the pricing page, replies to an email, requests a demo.
Fit tells you whether a lead could buy. Behavior tells you whether they are interested now. You need both.
Why start with a lead scoring spreadsheet?#
A spreadsheet has real advantages for small teams.
- It is cheap. You already own the tool.
- It is transparent. Everyone can see why a lead scored 70.
- It is easy to change. You edit a number and the scores update.
- It teaches you what matters. You learn which signals predict wins before you automate them.
When you outgrow it, you can move the same rules into your CRM. The lead scoring spreadsheet is the design document.
Step 1: Set up the columns#
Create one sheet called Leads. Add these columns:
- Name
- Company
- Job title
- Company size
- Industry
- Country
- Last activity date
- Pricing page visited (yes or no)
- Replied to email (yes or no)
- Demo requested (yes or no)
- Fit score
- Behavior score
- Penalty
- Total score
- Status
Keep one lead per row, and keep every column to one kind of value. Free text makes scoring hard.
Bad email addresses ruin the list from the start. Before you score anything, run the Email column through the Tomba Email Verifier, and fill gaps with the Tomba Email Finder.
Step 2: Create a points table#
Add a second sheet called Rules. List each criterion and its points. Here is an example you can copy and change.
| Criterion | Value | Points |
|---|---|---|
| Job title | Director or above | 20 |
| Job title | Manager | 10 |
| Company size | In your target range | 15 |
| Industry | In your target list | 10 |
| Pricing page visited | Yes | 15 |
| Replied to email | Yes | 20 |
| Demo requested | Yes | 30 |
| Email type | Personal mailbox | -10 |
| Email type | Competitor domain | -50 |
These values are illustrative. A published guide may show different numbers, and that is fine. Your own win and loss data is the only source that matters.
Give the highest points to actions that sit closest to a purchase. A demo request is stronger than a blog visit.
Step 3: Add the scoring formulas#
Now connect the Leads sheet to the Rules sheet. In the Fit score column, use a lookup for each fit criterion and add the results. A simple version in Google Sheets looks like this:
- Job title points:
=IFERROR(VLOOKUP(D2, Rules!A:C, 3, FALSE), 0)once your rules table has a lookup key column. - Yes or no signals:
=IF(J2="yes", 20, 0)for a reply,=IF(K2="yes", 30, 0)for a demo request. - Total score:
=L2 + M2 + N2.
If the lookup feels heavy, start with plain IF formulas and move to the table later. The important thing is that each rule lives in one place, so a change reaches every row.
Sort the sheet by Total score, descending. You now have a ranked list.
Step 4: Add penalties and decay#
Two features make a lead scoring spreadsheet more honest.
Negative scoring. Subtract points for signals that a lead is a poor fit: a personal email address, a competitor's domain, a company far outside your target size, an unsubscribe. Put the result in the Penalty column.
Decay. Old activity should count for less. Add a rule that removes points when a lead has gone quiet. For example, subtract 5 points for every 30 days since the last activity date:
=-5 * INT((TODAY() - H2) / 30)
Without decay, a lead who visited your pricing page a year ago still looks hot. Cap the decay so the score cannot fall far below zero.
Step 5: Set thresholds and a handoff rule#
A score is only useful when it triggers an action. Add a Status formula with clear bands:
- Hot: at or above your sales threshold. Send to a rep right away.
- Warm: between the two thresholds. Keep nurturing with email.
- Cold: below the lower threshold. Leave it in the list.
Pick the first threshold by looking at past customers. Score a sample of your closed-won deals and your lost deals, then choose a line that separates them well. Agree with sales on the line, so both teams trust the result. A shared definition of a qualified lead is the heart of a good handoff.
How do you keep your lead scoring spreadsheet accurate?#
A model drifts as your market changes. Review it on a schedule.
- Compare scores with outcomes. Do high scorers close more often? If not, change the weights.
- Look for false positives. Which high scorers never bought? Add a penalty for what they share.
- Look for misses. Which buyers scored low? Add points for what they share.
- Refresh your ideal customer profile. Your best customer next year may differ from today.
- Keep data fresh. Enrich old records so job titles and companies are current. The Tomba Enrichment tool helps with this.
Frequently asked questions#
What is a good lead score?#
There is no universal number. A good score is one that separates your past customers from the leads who did not buy. Set the line from your own data.
Should I use Google Sheets or Excel?#
Either works. Google Sheets makes sharing easy, and Excel suits teams that already work in it.
How many criteria should I include?#
Start with five to ten. A long list is hard to keep accurate, and you can add more once the basics work.
When should I move to a CRM?#
Move when you have enough leads that manual updates slow you down, or when you want scores to update from live activity. Take your points table with you.
Start with clean leads#
A lead scoring spreadsheet fed with bad data gives you confident, wrong answers. Verify and enrich your leads first. Create a free Tomba account and score only the contacts you can actually reach.
// start free
See who Tomba finds at any company
Type a company's domain to see its people, their roles and verified work emails, each with the pages it was found on. Free account, no card.
Free plan · No credit card required · GDPR & CCPA
// about the author