How to Export Outlook 2013 Contacts to Excel

The information that you have stored for your contacts in Microsoft Outlook 2013 can be useful for a number of different reasons. Aside form storing information about how to get in touch with friends, family, coworkers or clients, it also makes it easier to perform certain tasks, like making distributions lists.

But whether you simply want to create a backup of this information to prevent it from being lost, or you need to view all of your contact information in one file to combine email addresses or phone numbers, the ability to put that information in a spreadsheet that Excel can read is very helpful. Fortunately you can export all of your contacts from Outlook 2013 to a .csv file that you can view in Microsoft Excel.

Export Outlook Contacts to a .csv File

During the process of exporting your Outlook 2013 contacts to the .csv file format, you will be given the option to alternatively export them to a .pst file. This is not beneficial for the purpose of viewing your contacts in Excel, but can be helpful if you need to copy contacts from Outlook on one computer to Outlook on another computer. But since we are focused on exporting the Outlook contacts to a file format that can be read by Microsoft Excel, follow the steps below.

Step 1: Launch Microsoft Outlook 2013.

Step 2: Click the File tab at the top-left corner of the window.

click the file tab

Step 3: Click the Open & Export option in the column at the left side of the window.

click the Open and Export button

Step 4: Click the Import/Export button.

select the Import export option

Step 5: Select the export to a file option, then click the Next button.

choose to export to a file

Step 6: Select the Comma Separated Values option, then click the Next button.

export outlook 2013 contacts as a csv file

Step 7: Select the Contacts option under Personal Folders, then click the Next button.

select the contacts folder

Step 8: Click the Browse button, enter a name for your exported file into the File Name field, select the location for the exported file, then click the OK button.

enter a name for the exported file

Step 9: Click the Next button.

Step 10: Click the Finish button.

create the contacts csv file

Do you need to buy some gift cards for someone, but you are looking for an option that is a little more personal than the generic ones you would find in stores? Amazon gift cards can be customized with your own pictures, and can be created in multiple different denominations. You can even create video gift cards. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.