Export OutLook contacts to CSV

How to export emails from OutLook

Wondering how to export all email addresses from the email database in Microsoft OutLook, in order for example to import them in Gmail, or find matches in LinkedIn ?

Microsoft OutLook

Gmail
LinkedIn

Export email addresses from OutLook

It is pretty simple. Start by opening the FILE menu:

Export OutLook contacts to CSV : Microsoft OutLook FILE menu

There, in the Open & Export section, open the Import/Export menu:

Export OutLook contacts to CSV : Microsoft OutLook Import/Export menu

Select Export to a file:

Export OutLook contacts to CSV : Export to a file option

Then select Comma Separated Values:

Export OutLook contacts to CSV : Comma Separated Values (CSV) export option

How to export folders from OutLook

Here, selected one folder from where the email addresses will be retrieved – for example the Sent Items folder will contain email addresses of all recipients ever contacted with the mailbox.

Export OutLook contacts to CSV : Export folder selection, for example Sent Items

Select a destination folder for the output file.

Export OutLook contacts to CSV : Export file name and folder selection

Select the Export action, and enter the Map Custom Fields menu – this in order to create a clean file containing only email addresses.

Export OutLook contacts to CSV : Selection of actions to perform

Here, on the right side box, keep only the fields which are interesting, in this case the To and CC email addresses from the emails found in Sent Items folder.

Export OutLook contacts to CSV : Custom fields mapping to select export fields

The Import and Export Progress will show the advancement, as the operation might take some time depending on the amount of emails.

Export OutLook contacts to CSV : Import and Export progress bar

Export email folder from OutLook

And that’s it ! Now, as the result file might contain a lot of unwanted characters (for example Lotus Notes domain names, registered names, …), do not hesitate to use Notepad++ how to extract email addresses from a file in order to obtain a cleaner file that you can then import in another tool.

Notepad++ extract email from file

Export OutLook emails to Gmail

To export OutLook emails to Gmail, you must setup your local OutLook to access your Gmail account, and move the emails from an OutLook folder to a Gmail folder:

set a Gmail account in the Outlook program,
select emails to export from Outlook to Gmail,
right click on the selected emails > move > other folder,
find the Gmail account in the moving window, and click OK.