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
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Company | Contact | Stage | Deal value | Probability | Weighted | Next step |
| 2 | Northwind Traders | A. Patel | Proposal | 12,000 | 0.5 | 6,000 | Send revised quote |
| 3 | Bluebird Cafe | M. Chen | Qualified | 4,500 | 0.25 | 1,125 | Discovery call |
| 4 | Atlas Logistics | J. Gomez | Negotiation | 30,000 | 0.75 | 22,500 | Legal review |
| 5 | Pine & Co | R. Okafor | Won | 8,000 | 1 | 8,000 | Kickoff |
| 6 | Harbor Health | S. Lind | Lead | 15,000 | 0.1 | 1,500 | Intro email |
| 7 | Pipeline | 69,500 | 39,125 |
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.Download the CSV and import it into Google Sheets.
- 2.Format the Probability column as a percentage (Format → Number → Percent).
- 3.Add a Stage dropdown: Lead, Qualified, Proposal, Negotiation, Won, Lost.
- 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
Invoice Template
A clean Google Sheets invoice with line items, subtotal, tax and total due calculated for you.
Get the templateProject Management Template
A lightweight task tracker for Google Sheets with owners, priorities, due dates and overall progress.
Get the templateInventory Template
Track stock levels, stock value and what needs reordering in one Google Sheet.
Get the template