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:
Step 2: Click Open & Export, and then choose Import/Export:
Step 3: Select ‘Export to a file’ and then click Next:
Step 4: Select ‘Comma Separated Values’ and then click Next:
Step 5: Select ‘Contacts (This computer only)’ and then click Next:
Step 6: Click Browse and choose both a name and location for the exported file and then click Next:
Step 7: Click Finish:
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.