Skip to content
Business Contact List cover: a sample sheet with contacts, contacted in 90 days and follow-ups in 14 days and a pie chart, beside the Dashboard tab

Business Contact List

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

Small business owners and office staff use the Business Contact List as one address book for the people they work with. Every entry on the Contacts tab covers one individual: company, job title, type (Customer, Supplier, Partner, Press or Advisor), area, email, phone number, the date you last spoke and when to follow up. The Dashboard counts contacts by type and by area and shows how many people you reached in the last 90 days.

Pick a type and an area from the dropdowns for each contact, so filtering and counts stay consistent. After every conversation, update the last contact date and set the next follow-up. Rows turn red once a follow-up date has slipped past. Filter by type to build a mailing list for a single group, and remove anyone who asks you to delete their details.

Useful for

  • Keep supplier and partner details in one list
  • Find everyone you have not contacted in 90 days
  • Build a mailing list for one contact type

What's included

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

Can I import contacts from my phone or email?

Export them as a CSV file from your phone or email app, then open the file in your spreadsheet and paste each column into the matching field. Check names and phone numbers afterward, because separators sometimes shift during a paste.

How do I remove duplicate contacts?

Sort the Contacts tab by email and look for rows that repeat the same address. Delete the older copy and keep the row with the latest contact date. Doing this once a quarter keeps the list tidy.

Should I store personal notes here?

Keep notes to business facts such as role, preferences and what you agreed. Leave out personal details you do not need, and remove a contact when they ask. Check your local privacy rules before storing anything sensitive.

  • #crm
  • #contact-list
  • #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…