Exporting Distribution List to Excel
How to you export email distribution list from Office 365? Here’s how I do it. I know there are thousand of ways to complete this task. This one works for me all the time.
I login to Microsoft 365 Admin Center (https://admin.microsoft.com) using my administrator email address, password and two-factor authentication.
Go to Active Users, click the Export to CSV file.
From the “Views” you can select specific licenses e.g. E1 Users, E3 License, Kiosk Users, Office 365 Business, Plan K1, etc.
I export them all and clean up using Excel.
Open the file using Excel, then delete the records (data) that you don’t need. Basically, cleaning your data.
You can also use the manual import, following the steps below.
In Excel, open the file choose the “Delimited”. In Delimiters, put check on Tab, Semicolon and Comma. Then click on Next and Finish.
That’s all.
Photo by geralt pixabay
Discover more from QUE.com
Subscribe to get the latest posts sent to your email.
Thank you for reading and sharing your thoughts with us! We’re glad this article caught your interest. Your engagement helps us build a stronger community of informed readers. Be sure to check back for more content on this topic and others — we publish regularly to keep you up to date.
Thank you, QUE.com Team! We really appreciate the kind words. It’s great to hear you found this piece valuable. Stay tuned for more content like this — and feel free to share it with others who might find it useful!