Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How do you export contacts from Microsoft Outlook 2010 to Excel?

user-image
Question added by Zaid Mahadin
Date Posted: 2015/07/01
Deleted user
by Deleted user

The most common export file format is a comma separated value (CSV) file. If you are exporting contacts for use in another copy of Outlook, we recommend that you choose an Outlook Data File (.pst) in step6 below.

  1. Click the File tab.

  2. Click Options.

  3. Click Advanced.

Advanced command in the Outlook Options dialog box

  1. Under Export, click Export.

Export command in the Backstage view

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

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

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

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

  2. Click OK.

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

  4. Click Finish.

More Questions Like This