In the opening Save As dialog box, please view below screenshot: See screenshot:Īnd now you will see the specified text file is imported and placed at the specified range. Now the Import Data dialog box comes out, please specify the destination you will place the imported text file, and click the OK button. Please keep selecting the Delimited option, and click Finish button. In the opening Import Text File dialog box, please (1) open the folder the specified text file is saved in, (2) specify All Files from the drop down list besides File name box, (3) select the specified text file, and then (4) click the Import button. Launch Microsoft Excel, and click Data > From Text. Now the specified contact group is saved as a separate text file.Ĥ. In the Save As dialog box, you need to (1) click to open the destination folder for saving the exported contact group (2) Rename the exported file as you need (3) Select Text Only from the Save as type drop-down list and finally (4) click Save button. Select the contact group you will export, and click File > Save As.ģ. In Outlook, shift to the Contact view, and open the contact folder containing the specified contact group.Ģ. For exporting distribution list (contact group) as csv file and import it to Excel from Outlook, please do as follows.ġ.

Export office 365 contacts to csv