Microsoft Outlook Export Contacts to Excel (CSV)

In this article we are going to export contacts to an Excel sheet. The resulting file is a CSV file that can be opened in Excel or used for another purpose, such as importing in another program. If you wish to save it as an XLSX file (regular excel file format), simply open it in Excel and save it as a regular file. To get started, open Outlook. Locate the folder containing the contacts you want to export if you have multiple.

Showcasing contacts to export in Outlook interface.
The folder containing the contacts to export is highlighted. Remember its name so you can select it in the export wizard.

Open the Export Wizard and Select The Contacts to Export

Start by opening the import wizard by clicking File > Open & Export > Import / Export.

When the wizard pops up, select “Export to a file” and click Next.

Select “Comma Separated Values”. Click Next.

On this screen, select the Contacts folder to export. This should match the name shown in the contacts section in Outlook. Be careful to select the right folder if you have multiple email accounts in Outlook. Click Next.

Browse to choose a location to save the CSV file. Click Next.

Map Fields and Finish Up

On this screen, ensure the checkbox beside “Export “Contacts” from folder: …” is checked. Click Map Customer Fields … to configure the mapping. Outlook allows you to pick and choose what data you want to export. If you only need names and emails, for example, click Clear Map on the right side and then drag over only Name and Email Address fields from the left. If you want to export everything, just click Default Map. Then click OK on the Map Custom Fields Window. Then click Finish in the main wizard.

Showing the exported file in Excel.
The exported file.

Done. Pictured above is the resulting file opened in Excel. You will notice there are many blank columns because I chose to use the default map and I don’t have all that information in my contacts. If you want fewer blank columns, only export the fields you know the contacts have data for. If you have questions or comments, please leave a comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *