Export contacts

Outlook contact information isn’t just for work-related communication. Some of your professional contacts might also be friends, and you’d like to reach them using a web mail account, such as Yahoo, Gmail, or Outlook.com. You can also export the information to Excel, Access, or Word and use it in a mail merge or mass mailing.

  1. Click File > Options > Advanced.
  2. In the Export section, click Export.

Export

  1. In the Import and Export Wizard, choose Export to a file, and then click Next.
  2. Under Create a file of type, click the type of export you want, and then click Next.
  • Pick Outlook Data File (.pst) if you’re going to use these items in Outlook on another computer.
  • Pick Comma Separated Values if you’re going to use these items in almost any other program.
  1. Under Select the folder to export from, select the contact folder you want to export, and then click Next.

    Select a folder to export

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

  1. Under Save exported file as, click Browse, choose the folder where you want the file saved and type a name in the File name box.
  2. Click OK, and then click Next.
  • If you're exporting to a .csv file, you have the option to map fields for your contacts.
  • If you're exporting to an Outlook .pst file, you have the option to set a password.
  1. Click Finish. When the Import and Export Progress box disappears, your export is complete.
 
 
Applies to:
Outlook 2013