Export contacts from Outlook for Windows

You export contacts from Outlook on your desktop using the Outlook Import/Export wizard. First, make sure you're using a desktop version of Outlook. Here's what the ribbon looks like in Outlook 2016 for your desktop. The 2007, 2010, and 2013 versions of Outlook look similar, and you can use them to export contacts, too. If you don't have Outlook installed on your computer, see How to get a copy of Outlook for my desktop.

This is what the ribbon looks like in Outlook 2016.

Does your ribbon say "Office 365" or look different from this picture? See My ribbon says "Office 365" or looks different from the picture.

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.

Choose from the following list of export instructions. To learn how to import contacts, see Import contacts to Outlook for Windows.

Export contacts to a csv file or Excel

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

    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 Manually create your list of contacts in a csv file.

  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.

Were these steps helpful? Please leave us a comment.

Export contacts from Outlook 2010

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

    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 Manually create your list of contacts in a csv file.

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

Were these steps helpful? Please leave us a comment.

Export contacts from Outlook 2007

  1. In Outlook 2007, at the top of your ribbon choose File.

    In Outlook 2007, choose the File tab.

  2. Choose Import and Export.

    Choose Import and Export.

  3. Select Export to a file, and then click Next.

    Choose Export to a file and then choose Next.

  4. Choose Comma Separated Value, and then click Next.

    Choose Comma Separated Values (Windows)

  5. In the folder list, scroll up if needed and choose the contacts folder you want to export, and then click Next.

    Choose the contacts folder you want to export.

  6. Choose Browse, type a name for the exported file, and then click OK.

    Type a name for your contacts file

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

  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 Manually create your list of contacts in a csv file.

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

Were these steps helpful? Please leave us a comment.

Export contacts from Outlook.com (formerly Hotmail) to a .csv file

Here's how you export contacts from Outlook.com to import them into Outlook 2010, 2013, or 2016. You can use this procedure to export them for use in other email services, too.

  1. Sign in to your Outlook.com account.

  2. Choose the app launcher App launcher button in the upper-left corner of your screen, and then choose People.

    Choose People.

  3. On the toolbar, click Manage > Export for Outlook.com and other services.

    Choose Manage.

  4. When prompted to open or save OutlookContact.csv from people.live.com, choose Save As.

  5. Choose a location on your computer to save your OutlookContacts.csv file.

  6. Now that your contacts are copied to a .csv file, you can import them to Outlook 2007, 2010, 2013, or 2016. Follow the instructions for importing a .csv file.

Were these steps helpful? Please leave us a comment.

Export your Google Gmail contacts to a .csv file

Note   Google does not export the photos of your contacts.

  1. Log on to your Google Gmail account.

  2. Choose Gmail >Contacts.

    To import Gmail Contacts to Office 365, in Gmail, select Gmail then Contacts

  3. At the top of the contacts section, select More >Export.

    To import contacts from Gmail to Office 365, in Gmail choose Contacts, More, Export

  4. Under Which contacts do you want to export, choose a contact group or All Contacts.

    Choose Outlook csv format to export contacts that you'll import into Outlook

  5. Under Which export format, select Outlook CSV (for importing into Outlook or another application), and then choose Export.

  6. When prompted to download the export file, choose Save As.

    google gmail export contacts save as

  7. Choose Browse and choose a location on your computer to temporarily save the file. The default file name is contacts.csv.

    Save the contacts.csv file to a location on your computer.

    If you want, you can open the contacts.csv file with Excel to check that all of your contacts were successfully exported. Unless you've been extraordinarily thorough at entering info for your contacts in Gmail, the exported CSV file will likely look something like the following, with info in some cells but not others:

    A sample csv file exported from Google.

    Note    You can delete this file after your contacts are imported into Outlook.

  8. Now that your contacts are copied to a .csv file, you can import them to Outlook for Windows.

Were these steps helpful? Please leave us a comment.

Export your iCloud contacts to a vCard (.vcf) file

Do these steps if you want to download a copy of your contacts from iCloud. After you download a copy of your contacts to a file, you can import the file into Outlook.

  1. Open iCloud.

  2. Open the Actions menu, then choose Select All to mark all of your contacts for export.

    Open the Actions menu then choose Select All.

  3. Open the Actions menu again, and choose Export to copy your contacts to a .vcf file. (Your contacts will still be available in your iCloud account.)

    Choose the Actions menu, then choose Export.

  4. Now that your contacts are copied to a vcf file, you can convert them to a csv file, and then import them to Outlook for windows. For instructions, see Import contacts from iCloud (vCard) to Outlook.

Were these steps helpful? Please leave us a comment.

Export and import for Mac users moving to Outlook for Windows or Office 365/Outlook on the web

Note   You can't export contacts from Outlook for Mac 2016.

Was this info helpful? Please leave us a comment.

Manually create your list of contacts in a csv file

If you can't or don't want to export your list of contacts, you can manually create a CSV file with the information you want to import into Outlook. Download this sample CSV file, open it in Excel, and use it as a starting point for creating your list of contacts. There are a few things to remember when working with this sample CSV file:

  • Outlook requires the column headings in the first row so don’t replace them with something else.

  • Save the file with a new name as a CSV file type (.csv). If you use Excel to work in the file, when you save it, Excel will prompt you a few times with "are you sure you want to save it in CSV format?" Always choose Yes. If you choose No, the file will get messed up and you'll need to start over with a fresh sample template.

  • Practice importing your CSV file with a few contacts to make sure you like the results. Afterwards, you can delete the imported contacts, add more to your CSV file, and import it again.

Here's what it looks in Outlook Web App, for example, like when you import the contacts in the sample CSV file.

After you import contacts, here's what they look like in Outlook on the web.

Was this info helpful? Please leave us a comment.

My ribbon says "Office 365" or looks different from the picture

If your ribbon says Office 365, you're using Outlook on the web, which looks like this:

An image of what the People page looks like in Outlook on the web

If it doesn't, you might be using the Outlook Web App. To get to your contacts, choose the People tile. The ribbon looks like this:

An image of what the People page looks like in Outlook Web App

For both Office 365/Outlook on the web and Outlook Web App, you need to use Outlook on your desktop to export your contacts. You can use Outlook 2007, 2010, 2013, or 2016. Add your email account to Outlook, then export your contacts. If you don't have Outlook on your computer, see How to get a copy of Outlook.

A third possibility is you're using the Mail app for Windows 10. That ribbon looks like this:

This is what the Windows 10 Mail app looks like.

In Windows 10, contacts are stored in the People app. You cannot import or export contacts from the People app in Windows 10. If you'd like to request this feature be added to Mail for Windows 10, visit the Outlook Suggestion Box to leave your feedback in the Outlook on the web group. The Mail and Calendar team is actively monitoring this forum.

Was this info helpful? Please leave us a comment.

How to get a copy of Outlook for my desktop

These options are for people who don't have a copy of Outlook installed on their computer, but want to export contacts from Outlook on the web, or the Outlook Web App. There are a few ways you can get a copy of Outlook installed on a computer:

  • Sign up for a free 30 day trial Office 365. It includes Outlook that you can download onto your computer. Add your email account to the trial version of Outlook. Outlook will sync with Outlook on the web (or Outlook Web App) and you'll see your contacts in Outlook on your desktop. Then use Outlook on your desktop to export your contacts.

    When you're done exporting your contacts, let the trial run out so you aren't charged anything. You'll still have access to your contacts in Outlook on the web (or Outlook Web App), but you'll no longer have access to Outlook on your desktop.

  • Find a friend who has Outlook on their computer. Add your email account to Outlook. Outlook will sync with Outlook on the web (or Outlook Web App) and you'll see your contacts there. Then use Outlook on your desktop to export your files. When you're finished exporting your contacts, remove your email account from your friend's version of Outlook. You'll still have access to your contacts in Outlook on the web (or Outlook Web App).

  • Buy it. Outlook has a lot of great features for managing your email. However, this is an expensive purchase for exporting contacts, and not recommended if that's your only reason for getting it.

Was this info helpful? Please leave us a comment.

Other export topics

Leave us a comment

Were these steps helpful? If so, please let us know at the bottom of this topic. If they weren't, and you're still having trouble exporting your contacts, tell us where you are trying to export contacts from. We'll use your feedback to double-check our steps.

Applies To: Outlook 2016, Outlook 2013, Office 365, Office 365 Admin, Outlook 2010, Outlook 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language