Template

Simple CRM Spreadsheet Template

A lightweight CRM for freelancers and small businesses. Track every lead and customer, deal stage, value and next follow-up, without paying for software.

Updated November 19, 2026In SpreadsheetsFree download: Excel, CSV, PDF

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 nameCompanyEmailPhoneLead sourceStageDeal valueProbability (e.g. 0.5)Weighted valueLast contactNext follow-up
Pipeline total

Preview of the template. Highlighted [brackets] show text to replace.

How to use the CRM spreadsheet

  1. Add every lead and customer with their contact details and where the lead came from.
  2. Set the stage for each deal using the list at the top.
  3. Enter deal value and probability. The template calculates the weighted value and pipeline totals.
  4. Record the last contact and next follow-up for every open deal.
  5. 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