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
- Enter or paste contacts on Contacts, one person per row.
- Pick Contact type, Service area and Preferred channel from the dropdowns so you can filter later.
- Use the Search tab to find a person by any word.
- 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.
Related templates
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.