Contact List Excel Example and Setup Guide

How-to basics · Updated November 19, 2026

A useful contact list Excel example has one person per row and clear columns for name, phone, email, organization, and follow-up details. Start with the sample below, paste it into Excel, then turn the range into a table so you can sort, filter, and expand it as your list grows.

Copyable contact list example

This small example uses fictional details. The email addresses use the reserved example.test domain, and the phone numbers are illustrative; replace them with information you are authorized to store. Each column has one purpose, and the first row contains field names rather than a contact.

First Name Last Name Organization Job Title Email Phone City Category Last Contacted Notes
Maya Chen Northwind Studio Designer maya.chen@example.test 202-555-0142 Seattle Client 2026-10-12 Prefers email
Jordan Patel Harbor Books Buyer jordan.patel@example.test 202-555-0176 Portland Supplier 2026-09-28 Discuss spring catalog
Riley Garcia Independent Volunteer riley.garcia@example.test 202-555-0128 Seattle Community Available on weekends

For a quick start, copy the header row and records into a blank worksheet, or type the headers across row 1 and add one contact per following row. If pasting the HTML table does not separate values into columns, paste the data as tab-delimited text or use Excel’s import options. Avoid putting several people in one cell: separate rows are much easier to filter, update, and export.

Choose fields that fit the purpose

There is no single mandatory contact-list layout. A family address book, a volunteer roster, and a small business customer list need different details. Begin with the information you will actually use, and add fields only when they support a real task. A wide sheet with dozens of rarely completed columns is harder to maintain and may collect more personal information than necessary.

  • Identity: First Name and Last Name are useful separate fields. A Full Name column is simpler for a short personal list, but separate names are easier to sort by surname and personalize in other tools.
  • Ways to reach someone: Email, Phone, and perhaps Preferred Contact Method cover common needs. Keep a phone number in one field rather than splitting it into area code and number unless a process specifically requires that structure.
  • Relationship: Organization, Job Title, Category, or Relationship can help distinguish clients, colleagues, relatives, and community contacts.
  • Location and follow-up: City, Last Contacted, and Next Follow-up Date are helpful only if location or outreach tracking matters to the list.
  • Notes: Use brief, relevant reminders, not a running record of sensitive personal details. Decide who can see this column before sharing the workbook.

Use a consistent naming scheme. For instance, choose either Organization or Company and use it for every record rather than maintaining both with overlapping meanings. If a field does not apply to a person, leave the cell blank instead of entering a different placeholder each time.

Set up the worksheet as an Excel table

In Microsoft Excel for Microsoft 365 on Windows, put the column headings in the first row, select the range, and choose Insert > Table. Confirm that My table has headers is selected, then choose OK. If the data is already entered in a continuous block, clicking one cell in it before choosing Insert > Table will usually let Excel detect the range. Check the selection before confirming so blank rows or unrelated data are not included.

An Excel table gives the list a recognizable header row and filter controls, and it normally extends its formatting and structure when you add records directly below it. You can choose a style from the Table Design tab, which appears when the table is selected. Give the table a meaningful name in the Table Design tab’s Table Name box, such as Contacts, if you expect to refer to it elsewhere in the workbook. In current Excel for Mac, the Insert > Table route is also available; ribbon placement and appearance can differ slightly from Windows.

Keep one header row and do not merge cells in the data area. Avoid blank rows between contacts, decorative title rows inside the table, and multiple sections with repeated headers on the same worksheet. A title can sit above the table, but it should not be mistaken for a record or included as a table heading. For a long list, use View > Freeze Panes > Freeze Top Row to keep the worksheet’s first row visible while scrolling.

Format dates, phone numbers, and email addresses

Phone numbers are identifiers, not quantities to calculate. A number format may remove leading zeroes or treat a leading plus sign unexpectedly, so set the Phone column to Text before entering international numbers or values with leading zeroes. Select the column, then choose Text from the number-format list on the Home tab. If Excel has already changed a value, changing its format afterward may not restore the original characters; check the displayed value and re-enter it when needed.

Store dates as actual Excel dates rather than text such as next Friday. A real date can be sorted chronologically and displayed consistently. Select the Last Contacted column and choose a date format from the Home tab’s Number group. A format such as 2026-10-12 is easy to read across regions, but the underlying cell should still be a date value. Do not use a date field for a broad note like contacted in October; put that in Notes if the exact date is unknown.

Email addresses generally work best as plain text. Excel may automatically create clickable links, which is convenient, but the address should remain readable and editable. Test a few records for accidental spaces at the start or end of an address, missing characters, or an incorrect domain. A spreadsheet can store contact details, but it cannot establish that an address or number is current.

Sort and filter without losing records

Use the filter arrows in the table headers to show, for example, only contacts in Seattle or only records marked Client. You can sort names alphabetically, or filter a Last Contacted date range to find older records. Clear the filter when you want to see the full list again. A filtered-out row is still in the worksheet; filtering hides rows from view rather than deleting them.

Sort from a table header or use the options on the Data tab, and make sure the whole table is being sorted. Sorting only the Last Name cells while leaving the other columns in place would pair people with the wrong email and phone details. Excel normally recognizes a table as a connected range, which reduces this risk, but inspect the selection if Excel asks whether to expand it. For multi-level ordering, such as first by Category and then by Last Name, use Data > Sort and add the sort levels in the intended order.

Filters can support small outreach tasks, but a contact sheet is not automatically a reminder system. A Next Follow-up Date column can help you identify due records by sorting or filtering dates. Excel will not contact someone or notify you just because a date has arrived unless you build a separate supported workflow.

Keep data consistent and avoid duplicates

People may appear more than once under a nickname, an old email address, or slightly different spelling. Before removing a duplicate, compare more than one field; two people can share a name, and one person can have several legitimate addresses. Excel’s Data > Remove Duplicates feature can remove matching rows based on selected columns, but it changes the data. Make a copy of the worksheet or workbook first, and choose the comparison columns deliberately. Selecting only Email is appropriate only if email is reliably unique in your particular list.

Consistent categories make filtering useful. If you type Client, Customer, and client for the same group, Excel treats them as separate text values in many filtering and counting tasks. A simple control is to keep a short approved category list on another worksheet, then use Data > Data Validation to create a list dropdown for the Category cells. Review the validation source if the category options change. Validation helps prevent spelling variations, but it does not verify that a category is factually correct.

Review records periodically. Confirm that email addresses still work, update changed organizations, and decide whether outdated contacts should be corrected, archived, or removed. A Last Updated field can help a team understand when a record was checked, while Last Contacted should mean the date of an actual interaction. Defining these labels prevents people from using the same column for different purposes.

Privacy, access, and sharing

A contact workbook can contain personal information even when it looks like an ordinary spreadsheet. Keep only details needed for the list’s stated purpose, limit access to people who need it, and avoid placing passwords, payment details, government identifiers, or private personal commentary in Notes. A password on a file or worksheet is not a substitute for careful access controls, and worksheet protection is mainly intended to prevent accidental edits rather than to make sensitive data safe from determined access.

When storing the workbook in OneDrive or SharePoint, check the sharing settings and grant access only to intended recipients. A link that allows anyone with the link to view or edit is broader than a link restricted to named people. If sending a copy by email, remember that the recipient may retain or forward it. For a shared team list, agree on who can edit records, how corrections are handled, and how old copies are retired. Follow your organization’s data-handling rules and applicable requirements; this is practical spreadsheet guidance, not legal advice.

Before sharing externally, inspect hidden worksheets, comments, and extra columns that may contain information not meant for the recipient. Make a separate, reduced copy if someone needs only a subset of fields. Excel’s document inspection tools and sharing controls can help, but a careful manual review is still worthwhile.

When Excel is a good fit—and when it is not

Excel works well for a modest list that one person or a small group updates, especially when sorting, filtering, and making a printable roster are the main tasks. It is also convenient when contact details need to sit beside other worksheet data. A workbook can be customized without setting up a dedicated contact system.

A spreadsheet becomes less suitable when many people edit the same records, duplicate management is difficult, access must differ by person, or the organization needs an audit trail and automated communication. A contacts app is often better for an individual address book with phone synchronization. A customer relationship management system may suit a business that needs interaction histories, ownership, permissions, and follow-up workflows. Compare products based on the actual requirements, export options, security controls, and cost; importing contacts into another service can create its own duplicate and privacy issues.

To move a list, check which formats the destination accepts. CSV is a common exchange format, but it usually represents one worksheet as plain text and does not preserve Excel table styling, multiple sheets, or all workbook features. Keep a separate Excel workbook as the maintained source if you need formatting or additional worksheets, and inspect a CSV after export because date and phone-number interpretation can vary between applications.

Frequently Asked Questions

How do I make a contact list in Excel?
Put one contact on each row, use a single header row for fields such as Name, Email, and Phone, and enter consistent values. Select the range and choose Insert > Table, making sure My table has headers is checked. Then use the table filters to find and sort records.

What columns should a contact list include?
For a basic list, use name, at least one way to reach the person, and an optional organization or category. Add address, follow-up date, or notes only when they support a real need. Separate first and last names if sorting by surname matters.

How can I sort contacts by last name?
Use the filter arrow in the Last Name table header and choose an alphabetical sort, or select a cell in the table and use the sort options on the Data tab. Sort the complete table, not one isolated column, so each person’s details stay together.

Can I use Excel as an address book?
Yes. Excel can store and filter contact details, but it does not automatically synchronize them with a phone or manage messages like a dedicated contacts app. For a list shared by a team, check access permissions and establish who is responsible for keeping records current.

How do I stop Excel from changing phone numbers?
Format the Phone column as Text before entering numbers, especially when values begin with zero or a plus sign. If Excel already altered a number, changing the cell format may not recover the original value, so verify it and enter the correct text again.

Can I save an Excel contact list as a CSV file?
Yes. Use File > Save As and choose CSV (Comma delimited) when that format is appropriate. CSV generally saves only the active worksheet’s displayed data, not the workbook’s styling or multiple sheets, so keep the original workbook and reopen the export to check the result.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.