Skip to content
The title slide and first slides of the Simple CRM template

Simple CRM

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 6, 2026

Every slide (4)

Overview

The Simple CRM is a light customer list for small sales or service teams. The Contacts tab holds each person and company, their status, owner, last contact and next follow-up date. The Activity tab logs every call, email, meeting or note. Rows turn red when a follow-up is overdue. The Dashboard shows contacts by status, overdue follow-ups and activity by type.

The file comes with sample data for twelve contacts and twelve activity entries, so you can see how it works. Make a copy, replace the sample rows with your own contacts, and the counts, highlighting and charts update on their own.

Useful for

  • Keeping track of who to call back this week
  • Seeing how many leads have turned into customers
  • Keeping a simple record of what was discussed with each contact

What's included

  • 4 tabs: Dashboard, Contacts, Activity, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Contacts: a table
  • Activity: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Contacts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Simple CRM template free?

Yes. The Simple CRM template is free to download, copy and use for your own business.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Microsoft Excel. The dropdowns, highlighting and charts work in Excel as well as in Google Sheets.

Why does a contact turn red?

A contact turns red when its next follow-up date has passed and its status is not Customer or Lost. Update the status or set a new follow-up date to clear the highlight.

  • #crm
  • #simple-crm
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More crm templates

See all 3

Also in Sales

All sales templates
Get this template

Preparing your template…