How To Export Contacts From Outlook To Excel

How To Export Contacts From Outlook To Excel

Manually exporting contacts from Microsoft Outlook 2013, 2016 or Office 365 into Excel is easy. Exporting is beneficial if you need to transfer your contacts into a different application like our ClientLook commercial real estate software, or if just want to make a backup of your data. Either way, the process is easy if you follow the simple steps outlined below.

Step 1: Open Outlook and click on the File tab at the top left:

Export Contacts From Outlook To Excel_1

Step 2: Click Open & Export, and then choose Import/Export:

Export Contacts From Outlook To Excel_2

Step 3: Select ‘Export to a file’ and then click Next:

Export Contacts From Outlook To Excel_3

Step 4: Select ‘Comma Separated Values’ and then click Next:

Export Contacts From Outlook To Excel_4

Step 5: Select ‘Contacts (This computer only)’ and then click Next:

Export Contacts From Outlook To Excel_5

Step 6: Click Browse and choose both a name and location for the exported file and then click Next:

Export Contacts From Outlook To Excel_6

Step 7: Click Finish:

Export Contacts From Outlook To Excel_7

Your export will produce a text file that has a “CSV” extension like filename.csv. This type of file can be easily imported into most 3rd party products and services like ClientLook.

Your export file can be opened in Excel just by double-clicking it. Once the file opens you will probably notice that there are many columns of data that are empty. That’s pretty typical and not something to be concerned with. Feel free to remove any of these unwanted columns in Excel without worrying that your original data will be affected. This process is especially useful if you intend to import this data into a new application. If you are importing your contacts into ClientLook CRM then remember that you can create custom fields to import just about any data desired into your account.

About the Author

Keith Rudnick

Keith Rudnick - Professional Services Manager, ClientLook, Ltd.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.