This post summarizes how to export Outlook contacts to Excel on Windows and Mac. It also recommends a to export Outlook Contacts to Excel, CSV, vCard, Gmail, iCloud, Google, etc. Within one software. Microsoft Outlook (formerly Hotmail) is a de facto email client at many offices. It contains many features that make our work and life conveniently, and one of the most valuable features is to export contacts from Outlook. We can easily export Outlook contacts to CSV and vCard, but to Excel, we still need spend some time learning about it. Here we will focus on 4 ways of exporting Outlook contacts to Excel, 2010, 2013 & 2016, etc. Outlook versions include. • >> • >> How to Export Outlook Contacts to Excel on Windows? As 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. But it’s a bit difficult to export Outlook contacts to Excel. In this part, we will mainly introduce how to export Outlook 2010, 2013 & 2016 to Excel on Windows. It will create your Contacts as vCard or VCF file. How to Export Contacts from Outlook for Mac to CSV file? Run Mac Outlook 2011 & from File menu select Export option. In the Export Assistance box, click on Outlook for Mac Data file (.olm). From Items of the following category option, select only Contacts check-boxes. Why is there no Office 365, Outlook.com? Since these two versions only provide the CSV as output format. Although you can open the exported CSV in Excel, it will show you a bunch of garbled characters. Export Contacts Outlook 2010 to Excel • Launch Microsoft Outlook 2010 on Windows. • Navigate to the File menu > Open > Import. Alternatively, you can Choose File Options > Advanced > Export. Both of them will take you to the “Import and Export Wizard” window. • Select “Export to a file” option in the following window, and press Next. • Choose “Microsoft Excel 91- 2003”, and click on Next. • In the next window, choose Contacts and go on. • In the next moment, select Browser. • Choose the destination to export, and then type the file name for your contacts file, and then press Next. • Now you can click on Finish button to complete the export. All your Outlook contacts will be saved as Excel. 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. It sure as heck isn’t Half-Life 3. No, it’s not Portal 3. Instead, it’s a collectible card game inspired by Valve’s popular multiplayer online battle arena Dota 2 and it’s designed by Richard Garfield, who gave the world Magic: The Gathering in 1993. Shares some design similarities with Magic, but it distinguishes itself with Dota-like gameplay featuring three “lanes” and two victory options. Even if your Outlook contacts didn’t add such contents, the Excel spreadsheet will also display lots of empty columns as instead. 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. Thus, you can click the 'Map Custom Fields' button and go to clear all unnecessary fields before step 8 is executed. Export Contacts Outlook 2013 & 2016 to Excel • Open the Microsoft Outlook 2013 or 2016 on your Windows PC • Click on People in the bottom column, and then you will be able to access your Outlook contacts. • To change your view to a table view, go to the View menu. In Current View menu group, click on Change View > Phone option. • Click on View Settings, choose Columns under “Advanced View Settings: Phone” window. And select available fields from the drop down list. In this step, you can remove or add fields you would like to export. Once finished, click OK and then click OK button again. • Press Ctrl + A key to select all of your Outlook contacts. Copy the same contacts you just selected. • Launch Excel on your Windows, and the paste all your copied Outlook contacts, and save them as Excel.xlsx format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |