Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Sales pipeline open in Sheets, in the light themeSales pipeline open in Sheets, in the dark theme

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.
DealCompanyContactStageValueChance %WeightedExpected close
Website rebuild[Company][Contact]Proposal8000=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]Negotiation4800=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]Qualified2500=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]Won3200=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

All 32 templates