Skip to the content.

Free Google Sheets Contact List

For anyone whose customers and vendors are spread across a phone, an old inbox and a stack of business cards, and who wants one clean address book to search and export.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Dashboard Totals and views built from Contacts and Search, no typing needed.
Contacts Columns Contact ID, First name, Last name, Company, Contact type, Mobile phone, Other phone, Email, Street and 11 more.
Search Columns CT001, Morgan, Ellis, Residential customer, (202) 555-0101, morgan@example.com, 101 Example Lane, Orlando, FL and 9 more.
Export for Google Contacts Totals and views built from Contacts and Search, no typing needed.
Settings Your own dropdown lists (contact types, service areas, channels and yes or no), so the choices match how you work.

How to fill it in

  1. Enter or paste contacts on Contacts, one person per row.
  2. Pick Contact type, Service area and Preferred channel from the dropdowns so you can filter later.
  3. Use the Search tab to find a person by any word.
  4. Copy the Export for Google Contacts tab when you want the list on your phone.

A tip from the field

Watch the duplicate columns. They match on phone, on email and on name plus ZIP, so a customer entered twice stands out.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle keeps each customer’s details, jobs, invoices and messages on one page the whole office shares. See how it works on smarfle.com.

All free templates