How to Export Your Outlook Contacts to a CSV File

Create a contacts list to use in Excel

If you want to back up or use your Outlook contacts in another application or service, just export your Outlook address book in CSV format. Outlook makes the process fast and easy.

Instructions in this article apply to Outlook 2019, Outlook 2016, Outlook 2013, Outlook 2010, and Outlook for Office 365, as well as Outlook Online.

Convert Your Contact List to a CSV File

To export your contact lists, open Outlook and follow these steps:

  1. Go to the File tab and select Open & Export.

    File window in Outlook
    Lifewire
  2. Select Import/Export to start the Import and Export Wizard.

    Open & Export window in Outlook
    Lifewire
  3. Choose Export to a file, then select Next.

    Import and Export Wizard in Outlook
    Lifewire
  4. Choose Comma Separated Values, then select Next.

    Export a file window with Comma Separated Values selected in Outlook
    Lifewire
  5. Highlight the Contacts folder for your email account, then select Next.

    Contacts folder in Export a file window in Outlook
    Lifewire
  6. Select Browse.

  7. In the Browse dialog box, navigate to the location where you want to save the file, enter a file name, then select OK.

  8. Select Next.

  9. Select Finish. The CSV file is exported to the location you designated.

How to Export Outlook Contacts from Outlook Online

If your contacts are stored in the online version of Outlook, the export settings are in a different location. When you export your contacts from Outlook online, they will be saved as a CSV file that can be imported into another email service or account.

  1. Log into your Outlook.com account.

  2. Select the People icon at the bottom of the navigation pane on the left side of the screen to open your list of contacts.

    People icon on Outlook.com
    Lifewire
  3. Select Manage on the toolbar above the contacts list and choose Export Contacts from the drop-down menu that appears. The Export Contacts dialog box will open.

    Export Contacts menu in Outlook.com
    Lifewire
  4. Choose All Contacts if you want to export all the contacts in your account. If you want to export contacts in another folder, select that folder. Select the Export button to continue.

    Export contacts window in Outlook.com
    Lifewire
  5. The exported contacts will be in a CSV file located in your device's default Downloads folder.