Exporting Outlook 2016/2013/2010/2007 Contacts to CSV

The process to export Outlook contacts in an excel file is quite similar whether you’re using Outlook 2016, 2013, 2010, or an older version Outlook 2007. The job to transfer contacts into CSV format in MS Outlook is performed using inbuilt feature Import and Export feature.

However, if you’re unable to access your Outlook profile, OST file got corrupted, or want to recover deleted contacts into csv format from Outlook OST file; I suggest you try Stellar OST to PST Converter tool because the below manual procedure only works if Outlook is working appropriately.

So in case if everything is fine and you have to just retrieve contacts from Outlook, follow the below steps depends on your current Outlook version.

How to Export Outlook 2016/2013 Contacts in CSV file

1. Open Outlook and navigate through File -> Open & Export -> Import/Export.

2. Select Export to a file option and click Next.

3. Choose the default selected option Comma Separated Values

4. For exporting Outlook contacts, select contacts folder from the listed folders and click Next.

5. Browse the location where you want to export Outlook contacts file and click OK.

6. Now click Finish to complete the process. The progress will be shown on your screen, however Outlook will nor prompt any message once the file has been saved. You will have to browse the location manually where you have saved this file.

7. Once you locate the file, open it using MS Excel program. 

How to Export Outlook 2010 Contacts to CSV

The process to export contacts from Outlook 2010 to a csv file is as same as Outlook 2016 and 2013. However, the below steps helps a lot if you have recently moved to Outlook 2010 from any older version.

1. Navigate through File -> Options -> Advanced, and select Export option under the Export section.

2. Import and Export wizard prompts on your screen. Select Comma Separated Values (Windows) from the list and click Next.

3. Scroll up the Contacts and select the folder which you want to export and save into csv format. 

4. Browse the location to save the file and click OK. Click Next in the dialogue box and click Finish. Once the progress has been closed, you can check the saved CSV file at desired location.

5. Open the file using MS Excel which looks like-

How to Export Contacts List from Outlook 2007 to Excel

There is no difference among the Outlook versions to export contacts list. In case if you’re using older version Outlook 2007, follow the screenshots to extract contacts from Outlook to an Excel file.

Navigate through File -> Import and Export, select Export to a file, Comma Separated Values (Windows) and click Next.

Select the folder under the Contacts and save this file as CSV at desired location. Then click Next and Finish.

Go to the location in your computer where you have saved this file as CSV form, and open it using MS Excel once the progress box away. 

 That’s it!

So this is the quick method to export and save Outlook contacts into CSV file. Later, you can import this contacts CSV file to Outlook again.

However, if you’re unable to export Outlook contacts due to discrepancy in OST file; better to use Stellar OST to PST converter to extract contacts from user’s mailbox to CSV format. Download the demo version of the software to check the preview of Outlook contacts: http://www.stellarservertools.com/ost-pst-converter.php