Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMAccounts & CustomersCustomer Contact List

SpreadsheetAccounts & CustomersFree

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

Shown with sample data

Colour

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

Customers
9
Lifetime revenue
$187,400
Revenue at risk
$37,100
Spend from customers not contacted recently
Call now
3
Revenue by segment
  • VIP$116,10062%
  • At risk$37,10020%
  • New$26,80014%
  • Regular$7,4004%
Spend by customer
  • Northwind Retail$48,600
  • Cedar Health$36,500
  • Granite Partners$31,000
  • Harbor Health$22,000
  • Delta Foods$15,200
  • Summit Hotels$12,800
  • Fjord Design$9,100
  • Blue Harbor Cafe$7,400

How to use it

  1. 1Add each customer with contact details, owner, first purchase date, number of orders and total spend.
  2. 2Update Last contact after every call, meeting or email.
  3. 3Set the VIP spend level and contact intervals on the Settings sheet.
  4. 4Work the customers marked Call now first.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

More than an address book. Keep each customer's contact, owner, first purchase, orders and total spend; the list works out average order value, days since last contact and an automatic segment (New, VIP, Regular or At risk), and tells you who to call next. A segments sheet shows where revenue comes from and how much is at risk.

Who it’s for

  • Small businesses keeping customers close
  • Account managers planning check-ins
  • Spotting valuable customers drifting away

What’s included

  • Customers sheet: Every customer with value, recency, segment and next step.
  • Segments sheet: Customers and revenue in each segment.
  • Settings sheet: Rules for segments and contact reminders.

How to use it

  1. 1Add each customer with contact details, owner, first purchase date, number of orders and total spend.
  2. 2Update Last contact after every call, meeting or email.
  3. 3Set the VIP spend level and contact intervals on the Settings sheet.
  4. 4Work the customers marked Call now first.

Tips

  • Agree a contact rhythm for each segment and stick to it.
  • An At risk customer is cheaper to save than a new one is to win.
  • Note what each customer bought and why; it makes the next conversation easier.

Questions

How is the segment decided?

New: first purchase in the last 90 days. At risk: no contact for longer than the at-risk limit. VIP: total spend at or above the VIP level. Everyone else is Regular.

Related searchescustomer listcustomer databaseclient listcrm spreadsheetcustomer segmentationaccount management

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts & CustomersFree

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More accounts & customers templates

View all
Customer Health Scorecard2 sheets

Accounts

6

At risk

2

Revenue at risk

$134,000

Annual revenue by segment
$204k
$116k
$32k
EnterpriseMid-marketSmall business
SpreadsheetAccounts & Customers

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

10 min setupPreview
RFM Customer Segmentation3 sheets

Customers

14

Champions’ share of revenue

48%

Revenue from at-risk customers

$4,600

ABCD
1CustomerLast orderOrdersTotal spend
2Amelia TurnerNov 914$2,860
3Noah BennettOct 287$1,240
4Isla FraserNov 121$85.00
5Leo HughesApr 211$2,310
Customers
SpreadsheetAccounts & Customers

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

10 min setupPreview

Customer Feedback Survey

Measure satisfaction and NPS, and learn what to improve.

Overall, how satisfied are you? *

Very satisfiedSatisfiedNeutral

How likely are you to recommend us to a friend or colleague (0–10)? *

012345678910

What did we do best?

Send feedback
FormAccounts & Customers

Customer Feedback Survey

Measure satisfaction and NPS, and learn what to improve.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ