How to Build a Sales Pipeline Spreadsheet
A sales pipeline spreadsheet should track active deals, stage, value, probability, and next move. Here's a practical structure for building one that stays useful.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
A sales pipeline spreadsheet is not just a list of prospects. It is a working view of active opportunities and what needs to happen to close them.
If the sheet does not help you review deals, forecast revenue, and decide the next move, it is not really a pipeline.
The simplest structure that works
Use one row per live opportunity.
Your main columns should be:
| Column | Why it matters |
|---|---|
| Company | Identifies the account |
| Contact | Keeps the buyer or champion visible |
| Owner | Makes accountability obvious |
| Stage | Shows where the deal sits |
| Value | Gives revenue context |
| Probability | Supports weighted forecast |
| Close date | Shows timing risk |
| Last touch | Helps spot stale deals |
| Next move | Keeps action visible |
That is the core layout behind a useful sales pipeline template.
Keep stages simple and reviewable
Most small teams do not need eight pipeline stages.
A practical set is:
- Qualified
- Discovery
- Proposal
- Negotiation
- Closed won
- Closed lost
The point is not perfect CRM hygiene. The point is making the weekly review easier.
Add weighted forecast logic
The pipeline becomes much more useful when it can estimate likely revenue instead of only listing raw deal value.
Create a weighted value column:
=E2*F2In this example:
E2is deal valueF2is probability as a percentage
If a 20,000 deal has a 40% probability, the weighted value is 8,000.
This does not make the forecast perfect. It does make the pipeline much more honest.
Separate leads from opportunities
Do not use the pipeline as your entire CRM.
A pipeline should track deals that are real enough to discuss in forecast review. Earlier contacts, referrals, and general follow-up belong in a CRM lead tracker.
That separation keeps the pipeline clean and prevents forecast meetings from filling with unqualified names.
✦ TIP
If you cannot assign a realistic close date or estimated value yet, the record probably belongs in the CRM, not the pipeline.
Review the pipeline by risk
The most useful weekly review usually sorts deals by:
- expected close date
- stage
- next move
- days since last touch
That quickly surfaces the opportunities that look healthy on paper but actually have no recent activity behind them.
Use the right pipeline variant for your workflow
If you sell in a more specific workflow, start from a variant instead of the generic base:
- B2B sales pipeline template
- freelance sales pipeline template
- agency sales pipeline template
- consultant sales pipeline template
The sheet structure stays similar, but the examples and operating language fit the job better.
The Griddy way
The repetitive part of pipeline management is updating stages, rewriting next steps, and figuring out which deals are actually at risk.
"Sort this pipeline by close date, calculate weighted forecast, and flag any deal over 14 days with no activity"
Griddy can structure the pipeline, write the formulas, and summarize which deals deserve attention before the next review call.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Build a pipeline around active opportunities
A good pipeline sheet tracks stage, value, probability, close date, and next move so forecast review stays focused on real deals.
Sales Pipeline
Track deals by stage, owner, value, and next move in one lightweight pipeline sheet. Keep close dates, weighted forecast, and rep follow-ups visible without needing a full CRM.
Sales Pipeline Template for B2B
Track B2B opportunities, stakeholders, stages, close dates, and weighted forecast in one free pipeline spreadsheet for Excel and Google Sheets.
Sales Pipeline Template for Freelancers
Track freelance leads, proposals, follow-ups, project value, and expected close dates in one lightweight sales pipeline spreadsheet.
Sales Pipeline Template for Agencies
Track agency leads, proposals, retainers, deal stages, and forecast value in one free sales pipeline spreadsheet built for service businesses.
Sales Pipeline Template for Consultants
Track consulting leads, proposal stages, retainer opportunities, expected close dates, and weighted forecast in one free pipeline spreadsheet.