Export contacts from Outlook 2013 and Outlook 2016

You can export contacts from Outlook 2013 and Outlook 2016 using the Outlook Import and Export Wizard. You can export contacts to Excel, Access, or Word, and use them in a mail merge or mass mailing. You can also export the contacts data to into a file so you an import them into another email service.

  1. Click File > Options> Advanced.

  2. In the Export section, click Export.

    Export

  3. In the Import and Export Wizard, choose Export to a file, and then click Next.

  4. Under Create a file of type, click the type of export you want:

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

  5. Click Next.

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

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

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

  9. Click Finish. When the Import and Export Progress box disappears, your export is complete.

Applies To: Outlook 2016 Preview, Outlook 2013



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!

Support resources

Change language