How do you export an outlook distribution list to excel?

Answer by  BigD103 (548)

Click on File...Export.. and then choose the location of the Distribution List or Contacts. You will then be given the open of file format. CSV serves well for export into Excel and almost any database driven program. Once the file is exported simply open it up in Excel. You may need to format it a bit.

Answer by  A84 (90)

Open Microsoft Office and select File from the file menu. Look for Import/Export and select it. It'll open a box asking what you want to do. It's self-explanatory from there.

Answer by  NarenMukherjee (308)

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.

Answer by  Blossom9283 (358)

To export from Outlook to Excel, in Outlook go to File than export and choose what you need to export and where to save the file. Choose the excel version when saving and then open the file in Excel.

Answer by  nickl2000 (540)

In the toolbar at the top, first go to file. Then go to "Import and Export". Then select "Export to a File", then choose "Microsoft Excel." Just follow the wizard from there

Answer by  Xisco21 (110)

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.

Answer by  anbu (5968)

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.

Answer by  vijayparttimejob (2254)

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.

Answer by  AliJanjua (14)

Click on contacts, double click on the list to edit, save file as a text file and open the text file in Excel. And that should do it for you.