How do I export my contacts from Outlook?

This applies to: Outlook 2016, Outlook 2013, Office for business, Office 365 Admin, Outlook Web App for Office 365, Outlook 2010, Outlook 2007, Outlook on the web for Office 365 Business, Outlook on the web for Exchange Server 201.

Step 1: Make sure you're using a desktop version of Outlook: 2007, 2010, 2013, or 2016. To verify you're using one of these apps, look at the picture below:

This is what the ribbon looks like in Outlook 2016.

Now look at Outlook on your computer:

If your Outlook ribbon has a File option in the top left corner, then you're using a desktop version of Outlook and you're in the right place! See one of the procedures below to export your contacts.

If your ribbon looks different from this picture, see What version of Outlook do I have? to determine which version of Outlook you're using and to get to the right export instructions.

When you export your contacts from Outlook, a copy of your contacts is saved to a file. You can then use this file to import your contacts to another application.


Export contacts to a csv file or Excel

In Outlook 2013 or 2016 on a PC, choose File.

This is what the ribbon looks like in Outlook 2016.

Choose Open & Export > Import/Export.

Choose Open & Export, and then choose Import/Export.

Choose Export to a file.

Choose Export to a file.

Choose Comma Separated Values.

THIS STEP IS KEY especially if you're borrowing a friend's computer: In the Select folder to export from box, scroll to the top if needed and select the Contacts folder that's under your account. Choose Next.

Scroll up and then choose the contacts folder you want to export.

Choose Browse, name your file, and choose OK.

Assign a name to your contacts file.

Confirm where your new contacts file will be saved on your computer, and choose Next.

Choose Finish to start exporting your contacts immediately. Outlook doesn't display any message when the export process is complete but the Import and Export Progress box goes away.

A picture of the export progress box.

Locate the new .csv file on your computer and open it with Excel to verify your contacts are there. You'll likely have a lot of empty cells. That's normal.

An example of what a csv file looks like after contacts are exported from Outlook

Generally we recommend closing the file without saving any changes; otherwise the file might get messed up and you won't be able to use it for importing. If that happens you can always run the export process again and create a new file.

You can use Excel to update the information in your .csv file. For tips about working with a list of contacts in Excel, see Create or edit .csv files.

If you borrowed a friend's computer with Outlook on it, you can now remove your account from his version of Outlook. Here's how:

In Outlook on the desktop, choose File > Account Settings > Account Settings.

Choose the account you want to delete, and then choose Remove.

Choose Close.

Now that your contacts are copied to a .csv file, you can import them to another computer with Outlook for Windows on it, or import them to another email service.

For further information see Microsoft support page:


Please sign in to leave a comment.
Powered by Zendesk