Sales Funnel Template and Examples: Build It in Excel or Google Sheets

A sales funnel template stops being decoration the first time two reps disagree about what “Qualified” means. Settling that argument is the real job of the spreadsheet, and most downloadable funnels never touch it.

This page carries the whole build. You get a four tab workbook you can recreate in Excel or Google Sheets in a single sitting, a field dictionary, stage entry and exit criteria, conversion formulas that fail safely, and worked examples for B2B, SaaS, service, and ecommerce motions.

It is written for founders, sales managers, revenue operations practitioners, and consultants who need a working tracker before or alongside a CRM. Every asset is copyable from the page, so nothing you need sits behind a form.

One warning up front, because it changes how you read the rest. A spreadsheet that stores only the current stage of each deal describes the present moment accurately, and it cannot reconstruct history you never wrote down.

Quick Copy: Sales Funnel Template Build Checklist

Work down this list in order. Each item maps to a section below, and the whole build takes well under an hour once the stage names are settled.

Print it, paste it into a doc, or drop it into the Notes area of your workbook. The checklist works on its own even if you build nothing else here.

Free Sales Funnel Template: The Four Tab Structure

Download the sales funnel template workbook as an .xlsx file with four sheets. No form, no email gate, and it opens in Excel or uploads straight into Google Sheets.

Build it by hand instead if you prefer, or open the file and check every column against the field dictionary further down. Either way the structure below is what you are aiming at.

The workbook splits into four tabs on purpose. Two of them hold data, one holds the rules, and one holds the worked example you check yourself against.

The link between the two data tabs is a single field. The Stage value on a Tracker row is what the Summary tab counts, which is why an unrestricted Stage column quietly destroys every number above it.

Keep the raw Tracker rows clean and boring. Put formatting, notes, and management commentary on the Summary tab so the Tracker stays importable the day you outgrow it.

What the Template Includes

The Tracker carries eighteen fields, seven of which are optional depending on your motion. Nothing in the list exists to look thorough, and every field has a job in either the summary math or the daily work queue.

The Summary tab carries stage labels with their criteria, a current count, and an adjacent-stage count used only where the comparison is honest. It also carries a ratio, a drop-off figure, an optional value total, an optional weighted total, an average age in stage, and a recommended review action.

The Lists tab carries four controlled vocabularies. Editing a value there is the only sanctioned way to change a category, because typing a new one straight into a Tracker row splits your reporting without warning.

The Examples tab carries three filled synthetic rows and a four stage summary. Those numbers exist to show the mechanics and they are not benchmarks for your business.

How to Use This Template

Seven steps, in this order. Skipping straight to data entry is the most common way this build fails.

Name the use case in one sentence first, because the stage names and the required input for every row both follow from it. A consultative B2B motion and a self-serve SaaS motion need the same workbook and different stages.

Step two is where most teams save or lose the next six months. Criteria written after data entry begins tend to get bent to match whatever people already typed.

Work the steps in sequence and customize as you go. If you would rather see the example output before you build anything, the filled tracker and stage summary further down show what a correctly completed workbook looks like.

The common error to avoid at every step is inventing a category on the fly instead of editing the Lists tab. Each rule in this build rests on documented spreadsheet behaviour, so where a step depends on a product capability the official source is linked in the section that explains it.

Sales Funnel vs Sales Pipeline

These two words get used as synonyms, and the workbook design falls apart when you accept that. Salesforce describes a sales funnel as buyer-centric, charting the buying journey from the prospect’s perspective, while a sales pipeline tracks how reps engage those buyers.

That distinction is exactly why the template has two data tabs instead of one. The Summary tab answers “where is demand leaking”, and the Tracker answers “what does the rep do next”.

Mapping the two vocabularies is useful for reporting and dangerous if you treat it as equivalence. Use the table below as a translation aid, then edit it to match your own process.

Salesforce also describes the pipeline as a visual representation of where each prospect sits in the sales process, and it ties stage movement to defined exit criteria rather than to a rep’s judgement. It does not publish those criteria for you, which is precisely the work the next section asks you to do.

How to Customize the Stages

Stage names are not the deliverable. The deliverable is a pair of observable conditions per stage that two different people would apply the same way.

Pipedrive’s guidance is blunt about this, and it is worth copying.

“Each stage in the pipeline view represents a step your deals go through before they’re won or lost.” That framing comes straight from Pipedrive’s pipeline stage documentation.

Stage names should mirror the way your team sells in practice, not the way a template author imagined it. Fewer, clearer stages beat a long ladder nobody maintains.

Start from the preset closest to your motion, then rewrite it. Treat every preset below as a draft, never as a standard.

Source: Salesforce official documentation on sales pipeline stages and exit criteria, checked 2026-08-07.

B2B Consultative Sales

Use the six stage set above almost as written. Consultative deals earn their length in Discovery, so that is the stage where an aging flag pays for itself.

Add a Decision Maker field if more than two people sign off. Without it, the Qualified exit criterion collapses into wishful thinking.

SaaS Sales

Split evaluation away from the demo. A stage set of Lead, Qualified, Demo or Trial, Evaluation, Proposal, then Closed reflects how self-serve trials behave.

Trial activity is the honest entry criterion for Evaluation, not the trial signup itself. A signup with no product usage belongs back in Qualified.

Service Businesses

Shorten it. Inquiry, Qualified, Consultation, Proposal, then Signed or Lost covers most agency, consulting, and trades workflows without inventing bureaucracy.

Scope creep is the failure mode here, so put the agreed deliverable in Notes at the Proposal stage. That single habit turns Closed Lost reasons into something you can act on.

Ecommerce and Aggregate Reporting

Use Awareness, Interest, Consideration, Purchase on the Summary tab only. Anonymous site visits do not belong in a row-per-opportunity tracker, and forcing them there produces a bloated sheet that answers nothing.

Keep the Tracker for identifiable leads such as wholesale enquiries, high-value carts you follow up by hand, or B2B accounts. Send visit-to-cart-to-checkout measurement to an analytics tool built for event data.

Field Dictionary

Eighteen fields, with the rule attached to each one. Required-when-open means the field is mandatory for any row whose Outcome is still Open.

Two fields carry more weight than their size suggests. Lead ID is what makes a later import survive contact with a CRM, and Stage Entered Date is the only reason your sheet can tell you anything about deal age.

Lead Source deserves one caution. A hand-typed source field supports descriptive grouping, and it is not an attribution model, so read source-level ratios as a prompt to investigate rather than as proof of what caused the revenue.

Source: Microsoft official documentation for Excel data validation rules and Google official documentation for Sheets dropdowns, checked 2026-08-07.

Lists and Validation Rules

Free text categories are the quietest way to break a funnel report. “Qualified”, “qualified”, and “Qual” become three separate groups in any exact-match count, and the totals still look plausible.

Both spreadsheet platforms solve this the same way. Google documents that an entry that does not match an item on the list is rejected by default, with an advanced option to show a warning instead.

Excel behaves comparably through Data Validation, which restricts the type of data or the values that users enter into a cell. Choosing the Stop error alert style blocks values outside your defined list, while the Information and Warning styles let the entry through with a prompt.

Put these four vocabularies on the Lists tab and treat that tab as the only place they change.

Validation settings, field by field:

Exception flags belong here too. Google Sheets supports conditional formatting driven by a custom formula, including rules that format an entire row from the value of another cell.

That is the mechanism behind every exception flag in this build, from a blank owner to a past-due next action.

Three rules cover most of the value. Flag an open row with no owner, flag an open row with no next action, and flag an open row whose next action date has passed.

Formulas and Metrics

Six formulas run the whole summary. All of them are copyable, and all of them are written to fail quietly rather than to spray errors across a mostly empty sheet.

Counting is the easy part. Microsoft documents the syntax as COUNTIF(range, criteria), which counts cells meeting a specified condition, and that is all a stage count needs.

The formulas below assume the column order used in the field dictionary above. Adjust the references if your layout differs.

Stage count
=COUNTIF(Tracker!$G:$G, $A2)

Stage-to-next ratio
=IF($D2=0, "", $E2/$D2)

Drop-off count
=$D2-$E2

Drop-off rate
=IF($D2=0, "", 1-($E2/$D2))

Weighted value
=SUMPRODUCT((TrackerStage=$A2)*TrackerValue*TrackerProbability)

Days in current stage
=IF(Tracker!H2="", "", TODAY()-Tracker!H2)

The weighted-value formula uses three named ranges over the Tracker columns: TrackerStage, TrackerValue, and TrackerProbability. Naming them once keeps the formula readable and survives a column insert.

The zero guard matters more than it looks. Microsoft describes IF as returning one value when a condition is true and another when it is false, so wrapping the ratio returns a blank rather than a division error when a stage is empty.

Now the part that separates a useful funnel from a misleading one. Counting how many deals sit in Qualified this morning and how many sit in Proposal, then dividing, does not measure progression.

Those two groups are different populations captured at one moment. Call that a snapshot ratio and use it to spot obvious imbalance, and do not present it as a conversion rate.

A real cohort conversion needs a defined group that entered one stage inside a stated window, followed forward to see how many reached the next stage. The base template cannot produce that, because it stores one Stage Entered Date and overwrites it on every move.

If you need cohort math, add a Stage History tab that logs one row per transition with Lead ID, from-stage, to-stage, and date. That is a real upgrade, and it is also the point where most teams decide a CRM is cheaper than the discipline.

Weighted value carries its own health warning. Deal Value multiplied by Close Probability is planning arithmetic, not a forecast, because the probability is a number your team chose.

Leave Close Probability blank until you have enough closed rows to calibrate it from your own history. Borrowing stage probabilities from an article, including this one, manufactures false precision.

For a stage chart, Excel can build one natively. Microsoft documents that funnel charts show values across multiple stages in a process, built from a column of stage names and a column of values on supported versions.

Sales Funnel Examples

Every figure below is synthetic. The rows exist to show how the fields interact, and none of the numbers describes any real business.

Three filled Tracker rows, one open early, one open late, one closed lost:

Read SF-003 rather than skimming it. The row carries a Lost Reason from the controlled list, which is what turns a dead deal into a countable pattern instead of a sentence in someone’s notes.

An aggregate summary, using the same synthetic data:

Those percentages are snapshot ratios calculated from one moment. Presented as cohort conversion they would be wrong, and presented as an industry benchmark they would be fiction.

The shape is still readable. The largest absolute loss sits between Awareness and Interest, which is the first place to investigate on a real board.

Which Version Fits Your Motion

Spreadsheet or CRM: A Weighted Readiness Score

This is the one score in the article, and it is about your situation rather than any vendor. Rate each criterion from one to five, where five means the spreadsheet still handles it comfortably and one means it is already painful.

The weights below reflect what breaks first in practice: data discipline fails before feature depth does. Multiply each rating by its weight, then add the results.

A worked example, for a five-person team with clean habits and no history requirement:

0.25 x 4 = 1.00
0.15 x 5 = 0.75
0.20 x 4 = 0.80
0.15 x 3 = 0.45
0.15 x 4 = 0.60
0.10 x 4 = 0.40
Weighted total = 4.00

That total lands in the middle band below. This team keeps the spreadsheet and fixes manual activity capture, which is its weakest criterion, before it hires a sixth person.

Decision thresholds, and one hard reject rule:

The reject rule exists because these criteria do not average out. A single failing dimension, usually access control or manual activity capture, causes more damage than three mediocre ones.

Red Flags in a Sales Funnel Spreadsheet

Any of these means pause the reporting and fix the sheet first.

Common Mistakes

Eight failure patterns, each with the fix that prevents it.

The linearity mistake deserves the extra sentence. HubSpot’s guidance puts it plainly: the buyer’s journey no longer follows a straight highway from awareness to consideration to purchase, and in reality people take a lot of detours.

Your template should tolerate that instead of hiding it. A deal that slides from Proposal back to Discovery is information, not a data-entry error, so record the move and the date rather than quietly nudging it forward.

When Not to Use This Spreadsheet

Four situations where this workbook is the wrong instrument. Recognising them early is cheaper than discovering them at month nine.

If you land in one of the bottom three rows, spend one hour making the sheet importable before you shop. Migration-readiness is cheap while the data is small.

Run that checklist even if switching is nowhere on the roadmap. Every item on it also makes the spreadsheet itself more reliable.

What to Do After You Build the Template

Your next move depends on which part of the build hurt. Three honest paths, and none of them is “buy something immediately”.

If validation and category discipline were the hard part, the problem is process rather than tooling. Read up on lead management basics and settle your qualification definition before adding another field.

If the ratios felt untrustworthy, the gap is measurement design. Understanding how lead scoring works helps separate genuine qualification signals from activity noise, which is usually what makes early-stage numbers wobble.

If you want a more finished starting file rather than a build, two spreadsheet-first options exist. A ready-made CRM Excel template suits offline and Microsoft 365 teams, and a shared Google Sheets CRM template suits teams that need several people in the file at once.

If the readiness score pointed at migration, plan the move before you demo anything. Start with what CRM software does at a category level, then work through CRM migration planning so your clean spreadsheet stays clean on the other side.

Shortlisting comes last, and it should be scoped to your motion. Small teams and solo founders get better results from a CRM for small business teams, while a multi-rep outbound motion has different requirements from a CRM for sales teams.

Methodology and Sources

This template is an editorial build, assembled from official product documentation rather than from vendor marketing. Spreadsheet mechanics come from Google and Microsoft support documentation, and the sales-process concepts come from official Salesforce, Pipedrive, and HubSpot guidance.

Three criteria shaped every design decision. A field earns its place only if it changes a daily action, a formula ships only if it degrades safely on sparse data, and a metric appears only when its denominator can be named.

Sources were checked on 2026-08-07, and each factual statement about a spreadsheet capability links to the documentation page that supports it. Stage presets, weights, and thresholds are editorial recommendations, and they are labelled as such wherever they appear.

Sample rows, sample counts, and the worked scoring example are synthetic. They demonstrate mechanics, and no figure in them is presented as an industry benchmark.

FAQ

What is a sales funnel template?

A sales funnel template is a reusable structure for recording where buyers sit in your sales process and what happens next on each opportunity. A working one pairs stage labels with observable entry and exit criteria, controlled category lists, and formulas whose denominators you can name.

What are the stages of a sales funnel?

Buyer-side funnels usually run through awareness, interest, consideration, and purchase. Seller-side pipelines translate those into operational steps such as New, Qualified, Discovery, Proposal, Negotiation, and Closed, and the exact sequence should mirror how your team sells rather than any published standard.

How do I create a sales funnel in Excel?

Build four tabs, put your controlled values on the Lists tab, and apply Data Validation list rules to Stage, Lead Source, Outcome, and Lost Reason. Add stage counts with COUNTIF on the Summary tab, wrap each ratio in an IF that returns blank when the denominator is zero, and add a funnel chart from the stage-and-value columns if you want the visual.

How do I create a sales funnel in Google Sheets?

The build is identical, with dropdowns in place of Data Validation lists. Google Sheets rejects off-list entries by default, and its custom-formula conditional formatting handles the exception flags for missing owners and past-due next actions.

What should a sales funnel template include?

At minimum: a stable row identifier, current stage, stage entered date, owner, next action, next action date, outcome, and a controlled lost reason. Value and probability fields are optional and belong only in motions where a monetary amount is meaningful.

What is the difference between a sales funnel and a sales pipeline?

The funnel is the buyer’s journey viewed in aggregate, and the pipeline is the seller’s working view of individual opportunities. That is why this template keeps them on separate tabs and joins them through a single Stage field.

How do you calculate sales funnel conversion rate?

Divide the count that reached the next stage by the count that entered the current stage, using the same group of records and the same time window. If all you have is a single set of live stage counts, you have a snapshot ratio rather than a conversion rate, and labelling it accurately is more useful than the extra decimal place.

How do you calculate drop-off in a sales funnel?

Subtract the next-stage count from the current-stage count for the absolute number, or subtract the ratio from one for the rate. Both figures inherit whatever comparability problem the underlying counts have, so state the population alongside the number.

Can a spreadsheet replace a CRM for a small sales team?

For a handful of people tracking identifiable opportunities by hand, yes, for a while. It stops working when you need automatic activity capture, durable stage history, granular permissions, or an audit trail, and the readiness score above is designed to tell you which of those arrived first.

When should I move from this template to a CRM?

Move when the sheet can no longer answer a question your team keeps asking, most often time-in-stage history or who changed what. Run the migration-readiness checklist first, because clean spreadsheet data is the cheapest possible starting point for an import.

About the author

Macedona

Macedona is the founder and lead reviewer at SaaS CRM Review, where he has published 175+ in-depth reviews, pricing guides, and comparisons of CRM and SaaS tools. Each review is based on hands-on testing or verified documentation, and every article states clearly which method was used. Pricing and features are checked against official vendor sources, with the verification date noted in the article. Macedona follows a published review methodology and editorial policy. SaaS CRM Review earns affiliate commissions from some links, which never influence ratings or rankings. Read the full affiliate disclosure.

Follow the author: