How to export Outlook Contacts to a CSV file

Outlook 365
You may want to save Outlook contacts for future use. For example, to move them to another PC, or add them to another email client. Fortunately, you can save all contacts to the file in CSV format.

To save Outlook contacts, open Outlook and follow these steps:

   1.   On the File tab, click Open & Export, then click the Import/Export button:

Import/Export in Outlook 2016

   2.   In the Import and Export Wizard dialog box, choose the Export to a file option, and then click Next >:

Import and Export Wizard in Outlook 2016

   3.   In the Export to a File dialog box:

   3.1.   Choose the Comma Separated Values option, and then click Next >:

Create a file of type in Outlook 2016

   3.2.   Highlight the Contacts folder that you want to save, and then click Next >:

Select folder to export from in Outlook 2016

   3.3.   Click the Browse... button:

Save exported file as in Outlook 2016

   3.4.   In the Browse dialog box, choose the location where you want to save the file, enter a file name, and then select OK:

Browse dialog box in Outlook 2016

   3.5.   Click Next >:

Save exported file as in Outlook 2016

   3.6.   Click the Finish button:

The following actions will be performed in Outlook 2016

The CSV file is exported to the location you specified. See How to import Contacts from a CSV file into Outlook.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more