exporting contacts from outlook 2010 to excel

To change your view to a table view, go to the View menu.Click on People in the bottom column, and then you will be able to access your Outlook contacts.Open the Microsoft Outlook 2013 or 2016 on your Windows PC.Export Contacts Outlook 2013 & 2016 to Excel Thus, you can click the 'Map Custom Fields' button and go to clear all unnecessary fields before step 8 is executed. It is not a great way to delete superfluous contacts fields in the Excel spreadsheet after export, as sometimes we may delete the important information by mistake. Even if your Outlook contacts didn’t add such contents, the Excel spreadsheet will also display lots of empty columns as instead. What I want to emphasize is that all the fields of your Outlook contacts will export to Excel through this way, such as Car Phone, Government ID number. All your Outlook contacts will be saved as Excel. Now you can click on Finish button to complete the export.Choose the destination to export, and then type the file name for your contacts file, and then press Next.In the next window, choose Contacts and go on.Choose “Microsoft Excel 91- 2003”, and click on Next.Select “Export to a file” option in the following window, and press Next.Both of them will take you to the “Import and Export Wizard” window. Alternatively, you can Choose File Options > Advanced > Export. Navigate to the File menu > Open > Import.Launch Microsoft Outlook 2010 on Windows.Although you can open the exported CSV in Excel, it will show you a bunch of garbled characters. Why is there no Office 365, ? Since these two versions only provide the CSV as output format. In this part, we will mainly introduce how to export Outlook 2010, 2013 & 2016 to Excel on Windows. But it’s a bit difficult to export Outlook contacts to Excel. How to Export Outlook Contacts to Excel on Windows?Īs we said at the beginning, whether making backups of Outlook contacts or using different Outlook email platforms, it is effortless to save contacts as CSV. > Can We Export Outlook Contacts to Excel Directly on Mac?.> How to Export Outlook Contacts to Excel on Windows?.

Exporting contacts from outlook 2010 to excel