Get a list of the contacts in your Outlook address book

26 Oct 2018
Perrit Support
231
0
< Back

Saving a copy of contacts in your address book is a good practice. In Outlook 2013 or Outlook 2016 for Windows, you can download a comma-separated value (.csv) file of your contacts to your device and open it in Excel.

  1. Open Outlook, choose File > Open & Export > Import/Export.
    Choose Open & Export, and then choose Import/Export.
  2. In the Import and Export Wizard, choose Export to a file > Next.
  3. Choose Comma Separated Values and then, on the Export to a File page, choose Contacts as the folder to export from for your account.Scroll up and then choose the contacts folder you want to export.

    Important: Before proceeding, make sure the Contacts folder you choose is attached to your email account. This is especially important if you’re carrying out these steps from another person’s computer.

  4. Choose Next > Browse, and then go to the location where you want to store the comma-separate values (.csv) file.
  5. Type a file name, and then choose OK > Next.
    Save your contact address book as a .csv file
  6. Choose Finish to start the export process.

    Note: Outlook doesn’t display a message when the export process is complete.

Open your contact .csv file

The comma-separated value (.csv) file of your exported contacts typically is opened in Excel.

  1. Browse to the location where you saved the .csv file and open it.
  2. Confirm your contacts are listed in the file.
    Example of Outlook .csv file opened in Excel

    Note: There might be empty cells. It’s normal.

  3. Close the file without making any changes to avoid potential problems importing the file on a different device that has the same version of Outlook or a different email service.

© Microsoft