Excel Tutorial: How To Make A Contact List In Excel


When it comes to keeping track of important contact information, Excel is a powerful tool that can make the task much more manageable. In this tutorial, we will walk you through the process of creating a contact list in Excel, and highlight the numerous benefits of using this program for organizing and storing your contact information.

Whether you're a business professional hoping to maintain a list of clients, or simply looking for a more efficient way to organize personal contacts, Excel provides a versatile and user-friendly platform for managing this type of data.

Key Takeaways

  • Excel is a powerful tool for organizing and storing contact information, whether for personal or professional use.
  • Setting up an Excel document for a contact list involves labeling columns for different pieces of contact information.
  • Utilizing Excel's sorting and filtering functions allows for easy organization and retrieval of specific contacts.
  • Creating a dropdown list for contact categories and using formulas for automatic formatting can enhance the efficiency and accuracy of the contact list.
  • Overall, using Excel for contact management offers versatility, user-friendliness, and the ability to maintain consistency and accuracy in your data.

Setting Up Your Excel Document

When creating a contact list in Excel, the first step is to set up your Excel document with the necessary columns for each piece of contact information. Follow these simple steps to get started:

A. Open a new Excel spreadsheet

Begin by opening a new Excel spreadsheet on your computer. You can do this by navigating to the Microsoft Excel application and selecting "New" from the file menu, or by simply double-clicking on the Excel icon on your desktop.

B. Label the columns for each piece of contact information

Once your new spreadsheet is open, it's time to label the columns for each piece of contact information that you want to include in your contact list. Common columns for a contact list may include:

  • Name
  • Phone Number
  • Email
  • Address
  • Company
  • Job Title

By labeling the columns in this way, you can ensure that your contact list is organized and easy to navigate.

Entering Contact Information

When creating a contact list in Excel, it is essential to input the contact information into the designated columns. This ensures that the data is organized and easily accessible for future reference.

A. Input contact information into the designated columns

  • 1. Name: Enter the full name of the contact in the designated column. Use separate columns for first name and last name if needed.
  • 2. Email: Input the email address of the contact in the designated column. This allows for easy communication and reference.
  • 3. Phone Number: Enter the phone number of the contact in the designated column. Use a consistent format for all phone numbers for uniformity.
  • 4. Address: Input the address of the contact in the designated columns. Use separate columns for street address, city, state, and zip code for comprehensive information.
  • 5. Additional Information: If needed, create additional columns for any other relevant contact information such as company, position, or any specific notes.

B. Use separate rows for each contact to keep the list organized

  • 1. Row per Contact: Input each contact's information in a separate row to maintain a well-organized and easily accessible contact list.
  • 2. Data Consistency: Ensure that the data is consistently entered in each row for easy reference and analysis. Avoid mixing different types of data in the same column to maintain clarity.

Sorting and Filtering

When creating a contact list in Excel, it is important to organize the information in a way that makes it easy to manage and access. One of the key functions of Excel is its ability to sort and filter data, which can be incredibly useful for managing a contact list.

  • Utilize Excel's sorting function to alphabetize the contact list
  • Sorting the contact list alphabetically can make it easier to find specific contacts and to quickly locate information. To do this, simply select the data range that you want to sort, go to the Data tab, and click on the Sort A to Z or Sort Z to A button, depending on the order you want.

  • Filter the list to easily find specific contacts based on criteria (e.g. location, company)
  • Filtering the contact list allows you to narrow down the information based on specific criteria, such as location or company. To do this, select the data range, go to the Data tab, and click on the Filter button. This will add dropdown arrows to the column headers, allowing you to filter the data based on your specified criteria.

Creating a Dropdown List for Categories

When creating a contact list in Excel, it's helpful to categorize your contacts for easy organization and sorting. Here's how you can create a dropdown list for categories in your Excel contact list.

A. Decide on categories to group contacts (e.g. family, friends, work)

  • Begin by determining the categories that you want to use to group your contacts. For example, you might want to categorize your contacts as family, friends, work, or any other relevant categories.
  • Make sure to choose categories that are meaningful and will help you easily navigate and sort through your contact list.

B. Use Excel's data validation feature to create a dropdown list for the category column

  • Open your Excel contact list and select the column where you want to add the category dropdown list.
  • Go to the "Data" tab on the Excel ribbon and click on "Data Validation."
  • In the Data Validation dialog box, choose "List" from the Allow dropdown menu.
  • In the Source field, enter the categories that you decided on earlier, separated by commas. For example: family, friends, work.
  • Check the "In-cell dropdown" box to enable the dropdown feature in the selected column.
  • Click "OK" to apply the data validation and create the dropdown list for the category column.

Using Formulas for Automatic Formatting

When creating a contact list in Excel, it's important to ensure that phone numbers and email addresses are consistently and accurately formatted. Implementing formulas can help with automatic formatting and maintaining the integrity of your contact list.

Implement formulas to automatically format phone numbers and email addresses

Formulas in Excel can be used to automatically format phone numbers and email addresses. For example, you can use the TEXT function to format phone numbers in a specific way, such as adding parentheses around the area code and hyphens between the digits. Similarly, you can use the CONCATENATE function to format email addresses with the appropriate symbols and domain name.

By using these formulas, you can save time and ensure that all phone numbers and email addresses in your contact list are consistently formatted.

Ensure consistency and accuracy in the contact list

By implementing formulas for automatic formatting, you can ensure that all entries in your contact list follow a consistent format. This not only makes the contact list easier to read and navigate, but it also helps to minimize errors and discrepancies.

Consistency and accuracy in the contact list are crucial for maintaining the professionalism and reliability of your database. By using formulas to automatically format phone numbers and email addresses, you can confidently manage and utilize your contact list for various purposes.


Creating a contact list in Excel offers numerous benefits, including easy organization, quick access to information, and the ability to customize and filter data. By following this Excel tutorial, you can become proficient in contact management and ensure that you have a reliable and efficient system in place for all your contacts.

So why wait?

Try out this tutorial and see how Excel can revolutionize the way you manage your contacts. With just a few simple steps, you can take advantage of all the features that Excel has to offer for contact lists.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles