Posted in

5 Free Customer Contact List Templates in Excel

5 Free Customer Contact List Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 10, 2026

A customer contact list template keeps every customer’s name, phone number, email address and notes in one organised place. On this page you can download five free customer contact list templates in Excel: a simple customer contact list, a customer contact and follow-up list with status and next follow-up dates, and a B2B customer directory for business accounts with billing contacts and payment terms, plus a customer account-owner list and a lapsed-customer win-back list.

Each file is a real, editable .xlsx spreadsheet created for this page. Every list has filter buttons on the heading row and frozen headings, so you can sort and search hundreds of customers easily. The follow-up list also suggests the next follow-up date automatically and counts active customers. The templates open in Excel, Google Sheets and LibreOffice Calc.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

Why Keep a Customer Contact List?

Small businesses often keep customer details scattered across phones, email inboxes, invoices and notebooks. When a customer calls, nobody can find their last order, and when a staff member leaves, their contacts leave with them. A single customer contact list solves this. It gives everyone in the business the same up-to-date information, makes it easy to follow up with customers and prospects, and provides a starting point for email newsletters, holiday cards and special offers.

A spreadsheet is a practical first step before investing in customer relationship management (CRM) software. It is free, easy to share and simple to import into a CRM later if the business grows.

Download the Free Customer Contact List Templates

The five Excel files below cover a basic contact list, a sales follow-up list and a directory for business-to-business accounts.

Customer Contact List

The simple contact list has columns for customer, contact person, phone, email, address, city and notes. It suits shops, freelancers, tradespeople and service businesses that want one clean list of who their customers are and how to reach them.

Customer contact list template in Excel with filters

Customer Contact and Follow-Up List

This version adds a source column (such as referral, website or walk-in), a status drop-down with Lead, Prospect, Active and Inactive, the date of the last contact and a next follow-up date. When you enter the last contact date, the next follow-up date is set 30 days later. A counter at the top shows how many customers are marked Active.

Customer contact and follow-up list template in Excel with status drop-down

B2B Customer Directory

For businesses that sell to other businesses, this directory lists each account with an account number, main contact, job title, phone, email, billing contact, payment terms and account manager. It helps sales and accounts teams contact the right person at each company.

B2B customer directory template in Excel with billing contacts and payment terms

Customer Account Owner List

Customer account owner list template in Excel with segment, owner, last contact, next action and annual value

A working list of who owns each customer, not just a directory of phone numbers. Each row has the customer, a segment (key account, core, long-tail or prospect), the account owner, the last contact date, the next action and an annual value; the header totals the value. Sales and account teams use it in the weekly pipeline meeting. Keep next actions short enough that a colleague could pick them up. Update the last-contact date after every meaningful call, not only when a deal closes.

Lapsed Customer Win-Back List

Lapsed customer win-back list template in Excel with last order date, days since, last value, offer and status

For customers who have stopped ordering and are worth a planned approach. Enter the last order date, last value and a short win-back note; days since the last order calculate when you open the file, and a status column tracks To call, Emailed, Meeting booked, Won back or Closed. The header counts how many still need a call. Set your own ‘lapsed after’ period in the header. A specific offer or a useful update works better than a generic ‘we miss you’ email.

What to Include in a Customer Contact List

  • Customer or company name, spelled the same way as on invoices.
  • Contact person and, for businesses, their job title.
  • Phone number, including the country code if you have international customers.
  • Email address.
  • Postal address and city, if you send deliveries, invoices or cards by post.
  • Source: how the customer found you, which shows which marketing works.
  • Status: lead, prospect, active or inactive.
  • Last contact and next follow-up dates.
  • Notes: preferences, past orders or anything that helps the next conversation.

Only record the information you actually need. Collecting less data is easier to keep accurate and reduces privacy risk.

How to Use the Templates

  1. Open the template and type over the example rows.
  2. Enter one customer per row, filling in as many columns as you have information for.
  3. Use the filter buttons on the heading row to sort by name, city or status, or to show only certain customers.
  4. On the follow-up list, choose a status from the drop-down and enter the last contact date.
  5. Each week, filter the next follow-up column to see who needs a call or email.
  6. Add new customers at the bottom and keep the list sorted.

Keeping Customer Data Accurate

A contact list is only useful if it is up to date. Set a simple routine:

  • Update after every contact. When you speak to a customer, update the last contact date and notes straight away.
  • Check details on invoices. When an invoice bounces or a delivery fails, fix the record.
  • Remove duplicates. Sort by name or email once a month to find the same customer entered twice.
  • Mark inactive customers. Don’t delete customers who have not bought for a while; mark them inactive so you can still see their history.
  • Use consistent formats. Write phone numbers, dates and city names the same way every time so sorting and filtering work properly.

Following Up With Customers

Regular follow-up is one of the simplest ways to win repeat business. A short email or call after a sale checks that the customer is happy, and a reminder before a service is due brings them back. Use the follow-up list to plan these contacts. Filter by status to send a different message to leads, active customers and inactive customers, and record each contact so you never call the same person twice in one week by mistake.

The default 30-day follow-up period suits many service businesses. Change the formula in the next follow-up column if your sales cycle is shorter or longer.

Protecting Customer Privacy

Customer contact details are personal data, and many countries have laws about how they are collected, stored and used. Keep the file in a secure, password-protected location rather than on a shared desktop. Share it only with staff who need it. Do not add customers to marketing emails unless they have agreed, and remove a customer’s details if they ask you to. If you use Google Sheets, check the sharing settings so the file is not open to anyone with the link.

Moving From a Spreadsheet to a CRM

When your customer list grows into the thousands, or several people need to update it at the same time, a CRM system may be worth the cost. The good news is that a well-organised spreadsheet makes the move easy. Most CRM tools import a CSV or Excel file directly, so keep one column per field, use clear headings and avoid merged cells in the data area. The templates on this page already follow these rules.

Using the List With Other Records

A customer list works best when it links to your other business records. Use the same customer name on quotes, invoices and sales reports so you can match them up. Add an account number, as in the B2B directory, if you have customers with similar names. When you review sales each month, use the list to see which customers bought, which did not and who might need a follow-up.

Segmenting Your Customer List

Once your list has more than a few dozen customers, grouping them makes it far more useful. Common segments include customers by location, by the product or service they buy, by how often they buy and by how much they spend. Add a column for each segment you care about, such as “Product interest” or “Customer type”, and use the filter buttons to pull out just that group. A bakery might filter wholesale customers to send a new price list, while a cleaning company might filter customers in one area to plan a route.

Keep segment names short and consistent. A drop-down list, like the status column on the follow-up list, stops people typing the same thing in five different ways. To add one, select the column, choose Data > Data Validation and enter your list of options.

Sharing the List With Your Team

If several people use the list, decide who is allowed to add and change records. In Excel, store the file on a shared drive or in OneDrive and use the co-authoring feature so two people do not overwrite each other. In Google Sheets, share the file with named team members rather than with “anyone with the link”, and use version history to undo mistakes. A short note at the top of the sheet explaining how to fill in each column helps new staff keep the data clean from their first day.

Related Templates

You can also check these important templates like the sales report templates for tracking what each customer buys, and the guest invitation list templates for inviting customers to an event.

Frequently Asked Questions

What should a customer contact list include?

At a minimum, the customer name, contact person, phone number and email address. Many businesses also record the address, source, status, last contact date and notes.

Can I sort and filter the customer list?

Yes. Each template has filter buttons on the heading row, so you can sort by any column or show only certain customers.

How does the follow-up date work?

When you enter a last contact date on the follow-up list, the next follow-up date is set 30 days later automatically. You can change the number of days in the formula.

Can I use these templates in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Filters, drop-downs and formulas keep working.

Can I import the list into a CRM later?

Yes. Most CRM tools import Excel or CSV files. Keep one customer per row and one field per column for a clean import.

How do I keep customer data safe?

Store the file in a password-protected location, share it only with staff who need it and follow your local data protection rules.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.