Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

When you export your contacts from Outlook for Windows, a copy of your contacts is saved to a CSV file, or other file type. You can then use this file to import your contacts to another email account.

If you're not on Outlook for Windows, check which Outlook version you're on, and then choose one of these options to export contacts:

Important: Steps may be different between new and classic Outlook for Windows. To determine which version of Outlook you're using, look for File on the ribbon. If there's no File option, follow the steps under the New Outlook tab. If the File option appears, select the tab for Classic Outlook.

  1. On the left navigation bar, select  People

    Note: If you don't have People in the left navigation bar, select More apps, then People to add it. After adding People, right-click and select Pin to keep it in the left navigation bar.

  2. On the Home tab, select The Manage Contacts icon. Manage contacts, then Export Contacts.

  3. Under Contacts from this folder, choose an option, then select Export.

  4. The exported .CSV file is saved to your Downloads folder.

  1. In Outlook on a PC, choose File.

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

    This is what the ribbon looks like in Outlook 2016.
  2. Choose Open & Export > Import/Export.

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

  3. Choose Export to a file.

    Choose Export to a file.

  4. Choose Comma Separated Values.

  5. 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.

  6. Choose Browse, name your file, and choose OK.

    Assign a name to your contacts file.

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

  8. 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.

  9. 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

  10. 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.

  11. If you borrowed a friend's computer with Outlook on it, you can now remove your account from that person's 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.

  12. 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.

See Also

Export items to an archive file in Outlook for Mac

Export contacts from Outlook.com or Outlook on the web

Import and export Outlook email, contacts, and calendar

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Find solutions to common problems or get help from a support agent.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×