How to Export Contacts from Outlook to Excel Files?
In the previous blog, I have been discussed the procedure to import excel contacts files to Outlook. Now, we were going to elaborate on how to export contacts files from Outlook 2007, 2010, 2013, 2016, 2019, etc. to Excel files. Microsoft Outlook provides you the export option, so without enforcing any effort, just follow the given below process and export Outlook contacts into excel format.
A Quick Solution: If you are looking for a method to instantly import contacts from Outlook to Excel file format, then try the utility given below. It is a sure-shot solution for Outlook Contacts to Excel exportation. The added files will be exported into CSV format and then the extension can be easily changed.
Steps to Export Contacts from Outlook 2003 & 2007 to Excel
- Open Microsoft Outlook.
- Go to the “File” menu then click on the “Import/Export wizard” option.
- Choose “Export to file” from the given list of options, and then click the “Next” button.
- Now choose “Microsoft Excel 97-2003” from the (Export to a file) window and click on the “Next” button.
- Select “Contact folder” that you want to export, and then click on the “Next” button
- Click “Browse”, and then select the destination folder.
- In the File name box, type a name for the file then click on “Ok”.
- After Browsing the path click on the “Next” button.
- Now select the check box Export “Contacts” from folder: Contacts and then, click “Finish”.
Steps to Export Contacts from Outlook 2010 & 2013 to PST
- Open Microsoft Outlook.
- Click on the “File” menu then click on “Open” in the left side navigation.
- Click on the “Import” button.
- Select the “Export to a file” option and then click the “Next” button.
- Choose Microsoft Excel 97-2003 (From Export to a file wizard) and then click the “Next” button.
- Select the “Contact folder” that you want to export, and then click on the “Next” button.
- Click “Browse” and then select the destination folder.
- In the “Filename” box type a name for the file then click “Ok”.
- Click “Next” and then “Finish”.
Note: By Exporting Outlook Contact into Excel you can move it to different platforms like Lotus Notes, Outlook Express, Entourage, Thunderbird, Windows live mail, Outlook web access, and SharePoint, etc.
The Final Verdict
The above-mentioned blog elucidates a complete process to export Contacts from Outlook to Excel file format. Users can easily follow the steps mentioned above to achieve the task without any difficulty. A quick solution to perform Outlook contacts to Excel exportation has been mentioned as well. Users can avail the efficient and error-free method without spending a single penny.
Also Read: Ways to Eliminate Duplicate Contacts from Outlook