Free CRM Template for Excel & Google Sheets
A free CRM template for Excel and Google Sheets with a deals pipeline, follow-up tracking and a sales dashboard. Copy it or download it in one click.

This is a free CRM workbook for Excel and Google Sheets: a deals pipeline with follow-up tracking, a setup tab for your own stages, and a sales dashboard that totals everything for you. Pick your version:
- Copy the template to Google Sheets (it opens as your own copy in Google Drive)
- Download the Excel file (.xlsx) (the same workbook, ready for Excel)

Prefer to watch first? See the 30-second video walkthrough of the template.
What is inside the template
The workbook has three tabs. You type in one of them, and the other two do the work.
Deals tab: one row per deal
This is your pipeline. Each row holds the deal name, the contact and their email, lead source, stage, deal value, probability to win, forecasted value, created date, deal age, expected close date, the person responsible and notes.
- Stage, lead source and assignee are dropdowns, so everyone spells them the same way.
- Every stage carries a probability to win, and the sheet uses it to calculate a forecasted value for each deal. A 25,000 deal at the Lead stage (10%) counts as 2,500 in your forecast.
- Deal age shows how many days a deal has been open, so stuck deals are easy to spot.
- The formulas and dropdowns are already in place for 500 deals. Type in the next empty row and everything calculates.
Follow-up tracking: see what is overdue
Each deal has a next step and a follow-up date. The status column works out the rest: Overdue turns red, Today turns orange, and anything later shows as Upcoming. Closed deals drop out of the list on their own.

Dashboard tab: your numbers without building reports
The dashboard reads the Deals tab, so it follows your data as you add rows. At the top are five headline numbers: open deals, open pipeline value, weighted forecast, closed value and overdue follow-ups. Below them:
- A chart of deal value by stage
- Open deals, average deal size and forecasted value by sales rep
- Open deals by lead source
- Closed deals by sales rep and by lead source, month by month

Setup tab: your stages, your team, your lead sources
The template ships with six stages (Lead, Contacted, Demo, Negotiations, Agreement signing, Closed) and a probability for each, from 10% to 100%. Replace them with your own sales steps, then list your team members and lead sources. The dropdowns on the Deals tab read from these lists.

How to set it up in five minutes
- Get your copy. Use the Google Sheets copy link or download the .xlsx for Excel.
- Open the Setup tab. Replace the sample stages and probabilities, team members and lead sources with your own.
- Open the Deals tab. Overwrite the sample rows with your real deals. Pick stage, lead source and assignee from the dropdowns, then enter the value, the expected close date, the next step and the follow-up date.
- Open the Dashboard tab. Your open pipeline, forecast, closed deals and overdue follow-ups are already totalled.
One thing to know: if you add more team members or lead sources, keep a few empty rows under the first four dashboard tables so they have room to grow.
Using the template in Excel
The Excel file is exported from the same Google Sheet, so the tabs and columns are identical. Excel does not refresh pivot tables on its own. After you add or change deals, go to Data > Refresh All to update the dashboard tables.
What a spreadsheet CRM cannot do
A sheet is a good first CRM, and it is honest to say where it stops:
- It shows overdue follow-ups only when you open it. Nothing arrives in your inbox to remind you.
- Your emails live somewhere else. Every reply means copying details from Gmail into a row by hand.
- Two people editing at once leads to overwritten cells and stages that no longer match.
We wrote down the exact points where this starts to hurt, and what moving costs, in Google Sheets as a CRM: setup, formulas, and when it stops working.
When you outgrow the template
Teamopipe is a CRM that lives inside Gmail. The pipeline sits next to your inbox, a deal is created from an email in one click, and follow-up reminders and sequences run on their own. You can import this sheet as a CSV file and keep the same stages. There is a 14-day free trial with no credit card.
FAQ
Is the CRM template really free?
Yes. Copy it to Google Sheets or download it for Excel, and it is yours to change.
Does the template work in Excel?
Yes. Download the .xlsx file and open it in Excel. Use Data > Refresh All after adding deals so the dashboard pivot tables update.
Can my team use the same sheet?
Yes, in Google Sheets. Share your copy with the team, add everyone on the Setup tab, and each person picks their name in the Assignee column. The dashboard then splits open deals, forecast and closed deals by person.
How many deals can it handle?
The formulas and dropdowns are set up for 500 deals, and you can extend them further by copying a row down. The limit most people hit first is not size but follow-ups: a sheet cannot email you when someone is waiting for a reply.
How do I move from the template to a CRM?
Download the Deals tab as a CSV file and import it. In Teamopipe the CSV import maps your columns to deal fields, so your stages, values and contacts come across in one go.
Start your free 14-day trial
An affordable alternative to Streak and other complex CRMs.





