Back to blog
CRM Best PracticesPublished

Free CRM Template for Excel and Google Sheets (2026)

GEGain.io Editorial Team

Three people sell. One spreadsheet holds every lead. Someone sorts by "Company" while someone else is typing, the follow-up dates live in a column nobody filters, and the customer who emailed support about a billing error last week is the same one sales is about to pitch an upgrade to. Nobody on the sales side knows.

A CRM template is a spreadsheet that tracks contacts, deals, follow-ups and activities the way CRM software does, for $0. This free template adds a Support Requests tab and a live Dashboard, and works in Excel and Google Sheets with no email form. It comes from Gain.io (gain.io), the CRM and help desk on one customer record, which costs $9.50 per user per month, billed monthly.

A spreadsheet is a perfectly good first CRM. It just needs the right columns, a few formulas that do the remembering for you, and one ID that ties every tab to the same customer. This template has all three, and it's free with no email form in the way.

Key Takeaways

  • A CRM template is a spreadsheet laid out to track contacts, deals and follow-ups the way CRM software does, without a subscription.
  • This free template has 7 tabs: Start Here, Dashboard, Contacts, Deals, Activities, Support Requests and Lists.
  • Every tab links back to one Contact ID, so name, company and owner fill in on their own.
  • Pick a deal stage and the sheet adds the win probability and the weighted value. The Dashboard sums them into a forecast.
  • The Support Requests tab shows the open deal value on the account, so a ticket from a customer with $18,000 in play stands out.
  • It works in Excel 2016 and later, Excel for the web and Google Sheets, with formulas covering 500 rows per tab.
  • Most teams outgrow a spreadsheet CRM once more than three people edit it daily or follow-ups start slipping.

This guide covers what's in the template, how to set it up in Excel or Google Sheets, how the formulas work, a 15-minute weekly pipeline review you can run from it, and the signs that it's time to move to CRM software.

Download The Free CRM Template

The seven tabs in the free Gain.io CRM template: Start Here, Dashboard, Contacts, Deals, Activities, Support Requests and Lists

Download the free CRM template for Excel (.xlsx) or make your own copy in Google Sheets. No email or sign-up needed. The .xlsx also opens in Excel for the web and LibreOffice.

The workbook ships with 10 fictional contacts, 10 deals, 10 activities and 6 support requests, so the Dashboard shows real numbers the moment you open it. Clear the sample rows when you're ready to add your own.

Tab

What it tracks

What fills in on its own

Start Here

How the workbook fits together

Nothing; read once

Dashboard

Pipeline by stage, forecast, win rate, overdue follow-ups, open tickets

Everything

Contacts

People, company, source, owner, status, last contact, next follow-up

Full name, days since contact, follow-up due

Deals

Opportunities, stage, value, expected close

Company, owner, win probability, weighted value, days open

Activities

Calls, emails, meetings, demos and notes

Contact name, owner, overdue flag

Support Requests

Customer problems by channel, priority and status

Company, days to resolve, open deal value on the account

Lists

Owners, stages, probabilities, sources, channels

Feeds every dropdown

What Is A CRM Template

A CRM template is a ready-made spreadsheet that tracks customer relationship management (CRM) data: who your contacts are, which deals are open, what happened on the last call and when to follow up. It gives a small team the structure of CRM software for $0, at the cost of doing the updating by hand.

The useful ones share three traits. They separate people from deals, because one contact can have several deals over time. They use dropdowns, so "Proposal", "proposal sent" and "prop." don't end up as three different stages. And they calculate something, such as a forecast or an overdue flag, so the sheet tells you what to do next instead of only storing what you typed.

A template is not a database. Excel and Google Sheets don't stop two people overwriting the same cell, don't send reminders and don't log emails on their own. That's fine for a team of one to three. It stops being fine later, and the last section of this guide covers when.

What Each Tab In The CRM Template Tracks

One Contact ID links the Contacts, Deals, Activities and Support Requests tabs in the CRM template

Each tab has one job, and the Contact ID (C-001, C-002 and so on) connects them. You type the ID once on a deal, an activity or a ticket, and the sheet looks up the rest.

Contacts Tab

One row per person: name, company, email, phone, role, lead source, owner and status (Lead, Prospect, Customer or Churned). Two dates do the real work. "Last Contact" feeds a Days Since Contact counter, and "Next Follow-Up" feeds a Follow-Up Due column that reads Overdue (red), This week (amber) or Later.

Deals Tab

One row per opportunity. Pick a stage from Lead, Qualified, Proposal, Negotiation, Won or Lost, and the sheet pulls the win probability from the Lists tab (10%, 25%, 50%, 75%, 100% and 0% by default) and multiplies it by the deal value. A $9,800 deal at Proposal shows a weighted value of $4,900. Days Open counts from the created date until you add a close date.

Activities Tab

Log every touch: date, Contact ID, Deal ID, type (Call, Email, Meeting, Demo or Note), a one-line summary, the next action and its due date. Past-due actions are flagged Overdue.

Support Requests Tab

This is the tab most CRM templates leave out. Log each customer problem with the channel it came in on (email, live chat, phone, WhatsApp or web form), priority, status and who has it. The last column sums the open deals on that contact. In the sample data, Acme Corp's "Invoice shows the wrong seat count" ticket sits next to $18,000 of renewal in Negotiation, and the row turns amber so nobody treats it as routine.

How This Template Compares To Other Free CRM Templates

Most free CRM templates are built by CRM vendors as a step toward their software, which is fair. We checked what the most-visited ones include on their own pages on 9 November 2026.

Template

Tabs or sheets

Support requests

Formulas and dashboard

Gain.io (this one)

Start Here, Dashboard, Contacts, Deals, Activities, Support Requests, Lists

Yes, linked to open deal value

Forecast, win rate, follow-ups, ticket counts

HubSpot (a CRM platform)

Start Here, Dropdowns, Organizations, Contacts, Opportunities, Interactions, Dashboard

No

Dashboard with pipeline and contact counts

Salesflare (a sales CRM)

Sales Funnel plus a Settings & Instructions sheet

No

Pipeline analysis and follow-up reminders after a set number of days

OnePageCRM (a follow-up CRM)

One tab

No

A follow-up date on every contact

If you only sell and never handle post-sale support, HubSpot's template covers the same ground with an extra Organizations tab. If your team also answers customer questions, the Support Requests tab is the reason to use this one.

How To Set Up The CRM Template In Excel

Six steps to set up the free CRM template in Excel, from editing the Lists tab to the first weekly review

Setup takes about 30 minutes for a team with 50 to 100 existing contacts. Follow these six steps in order.

  1. Edit the Lists tab. Replace the sample owners (Maya, Leo, Priya, Sam) with your team. Rename stages to match how you actually sell, and set a win probability for each based on your own history if you have it.
  2. Clear the samples. Delete rows 2 to 11 on Contacts, Deals and Activities, and rows 2 to 7 on Support Requests. Delete the values only; keep the grey formula columns.
  3. Add contacts first. Paste existing contacts into the white columns and give each one an ID (C-001 onward). Fill in Last Contact and Next Follow-Up for anyone active.
  4. Add open deals. One row per deal, with the Contact ID, stage, value and expected close date.
  5. Log this week's activities and tickets against the same IDs.
  6. Open the Dashboard. Check that the open pipeline total matches what you expected. If it doesn't, the usual cause is a stage typed by hand instead of picked from the dropdown.

Grey cells hold formulas. Typing over one breaks that row's calculation, so if a number looks wrong, check whether someone pasted over a grey cell.

How To Use The CRM Template In Google Sheets

The fastest route is the Google Sheets version: click it, sign in to Google and choose Make a copy. The copy lands in your own Drive and nobody else can see your data. If you already downloaded the .xlsx, upload it to Google Drive, open it with Google Sheets, then use File, then Save as Google Sheets.

Dropdowns, conditional formatting and every formula carry over, because the template only uses functions both apps support: INDEX, MATCH, SUMIFS, COUNTIFS, AVERAGEIF and TODAY. There's no XLOOKUP and no Excel table syntax, which Google Sheets would break on import.

Google Sheets is the better home if more than one person updates the CRM, because everyone works in the same file and the version history shows who changed which cell.

How The CRM Template Formulas Work

Five calculated columns do most of the work. Knowing what they do makes it easier to change them.

Column

Tab

What it calculates

Example from the sample data

Win Probability

Deals

Looks up the stage on the Lists tab

Negotiation = 75%

Weighted Value

Deals

Deal value × win probability

$18,000 × 75% = $13,500

Days Open

Deals

Today (or the close date) minus the created date

Created 1 Oct, still open

Follow-Up Due

Contacts

Compares Next Follow-Up with today

Due 6 Nov, so Overdue on 9 Nov

Open Deal Value On Account

Support Requests

Sums deals for that contact that aren't Won or Lost

Acme Corp = $18,000

The Dashboard adds them up. With the sample data, the weighted forecast is $31,545 across 7 open deals, the win rate is 67% (2 won, 1 lost), 3 follow-ups are overdue, and 4 open tickets sit on accounts with an open deal.

The CRM template Dashboard tab showing pipeline by stage, weighted forecast, win rate and open support requests from the sample data

How To Run A Weekly Pipeline Review From The Sheet

A 15-minute weekly pipeline review using the CRM template: overdue follow-ups, stuck deals, accounts with open tickets and the forecast

A CRM only helps if someone reads it. Block 15 minutes every Monday and work through four checks.

  1. Overdue follow-ups (3 minutes). Filter Contacts by Follow-Up Due = Overdue. Each owner either contacts the person today or moves the date with a reason in Notes.
  2. Stuck deals (5 minutes). Sort Deals by Days Open. Anything open longer than your normal sales cycle needs a next step or a Lost status. A pipeline full of zombie deals inflates the forecast.
  3. Accounts with an open ticket and an open deal (4 minutes). Filter Support Requests for amber rows. Sales should know before the next call; support should know the account is mid-deal.
  4. Forecast (3 minutes). Read the weighted forecast on the Dashboard and compare it with last week. A drop usually means deals moved to Lost, which is useful information, not a failure.

Excel CRM Template Vs CRM Software

A spreadsheet wins on cost and flexibility. CRM software wins on everything that happens without you: logging emails, sending reminders, stopping two people editing the same record and keeping support conversations on the contact.

Need

Spreadsheet CRM template

CRM software

Cost

$0

Per user per month (Gain.io: $9.50, billed monthly)

Setup

About 30 minutes

Hours to days, depending on imports

Email logging

Manual copy and paste

Automatic from Gmail or Microsoft 365

Follow-up reminders

An Overdue flag you have to look at

Tasks and notifications

Several people editing

Possible in Google Sheets, but no record locking

Built in, with permissions

Support tickets

Logged by hand on a separate tab

Tickets arrive from email, chat and social on the same contact (in a CRM with a help desk)

Reporting

The formulas you build

Pipeline, activity and support reports

When To Move From A Spreadsheet To A CRM

Five signs a team has outgrown its spreadsheet CRM, from edit conflicts to tickets that never reach the sheet

Stay on the spreadsheet while one to three people use it, you have fewer than a few hundred active contacts, and the weekly review takes 15 minutes. Moving earlier mostly buys you a monthly bill.

Move when you see two or more of these:

  • Two people overwrite each other's changes more than once a month.
  • Follow-ups slip because nobody opened the sheet that day.
  • Reps paste emails into the Activities tab, or stop logging them at all.
  • Support requests arrive by email and chat and never reach the Support Requests tab.
  • The weekly review takes longer than the meetings it's meant to prepare for.

When you move, the template's structure carries over. Contacts become contact records, Deals become a pipeline with the same stages, and Support Requests become tickets. In Gain.io (gain.io), the CRM and help desk on one customer record, deals and support tickets link to the same contact, so you can open one contact and see their open deals and tickets together instead of cross-checking two tabs. You still run the weekly review; the information is just in one place. It costs $9.50 per user per month, billed monthly, with a 14-day free trial and no credit card. For a team of 3, that's $28.50 a month. If you're weighing tools at that point, our guide to simple CRMs for small businesses compares 5 options with checked prices, and the CRM ticketing system guide explains when sales and support should share one record.

Key Terms In CRM Templates

Term

Definition

CRM (customer relationship management)

Software or a system for tracking contacts, deals and every interaction with them.

Contact ID

A unique code for each person (C-001) that links their deals, activities and tickets across tabs.

Deal stage

Where an opportunity sits in your sales process, such as Qualified or Proposal.

Win probability

The share of deals at a stage that usually close as Won.

Weighted value

Deal value multiplied by its win probability.

Weighted forecast

The sum of weighted values for all open deals.

Win rate

Won deals divided by all closed deals (Won plus Lost).

Support request

A customer question or problem logged as a ticket, with a channel, priority and status.

Final Discussion

A spreadsheet CRM works when it's built around one customer ID, calculates the things you'd otherwise forget, and gets read every week. This template does the first two. The third is a 15-minute Monday habit.

The tab most teams skip is the one that pays off first. When a support request sits next to an $18,000 renewal, the person answering it should know, and so should the rep who owns the deal. A spreadsheet can show that if you keep both on the same Contact ID.

When the sheet starts costing more time than it saves, Gain.io keeps the same contacts, deals and tickets on one record for $9.50 per user per month. Until then, download the template and run your first review this Monday.

Frequently asked questions

Yes. The template is a free .xlsx download with no email form, sign-up or trial attached. You can edit it, share it with your team and use it for as long as you like. The sample contacts and companies in it are fictional, so delete them before adding real customer data.

Yes. Open the Google Sheets version and choose Make a copy, or upload the .xlsx file to Google Drive and open it with Google Sheets. Dropdowns, conditional formatting and formulas carry over because the template uses only INDEX, MATCH, SUMIFS, COUNTIFS, AVERAGEIF and TODAY, which both apps support.

Yes, for a team of one to three people with a few hundred active contacts. Excel can store contacts and deals, calculate a forecast and flag overdue follow-ups. It can't log emails, send reminders or stop two people editing the same row, which is usually what pushes teams to CRM software.

At minimum: a contacts list with an owner and a next follow-up date, a deals list with stage, value and expected close date, and an activity log. Add dropdowns so stages stay consistent, and a unique ID per contact so every tab links to the same person. If your team handles support, log tickets on the same ID.

This template's formulas cover 500 rows per tab, and you can extend them by copying the last grey row down. Excel itself handles over a million rows. The practical limit is people, not rows: once several people update the sheet every day, edit conflicts and missed follow-ups appear well before the file gets slow.

Switch when two or more of these happen: people overwrite each other's edits, follow-ups slip, emails stop getting logged, support requests never reach the sheet, or the weekly review runs long. Gain.io costs $9.50 per user per month, billed monthly, with a 14-day free trial and no credit card.

Explore related insights and articles

All articles
Get started

Stop being the person who apologizes for not knowing

Sales and support on one customer record. One login, one bill, nothing lost at the handoff.

Start free trial

14 days free · No credit card