Export contacts from Outlook

When you export your contacts from Outlook, 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.

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

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

  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.

Choose your version for instructions

The instructions are slightly different depending on whether you're using the new Outlook on the web. Choose which version of Outlook on the web you're using to see the steps that apply to you.

IF YOUR MAILBOX LOOKS LIKE...

Outlook on the Web Beta

See Instructions for the new Outlook on the web.

IF YOUR MAILBOX LOOKS LIKE...

Outlook on the web

See Instructions for classic Outlook on the web.

Note: If your organization has included its logo in the toolbar, you might see something slightly different than shown above.

Instructions for the new Outlook on the web

  1. At the bottom of the page, select People to go to the People page.

  2. On the toolbar, select Manage > Export contacts.

    On the toolbar, select Manage and then Export contacts
  3. Choose to export all contacts or only contacts from a specific folder, and then select Export.

  4. At the bottom of the page, select Save to save "contacts.csv" in your default Downloads folder. Or, select the arrow next to Save and select Save as.

Instructions for classic Outlook on the web

  1. At the bottom of the page, select People to go the People page.

  2. On the toolbar, select Manage > Export contacts.

    A screenshot of the Export contacts option in the Manage menu
  3. Choose to export all contacts or only contacts from a specific folder, and then select Export.

  4. At the bottom of the page, select Save to save "contacts.csv" in your default Downloads folder. Or, select the arrow next to Save and select Save as.

  1. At the top of your Outlook 2010 ribbon, choose the File tab.

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

    In Outlook 2010, choose the File tab.

  2. Choose Options.

    Choose Options.

  3. In the Outlook Options box, choose Advanced.

    Choose Advanced.

  4. Under the Export section, choose Export.

    On the Advanced page, choose Export

  5. In the Import and Export Wizard, select Export to a file, and then choose Next.

  6. Under Create a file of type, choose the type of export that you want. The most common is Comma Separated Values (Windows), also known as a .csv file. Then click Next.

    Choose to export a .csv file (Windows)

    If you are exporting contacts for use in another copy of Outlook, choose an Outlook Data File (.pst).

  7. Under Select folder to export from, you may need to scroll up, and then select the contact folder that you want to export. Choose Next when you're done.

    Note: Unless you chose to export to an Outlook Data File (.pst), you can only export one folder at a time.

    Choose the contacts you want export
  8. Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file.

    Type a name for your contacts file

  9. Click OK.

  10. In the Export to a File dialog box, click Next.

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

  12. When the export is finished, choose OK to exit the Outlook Options box.

  13. Go to the location on your computer where you saved your contacts, for example, in the Documents folder.

    Type a name for the file you're exporting

  14. If you exported your contacts as a .csv file, you can use Excel to see what was exported from Outlook. 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

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

To import your contacts into Outlook 2016, see Import contacts to Outlook.

See Also

Import and export Outlook email, contacts, and calendar

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×