Free Google Sheets CRM Template

Track every deal with its stage, value and win probability. The weighted value column turns your pipeline into a realistic revenue forecast.

What it looks like

ABCDEFG
1CompanyContactStageDeal valueProbabilityWeightedNext step
2Northwind TradersA. PatelProposal12,0000.56,000Send revised quote
3Bluebird CafeM. ChenQualified4,5000.251,125Discovery call
4Atlas LogisticsJ. GomezNegotiation30,0000.7522,500Legal review
5Pine & CoR. OkaforWon8,00018,000Kickoff
6Harbor HealthS. LindLead15,0000.11,500Intro email
7Pipeline69,50039,125
Tab: Pipeline. Teal cells are live formulas; hover one to see it.

What's included

  • Deal stage, value and win probability per company
  • Weighted forecast (value × probability)
  • Next step column so no deal goes quiet

How to set up the crm template

  1. 1.Download the CSV and import it into Google Sheets.
  2. 2.Format the Probability column as a percentage (Format → Number → Percent).
  3. 3.Add a Stage dropdown: Lead, Qualified, Proposal, Negotiation, Won, Lost.
  4. 4.Insert a pivot table on Stage and Deal value to see the pipeline by stage.

Questions

When should I move from a spreadsheet to a real CRM?
When several people work the same deals daily or you need email logging and reminders. For a solo seller or small team, a sheet like this is often enough.

More templates