Download this template free
No sign-up needed. Word and Excel files also open in Google Docs, Google Sheets and Apple Pages/Numbers. Letter size (8.5 × 11 in).
Simple CRM
Stages: New lead · Contacted · Meeting · Proposal sent · Negotiation · Won · Lost
| Contact name | Company | Phone | Lead source | Stage | Deal value | Probability (e.g. 0.5) | Weighted value | Last contact | Next follow-up | |
|---|---|---|---|---|---|---|---|---|---|---|
| Pipeline total |
Preview of the template. Highlighted [brackets] show text to replace.
How to use the CRM spreadsheet
- Add every lead and customer with their contact details and where the lead came from.
- Set the stage for each deal using the list at the top.
- Enter deal value and probability. The template calculates the weighted value and pipeline totals.
- Record the last contact and next follow-up for every open deal.
- Review weekly. Sort by “Next follow-up” and work through the list.
Suggested probabilities by stage
| Stage | Probability |
|---|---|
| New lead | 10% |
| Contacted | 20% |
| Meeting | 40% |
| Proposal sent | 60% |
| Negotiation | 80% |
| Won | 100% |
| Lost | 0% |
Tips
- Never leave an open deal without a next follow-up date.
- Use a drop-down for stages (Data › Data validation) to keep entries consistent.
- Track lead sources to learn which marketing actually brings in customers.
- Keep notes in an extra column or a linked document for each client.
Need wording for your outreach? See our cold outreach and follow-up email examples.
Frequently asked questions
Can a spreadsheet really work as a CRM?
For freelancers and small teams with up to a few hundred contacts, yes. A spreadsheet CRM is free, flexible and easy to understand. Consider dedicated CRM software when you need automation, email tracking or many users.
What is weighted pipeline value?
The deal value multiplied by the probability of winning it. It gives a more realistic forecast than adding up every open deal. A $10,000 deal with a 50% chance contributes $5,000.
How do I see which follow-ups are due?
Sort or filter the "Next follow-up" column. In Excel or Google Sheets, conditional formatting can highlight dates that are today or earlier.
Related templates and guides
Best Free Google Sheets Templates
Our most useful spreadsheet templates for Google Sheets, from budgets and invoices to project trackers, all free and with the formulas already set up.
ExamplesCold Outreach Email Examples
Short, personal cold emails for reaching new clients, partners and collaborators, without sounding like spam.
ExamplesFollow-Up Email Examples
Polite, effective follow-up emails for the situations that come up every week in business, from after a meeting to when someone has gone quiet.
TemplateKPI Dashboard Template
Track your most important business numbers each month against their targets. The Excel version calculates the variance and percentage of target for every KPI.