Skip to content
Customer Database cover: a sample sheet with customers, lifetime value and ordered in 90 days and a column chart, beside the Dashboard and Customers tabs

Customer Database

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

Sales and support teams use the Customer Database to see who buys and how much they spend. The Customers tab holds one row per customer with an ID, segment (Consumer, Small business or Enterprise), region, join date, order count, lifetime value, last order date and status. Days since order counts up from the last purchase. The Dashboard shows orders and lifetime value by segment, plus how many customers sit in each region.

Give every customer a unique ID and set the status to Lapsed once they pass the inactive period your business uses. Lapsed rows are shaded red, so a win-back mailing list is quick to pull. Update the orders and lifetime value after each sale, or paste monthly totals from your sales system. Filter by segment or region to build a list for one group.

Useful for

  • Find customers who have not ordered recently
  • Compare lifetime value across consumer and business accounts
  • Plan win-back messages for lapsed customers

What's included

  • 3 tabs: Dashboard, Customers, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Customers: 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 Customers 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

How is lifetime value worked out?

Lifetime value is the total you have earned from a customer so far, usually the sum of their orders less refunds. Type it in from your sales records, since this sheet does not link to them. Use the same definition for every customer so the segment totals compare.

How many days should count as lapsed?

That depends on how often your customers buy. Many businesses use 90, 180 or 365 days. Choose a period that fits your buying cycle, then mark customers as Lapsed once they pass it.

Can I track each order separately?

This template keeps one row per customer with running totals. For order-by-order records, add a second tab with one row per order and the customer ID. Keep the totals on this tab in step with that log.

  • #crm
  • #customer-database
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More crm templates

See all 9

Also in Sales

All sales templates
Get this template

Preparing your template…