How to Import Outlook 2010 Distribution List into Excel


In this video tutorial we will show you how to import outlook distribution list into excel.

Launch the Microsoft Outlook. Go to “Contacts”.

Contacts

Select the distribution list you want to export. Go to the “File” menu and choose “Save As”. Choose the folder to save the file, then select “Text only” in “Save as type” and then press “Save”.

Save

Close Outlook. Launch Microsoft Excel.

Launch Microsoft Excel

Go to the “File” menu and choose “Open”. In the following window, go to the folder where the imported file is, choose “All files” type, then select the file and press “Open”.

Open

In the following “Text import Wizard” window, choose the “Delimited” file type. You can also choose the row to start at. When it’s done, press “Next”. In the step2 window, go with the defaults and press “next”. In the step3 window, press “Finish” to complete the import.

Finish

Now you can see the imported data.