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

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.

1. Under Export, click Export.

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.

https://support.office.com/en-us/article/Export-contacts-625336d9-14e2-49a8-909d-e4f0