exporting contacts from outlook 2010 to excel

In the Browse dialog, type a name for the exported file in the ' File name' field and click OK.Click the Browse button to select a destination folder to save the exported file to. Well, you have just chosen the data to export and now you need to specify where you want to save them.Since we are exporting our Outlook contacts, we choose Contacts under the Outlook node, as shown in the screenshot below, and click Next to continue. Note that Outlook 2010 is the last version where this choice is available, in Outlook 2013 your only option is ' Comma Separated Values (Windows)'. If you want to export the contacts to earlier Excel versions, then select ' Microsoft Excel 97-2003'. Select ' Comma Separated Values (Windows)' if you want to export your Outlook contacts to Excel 2007, 2010 or 2013 and click the Next button.On the first step of the Import and Export wizard, choose ' Export to a file' and then click Next.

I'll remind you that in Outlook 2010 you can find it on the File tab > Options > Advanced. Open your Outlook and navigate to the Import/Export function, as shown in the screenshots above.We are going to do this in Outlook 2010, and lucky you are if you have this version installed :) Now that you know where the Import/Export feature is located, let's have a closer look at how to export contacts from your Outlook address book to an Excel spreadsheet. How to export Outlook contacts to Excel using the Import/Export wizard Import and Export function in Outlook 2007 and Outlook 2003Ĭlick File on the main menu and choose Import and Export. On the File tab, choose Options > Advanced > Export: On the File tab, choose Open & Export > Import/Export:Īlternatively, you can open the same wizard by going to Options > Advanced > Export, like you do in Outlook 2010. Before exporting your contacts to Excel, it makes sense to merge duplicate contacts in Outlook Import/Export function in Outlook 2021 - 2013

Exporting contacts from outlook 2010 to excel