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.
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.
Open templateSalesSales Pipeline Template for Startups
Track startup deals, pilots, investors, annual contract value, close dates, and founder follow-ups in one free sales pipeline spreadsheet.
Open templateSalesSales Pipeline Template for B2B
Track B2B opportunities, stakeholders, stages, close dates, and weighted forecast in one free pipeline spreadsheet for Excel and Google Sheets.
Open templateSalesSales Pipeline Template for Real Estate
Track real estate buyers, sellers, listings, showings, expected commission, close dates, and next actions in one pipeline spreadsheet.
Open templateSalesSales Pipeline Template for Coaches
Track coaching leads, discovery calls, packages, retainers, proposal status, close dates, and follow-ups in one free spreadsheet.
Open templateSalesSales Pipeline Template for Agencies
Track agency leads, proposals, retainers, deal stages, and forecast value in one free sales pipeline spreadsheet built for service businesses.
Open templateSalesSales Pipeline Template for Consultants
Track consulting leads, proposal stages, retainer opportunities, expected close dates, and weighted forecast in one free pipeline spreadsheet.
Open template