Export contacts from Outlook

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

If your ribbon doesn’t have a File option in the top left corner, you’re not using Outlook 2016 or 2013. See What version of Outlook do I have? to get to the export instructions for your version of Outlook.

CompSquare d7f66ed3-9861-4521-b410-e86a58ab15a7 Export contacts from Outlook Uncategorized

Choose Open & Export > Import/Export.

CompSquare 2d887483-b6a9-4244-9094-26627b699722 Export contacts from Outlook Uncategorized

Choose Export to a file.

CompSquare 7167b19a-1959-4675-b8fe-81fa818efb3a Export contacts from Outlook Uncategorized
  1. Choose Comma Separated Values.
  2. 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.
CompSquare dece2b41-08cb-4edc-a140-a8abca01d274 Export contacts from Outlook Uncategorized

Choose Browse, name your file, and choose OK.

CompSquare e3391d36-298f-497e-b85c-55dc1cd2543e Export contacts from Outlook Uncategorized
  1. Confirm where your new contacts file will be saved on your computer, and choose Next.
  2. 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.
CompSquare 8db72d70-125a-488e-984c-1408227b43fa Export contacts from Outlook Uncategorized

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.

CompSquare 08209a81-69cb-4052-a90d-457b837a7a42 Export contacts from Outlook Uncategorized
  1. 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.
  2. 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:
    1. In Outlook on the desktop, choose File > Account Settings > Account Settings.
    2. Choose the account you want to delete, and then choose Remove.
    3. Choose Close.
  3. 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.