Sales Funnel Template: Free Google Sheet With Stage Conversion Rates

Publish date: Nov 17, 2026
A sales funnel template has one job: to show where your deals stop. This free Google Sheet logs each opportunity once, dates the five stages it reaches and works out the conversion rate between them.
Make a copy of the Sheet and keep the example rows in place while you read.
The Conversion tab comes seeded with Spona's own funnel. In one recent cohort of 437 opportunities, the last step leaked most: 77.7% of proposals had turned into a win so far. Your rate sits beside ours at every step, with the gap in points, and the file downloads to Excel with every formula working.
Get thousands of leads in 4 minutes.
Stop stitching tools together.
Start with verified sales data, delivered in minutes.
No contracts · No setup · No onboarding
Sales funnel template: one row per opportunity
Many funnel sheets count contacts. In B2B that bends every rate, because several people at one company weigh the same purchase. Forrester says a buying group may average five to seven individuals.
Forrester's own example shows the damage. Sales closes 25% of its opportunities, and marketing brought in three leads for each one. That makes 12 leads for one sale, a rate of about 8%. It is the same funnel, measured two ways.
So a row in this sheet is an opportunity: one possible deal with one account. That holds even though the input tab is called Leads. The people stay in your CRM, or in a CRM template if you have none yet.
Each row holds four dates and one outcome, and from those the sheet builds three things:
- Stage counts. How many opportunities reached each stage.
- Step rates. The share that moved from one stage to the next.
- Outcomes. Won, lost, no decision or still open.
One rule holds it together. An opportunity counts once in every stage it reached, so a won deal sits in all five counts. The counts overlap, which is why you never add them up.
B2B sales funnel template: five stages you can date
What are the stages of a sales funnel? In this sheet there are five: Created, Qualified, Meeting held, Proposal sent and Won.
The usual marketing answer is different. noCRM's guide, for one, lists awareness, interest, decision and action. Those describe a buyer's mood, and no rep can put a date on "interest". Our guide to the digital sales funnel covers that view.
A B2B funnel is narrower. It follows one account from a new opportunity to a signed order, and every stage is an event with a date:
| Stage | Counts as reached when | Entered on Leads in |
| Created | A unique opportunity exists, with a target account and an owner | Created date (column E) |
| Qualified | The owner has recorded fit and a specific buying problem | Qualified date (column F) |
| Meeting held | A discovery meeting actually took place; a booking alone does not count | Meeting held date (column G) |
| Proposal sent | A dated commercial proposal reached the buying team | Proposal sent date (column H) |
| Won | The buyer accepted an order or contract | Outcome (column I) |
These are the rules Spona's own CRM uses. Jesse Chan at Spona supplied them, together with the counts in the next section.
Five stages or seven? Salesforce says a funnel template includes "at least four to six core stages". This sheet holds five, and you can rename each one on the Stages tab. The count matters less than one test: can a rep put a date on the stage?
Meeting held is the strict one, and many SDR teams already work to that standard. The Bridge Group reports two separate median monthly SDR quotas: 10 meetings held and 6 first-stage opportunities. Both count what happened, not what someone booked.
Each row also ends in one of four outcomes: Open, Won, Lost or No decision.
Lost means the buyer chose another route, or you could not agree terms. No decision means the buying project closed without a purchase. Keep the two apart, because they need different fixes.
Spona's sales funnel: conversion rates from 437 opportunities
The green cells in the sheet hold Spona's own numbers. They come from one recent cohort: 437 opportunities in our CRM, created over four recent months.
| Stage | Reached | Rate from previous stage | Not advanced |
| Created | 437 | ||
| Qualified | 401 | 91.8% | 36 |
| Meeting held | 356 | 88.8% | 45 |
| Proposal sent | 292 | 82.0% | 64 |
| Won | 227 | 77.7% | 65 |
The rate drops at every step, and the last step leaks most. Of 292 proposals, 65 had not turned into a win.
That last rate is not final, because 93 opportunities still had no outcome when we counted. "Not advanced" therefore mixes lost deals, no-decision deals and deals still in play. For the proposals already sent, 77.7% is a floor.
The same goes for the whole funnel, where created to won stands at 51.9% so far.
Now look at how the same cohort ended, because it produces three different win rates.

Count only decided deals, won against lost, and Spona's win rate so far is 82.5%. Add the 69 no-decision deals to the denominator and it falls to 66.0%. Divide by every opportunity created and you are back at 51.9%.
Nothing about the deals changed. Before you compare a win rate with anyone, ask which one it is. The sheet prints all three, so you can say which one you mean.
This is one company's funnel, and it starts when an opportunity is created. The cold emails and calls before that point are not in it. Use it to check that your sheet works and to see what a real cohort looks like, not as a target.
How do you calculate funnel conversion rates?
Divide the number that reached a stage by the number that reached the stage before it. At Spona, 356 opportunities reached Meeting held out of 401 that reached Qualified. That is 88.8%.
Three choices decide whether the number means anything:
- Divide by the previous stage. Dividing every stage by the top of the funnel gives a share of created, which the sheet shows in its own column. It does not tell you which step leaks.
- Keep open deals in. A deal that reached Proposal sent has reached it, whatever happens next. The last step simply reads low until those deals close.
- Group by created date. A cohort is every opportunity created between two dates. Each deal counts once, in the period it began, however long it takes to close.
The Conversion tab does the counting with COUNTIFS, which returns the count of a range on several criteria at once. For Meeting held, it counts the rows with a Created date inside the cohort and a Meeting held date filled in. An IFERROR wrapper leaves the rate blank while the stage above is empty.
The overall rate needs no extra work. Created to won is won divided by created, and you land on the same figure when you multiply the four step rates together.
The same stage dates can also feed a forecast. The stage-weighted method in our sales forecast template uses a different rate. It divides the wins by the closed deals that reached each stage.
Setting up the funnel sheet in Google Sheets or Excel
- Copy it. Make a copy of the Sheet. For Excel, choose File > Download > Microsoft Excel.
- Check the Stages tab. Keep the five stages or rename them, and every tab follows. Add your own values to the Lead source, Owner and Segment lists.
- Fill the Leads tab. Use one row per opportunity. Type the date it reached each stage and leave the other date cells blank.
- Pick an Outcome. Choose Open, Won, Lost or No decision, and add an Outcome date for anything closed.
- Clear the amber cells. The Data check column flags rows such as "Dates out of order" or "Won without proposal date".
- Delete the examples. Select A2:K13 on Leads and press Delete. The grey formula columns empty themselves.
- Set the cohort. On Conversion, type a Cohort start and a Cohort end to read one month or one quarter.
The dropdowns are strict. Google Sheets rejects an entry that is not on the list, so add a new lead source on Stages before you use it. That keeps the Summary tables complete.
Leads fills three grey columns for you: Last stage reached, Days since last step and Data check. Days since last step counts from the newest stage date on an open deal, and it turns amber at seven days.
With the 12 example rows in place, Conversion reads like this:

The example's weakest step is Proposal sent to Won, at 57.1%. That is 20.6 points under Spona, and you should not believe it yet. Only 7 example deals reached a proposal, and the Margin column shows 36.7 points either way.
Margin is a rough 95% range around your own rate, based on how many deals sit behind it. It uses the simple formula that NIST describes as the most frequently used for a proportion, which is less exact on very small counts. A gap inside the margin may be noise, so wait for more rows before you act on it.
The Summary tab puts the result on one screen for the weekly meeting. It shows created, won and created to won beside Spona's figures. It names the weakest step and the largest shortfall, then splits the funnel by lead source and by owner. For the dials and emails that feed the top stage, use our sales KPI dashboard.
What is a good conversion rate from lead to customer in B2B?
Roughly 1% to 3%, going by one public dataset that splits the funnel into stages. First Page Sage publishes stage rates by industry from its client data. For the five industries below, they multiply out to 1.4% to 2.9% from lead to closed deal.
| Industry | Lead to MQL | MQL to SQL | SQL to opportunity | Opportunity to closed | Lead to closed (our estimate) |
| B2B SaaS | 39% | 38% | 42% | 37% | 2.3% |
| IT and managed services | 19% | 38% | 41% | 46% | 1.4% |
| Manufacturing | 26% | 41% | 46% | 51% | 2.5% |
| Financial services | 29% | 38% | 49% | 53% | 2.9% |
| Legal services | 32% | 35% | 48% | 46% | 2.5% |
MQL is a marketing qualified lead and SQL a sales qualified lead. The last column is our arithmetic, not First Page Sage's. Treat all of it with care. The figures come from anonymized client data, about 65% of those clients are B2B companies, and the report gives no sample size.
Do not set Spona's 51.9% beside this table. Ours starts at a created opportunity and theirs at a raw lead, and the stages differ too.
The benchmark that counts is your own last quarter. Run two cohorts in the sheet and compare them step by step.
Fix the leakiest sales funnel stage first
Conversion marks the weakest step in amber, and Summary repeats it. Start there and nowhere else, because each step leaks for its own reason.
Created to Qualified. A low rate means the wrong accounts enter the funnel, so fix the list before you touch the pitch. A written lead qualification checklist makes "qualified" mean the same thing for every rep.
Qualified to Meeting held. Either nobody books the meeting, or the buyer books it and does not show. The sheet counts held meetings only, so no-shows land here. Count them for a month before you change anything.
Meeting held to Proposal sent. The meeting took place and found nothing worth a proposal, which points at discovery.
Gong analyzed more than 519,000 B2B sales call recordings. Success peaked when reps asked 11 to 14 targeted questions. Our sales discovery questions give you a set to start from.
Proposal sent to Won. Here your main rival is often nobody.
Challenger cites research on 2.5 million recorded sales conversations, in which around half of all lost deals ended in no decision. Its range is 40% to 60%. In Ebsta and Pavilion's benchmark, reps blamed "indecision" for 61% of lost deals, though that figure is the reps' own reading of why they lost.
Spona's cohort points the same way. Of 117 deals that closed without a win, 69 ended in no decision. That is 59.0%. A win loss analysis tells you why those buyers stalled.
Stalled deals. One leak shows before a deal closes. In the same Ebsta data, more than 7 days of inactivity with nothing scheduled "reduces win rates by 65%". The sheet cannot see your emails and calls, so it counts open deals with no new stage date for 7 days or more. Chase those first on Monday.
Booked 60, won five: where the agency leaks
Take an agency that books 60 discovery calls a quarter and wins five clients. Which stage does it fix first?
Five of 60 is 8.3%, and that number cannot answer the question. It hides three steps, and it starts from booked calls, which are not a stage in this sheet.
So split the 60. Here is one way it could break down, as an illustration:
| Step | Count | Rate from previous step |
| Calls booked | 60 | |
| Meeting held | 45 | 75.0% |
| Proposal sent | 12 | 26.7% |
| Won | 5 | 41.7% |
In this version the leak sits between the meeting and the proposal. Booking 80 calls would pour more buyers into the same hole, so the fix is discovery, or a tighter list of who gets a call.
Now change one number. If only 25 of the 60 calls had taken place, the first fix would be the show rate. The top and bottom figures stay the same and the fix is the opposite, which is why the sheet dates every stage.
Where Spona fills the funnel, and where it does not
The sheet measures a funnel. It cannot fill one. If the Created row is thin, the fix sits upstream, in the list you prospect from.
That is the part Spona does. You describe your ideal customer in a chat and get a verified, scored lead list. Prices run from $0.008 to $2.00 a lead, depending on the search type and the plan. You can test it with the Free plan's 3,000 one-time credits, and every search starts with a free sample.
The limits are real. Each new search session costs a one-time 1,000 credits before the first lead. On the Free plan that is a third of your credits.
Spona finds the leads, but it does not email or call them for you today. AI Cold Email and a dialer are coming soon, so for now you need your own outreach tool.
Spona is not a CRM either. It does not log stages or outcomes, so it cannot tell you your conversion rates.
If your CRM already reports stage conversion, use that report: it updates itself from live deals, and no sheet does that. The sheet is for teams without one, or for checking the CRM's math on a single cohort.
And Spona only helps the top of the funnel. A weak step between meeting and proposal is a selling problem, and more leads make it more expensive, not better.
Get thousands of leads in 4 minutes.
Stop stitching tools together.
Start with verified sales data, delivered in minutes.
No contracts · No setup · No onboarding
Sales funnel template FAQ
How do I create a sales funnel for free?
Build it in a spreadsheet. List your opportunities one per row, add a date column for each stage and count how many rows reach each one. This sales funnel template does that in Google Sheets at no cost, and you only need a Google account to copy it.
Is there a free sales funnel template for Excel?
Yes. Open this one and choose File > Download > Microsoft Excel. It uses only functions that Excel also has, such as COUNTIFS, INDEX and MATCH, so the formulas keep working. There are no macros and no add-ins.
Is there a funnel chart in Excel?
Yes, in recent versions. Microsoft lists the funnel chart on the Insert tab, in the group with the waterfall and stock charts. On Windows it needs Office 2021 or a Microsoft 365 subscription. Google Sheets has no funnel chart type, so chart the Reached column as a bar chart there.
How does a sales funnel differ from a pipeline?
A funnel counts how many deals reach each stage, and the rate between stages. A pipeline lists the open deals themselves, with their value and next step. In Pipedrive's words, a pipeline "tracks the internal sales process from the rep perspective". Our B2B sales pipeline guide covers that view.
How often should I update the funnel sheet?
Update a row whenever a deal reaches a stage, and read the Summary tab weekly. The stalled-deal count only helps when the dates are fresh. The stage rules need less attention: Salesforce says a funnel template should be "reviewed and updated quarterly".
Share this article
GET FREE LEADS





