How to export contacts from Outlook to Excel spreadsheet?

Exporting Outlook contacts to a file is an easy way for you to import the contact file into other applications. You can get rid of typing the same contact information over and over again by using the following method.

Export contacts from outlook to excel spreasheet

Kutools for Outlook: 20+ New Advanced Tools for Outlook.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013 and 2016.

arrow blue right bubble Export contacts from outlook to excel spreasheet

1. After launch your outlook, click File > Options. See screenshot:

2. When the Outlook Options window popup, click Advanced. In the right pane, click Export button.

3. In the Import and Export Wizard dialog, select Export to a file option, and then click Next button.

4. Select Microsoft Excel 97-2003, then click Next button. See screenshot:

5. Under the Select folder to export from, select Contacts option, then click Next to continue.

6. Under Save exported file as, click Browse button to select a destination folder.

7. In the File name column, type a name for the file. And then click OK button. After clicking OK button, it returns to the previous window, click Next, See screenshot:

doc-export-contact

8. If you want to manually customize the map by yourself, click Map Custom Fileds button. See screenshot:

9. If you don’t like the default setting, click on the Clear Map button to remove all the values on the right pane. And then you should choose your own value from the left pane. Just like the instructions giving in the dialog box: you need to drag the values from the source file on the left, and drop them on the appropriate destination field on the right. When finish setting, click on OK button.

10. Then it turns to the previous window, click on Finish button. Now, an Excel file with outlook contacts information is created.

 

arrow blue right bubble 20+ Powerful Tools and Features for Outlook 2010 / 2013 / 2016 / Office 365:

li-orangeCompatible with Outlook 2010 / 2013 / 2016 / Office 365 (32/64);

li-orangeCompatible with Windows XP, Windows Vista, Windows 7 / 8 / 10, Windows Server 2003/2008, Citrix System and Windows Terminal (Remote Desktop) Server;

li-orangeFree trial without feature limitation in 45 days!

READ MORE | FREE DOWNLOAD | BUY NOW

Comments  

Permalink +2 Lynn
Here's the instructions on how to export contacts
2013-12-10 17:38 Reply Reply with quote Quote
Permalink 0 Lynn
Instructions on how to export contacts into excel
2013-12-10 17:39 Reply Reply with quote Quote
Permalink -1 Sharon Roberts
Here is the instructions on how to export contacts into excel. If you have any questions please let me know.
Thank you,
Maria
2013-12-11 21:50 Reply Reply with quote Quote
Permalink +10 Janette
If I export contacts into excel will I loose them in Outlook? I want to copy contacts to excel, not permanently move them to excel.
2013-12-20 01:54 Reply Reply with quote Quote
Permalink -1 Nuki
very helpful, i love it
2014-01-22 04:30 Reply Reply with quote Quote
Permalink 0 Secretary
I managed to export the 'contacts' folder to Excel file, but No data!
What am I doing wrong?
2014-04-23 13:35 Reply Reply with quote Quote
Permalink 0 Toddie
I had created an distribution list that I now want to export to excel. I need to be able to see each of the names in the list but using this export function does not allow me to do that. Please help :) Thanks
2014-10-28 17:33 Reply Reply with quote Quote
Permalink 0 Lucy
I was able to export the file to an Excel spreadsheet, except that it didn't export my user-defined columns, which made the spreadsheet useless! I could not see any way to do that. Do you?
2014-11-19 18:24 Reply Reply with quote Quote
Permalink 0 chantal
I also could export but all went into one coloumn and I couldn't separate name from email so is useless. who has figured it out?
2015-05-18 14:28 Reply Reply with quote Quote

Add comment


Security code
Refresh