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.
Sources
Do this with AI
Turn the instructions into a finished spreadsheet.
Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or 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
Forecast startup B2B opportunities by prospect, plan or use case, stage, contract amount, confidence, decision date, owner, and next action.
Open templateSalesSales Pipeline Template for B2B
Review B2B opportunities with open, won, and lost totals, manually entered probabilities, expected-close and follow-up dates, and visible input checks in a three-sheet browser workbook.
Open templateSalesSales Pipeline Template for Real Estate
Track real-estate accounts or properties, owners, stages, deal values, probabilities, weighted values, and next actions in a Dashboard, Pipeline, and Setup workbook.
Open templateSalesSales Pipeline Template for Coaches
Forecast coaching packages and workshops by client-safe label, program, stage, package amount, confidence, decision date, owner, and next action.
Open templateSalesSales Pipeline Template for Agencies
Track agency prospects, service fit, sales stages, deal values, probabilities, weighted forecast, close dates, owners, and next actions.
Open templateSalesSales Pipeline Template for Consultants
Track consulting prospects by scope, service, stage, value, probability, weighted forecast, close date, owner, and next step.
Open template