How do I export my Contacts from Outlook 2010 to Excel?

You can export contacts to a file that can then be imported into other applications, such as Web mail clients, Excel spreadsheets, or database applications.

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

1. Click the File tab.

2. Click Options.

3. Click Advanced.

4. Under Export, click Export.

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.

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.

12. To send us this file go to our other forum for help: https://mediacenter.zendesk.com/entries/21747087-how-do-i-export-my-contacts-from-outlook-2010-to-excel