Export contacts from Outlook 2010

You can export contacts from Outlook 2010 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 the File tab.

  2. Click Options.

  3. Click Advanced.

    Advanced command in the Outlook Options dialog box

  4. Under Export, click Export.

    Export command in the Backstage view

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

  6. Under Create a file of type, click the type of export that you want, and then click Next.

    The most common is Comma Separated Values (Windows), also known as a CSV file.

    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, select the contact folder that you want to export, and then click Next.

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

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

  9. Click OK.

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

  11. Click Finish.

Applies To: Outlook 2010



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