In Outlook, on the File menu, click Export. Click Microsoft Excel, then In the folder list, click the Contacts folder. Browse the folder save the contacts as an Excel file.
It does not appear to be possible to directly export an Outlook distribution list to Excel. Instead, right click the DL in the contacts list, choose 'send full contact', then select 'Internet format (vCard)'. You'll be shown an email with an attachment - use this attachment within Excel.
In the outlook file menu click import and export. click export to file and then click next. Then open excel,click next then in the contact folder click next. Browse the folder where you want to save the. xsl file. Then click next and then click ok. that's it.
Select "Import and Export" under File in your top menu bar to activate the Import-Export Wizard. Select "Export to a file" and next. select ms-excel and then next. Select distribution list and Next. Type your file name,browse,next,ok. Check "export... ". Click "Map Custom Fields". Drag field in your Outlook contact list. then ok,finish.