How to Export Your Outlook Contacts to a CSV File

Create a contacts list to use in Excel

Export Your Outlook Contacts to a CSV File

Devon Pankiw / Pexels 

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.

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.

    Screenshot of File window
  2. Select Import/Export to start the Import and Export Wizard.

    Screenshot of Open & Export
  3. Choose Export to a file, then select Next.

    Screenshot of Import and Export Wizard
  4. Choose Comma Separated Values, then select Next.

    Screenshot of Comma Separated Values
  5. Highlight the Contacts folder for your email account, then select Next.

    Screenshot of Contacts folder
  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.