How can I export contacts from Outlook 2013 to CSV
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.
- Choose Open & Export > Import/Export.
- 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.
- Choose Browse, name your file, and choose OK.
- 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.
- 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.
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.