Sales pipeline template
Every deal by stage, with a chance of winning for each stage and a weighted total of what the pipeline is worth.
Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.


What is in it
Each deal with its company, stage, value and expected close, the chance of winning it from its stage, and the pipeline’s weighted total. The figures are examples to type over; the workbook runs wider than the columns shown here.
| Sales pipeline | |||||||
| Each stage carries a chance of winning, set in the table on the right. Weighted is the value times that chance, so the total is a fair estimate of what the pipeline is worth. | |||||||
| Deal | Company | Contact | Stage | Value | Chance % | Weighted | Expected close |
| Website rebuild | [Company] | [Contact] | Proposal | 8000 | =IF(D5="","",XLOOKUP(D5,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E5="",F5=""),"",E5*F5/100) | 2026-12-15 |
| Annual support | [Company] | [Contact] | Negotiation | 4800 | =IF(D6="","",XLOOKUP(D6,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E6="",F6=""),"",E6*F6/100) | 2026-11-30 |
| Staff training | [Company] | [Contact] | Qualified | 2500 | =IF(D7="","",XLOOKUP(D7,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E7="",F7=""),"",E7*F7/100) | 2027-01-20 |
| Audit | [Company] | [Contact] | Won | 3200 | =IF(D8="","",XLOOKUP(D8,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E8="",F8=""),"",E8*F8/100) | 2026-11-04 |
=IF(D9="","",XLOOKUP(D9,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E9="",F9=""),"",E9*F9/100) | ||||||
=IF(D10="","",XLOOKUP(D10,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E10="",F10=""),"",E10*F10/100) | ||||||
=IF(D11="","",XLOOKUP(D11,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E11="",F11=""),"",E11*F11/100) | ||||||
=IF(D12="","",XLOOKUP(D12,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E12="",F12=""),"",E12*F12/100) | ||||||
=IF(D13="","",XLOOKUP(D13,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E13="",F13=""),"",E13*F13/100) | ||||||
=IF(D14="","",XLOOKUP(D14,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E14="",F14=""),"",E14*F14/100) | ||||||
=IF(D15="","",XLOOKUP(D15,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E15="",F15=""),"",E15*F15/100) | ||||||
=IF(D16="","",XLOOKUP(D16,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E16="",F16=""),"",E16*F16/100) | ||||||
=IF(D17="","",XLOOKUP(D17,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E17="",F17=""),"",E17*F17/100) | ||||||
=IF(D18="","",XLOOKUP(D18,$K$5:$K$10,$L$5:$L$10,"")) | =IF(OR(E18="",F18=""),"",E18*F18/100) | ||||||
Worked out for you
These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.
- Chance %
=IF(D5="","",XLOOKUP(D5,$K$5:$K$10,$L$5:$L$10,""))- Weighted
=IF(OR(E5="",F5=""),"",E5*F5/100)- Total: Value
=SUM(E5:E29)- Total: Weighted
=SUM(G5:G29)- Won: Value
=SUMIF(D5:D29,"Won",E5:E29)
Filling it in
- Write a next step on every open deal, with a date. A deal with no next step is not in the pipeline.
- Set the chance for each stage from your own past deals, not from what feels right.
- Mark lost deals Lost rather than deleting them. They show which stage deals fall out at.
The next step
More templates
- Invoice trackerInvoices, clients, amounts and whether each is paid, with the total invoiced.Open in Sheets
- Content calendarOne row for each post, article or newsletter, with its date, channel, owner and status, and a count of how many are at each stage.Open in Sheets
- Project proposalWhat the work is, what will be delivered and when, and what it costs, on a page or two.Open in Docs