Share via

O365 Export Distribution Lists to a CSV using a GUI

Anonymous
2017-02-02T07:42:17+00:00

How can I export several distribution lists to a CVS file? Using the web interface?

I can find the group and then in "more" I see "Export data to a CVS file".

A file is exported but it has no list of names in the distribution simply the title of the columns.

Does anyone know how to do this? is this broken?

Thanks in advance.

Microsoft 365 and Office | Subscription, account, billing | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2017-02-02T17:57:50+00:00

Thanks Vanessa

This is great but I had already found a few postings online as to how to do this with powershell.

My issue is how to do it via the web admin with no need for any command line interface.

It seems to me there should be a mention that the option is broken and MS has not figured out how to do this yet on their admin console. Why have an export to cvs option, with no data ha ha ha. best to remove it.

I know lots of IT staff that are fairly fresh with little cdl experience so a gui is the only admin interface they know. Also many companies opt for O365 Exchange for ease of management or not having internal trained staff or highly technical staff (sort of a selling point if you ask me).

Any ways its just another MS issue that will never be fixed.

I got what I needed using outlook.

Simply open a new email and add the group in the "To" field

Then click the "+" in front of group to expand to see everyone in the group.

Select all and copy into excel (or word)

  • That's all for viewing the names in that group and you can save as text or csv.

I wanted to go one step further and set this up with all names in their own row down one column so I did this in excel (might help someone)

Use the data to text to import and separate with semicolon delimiter

Then select and copy entire row and paste special "transpose" to another cell.

Done got entire group with name and email addresses each in their own row going down one column.

This now can be used as a list to check off etc.

Thanks again for your quick response.

Cheers

-James

Was this answer helpful?

2 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-02-03T11:39:39+00:00

    Hi James,

    Thank you for sharing this here. I believe it will benefit others with the same scenario. 

    Best Regards,

    Ruel

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-02-02T10:33:55+00:00

    Hi James,

    Yeah, you are right. A file is exported no list of names if it is exported from GUI. To achieve the goal, you can use Power Shell as image below shows.

    For your convenience, I attach the script there:

    Get-DistributionGroupMember -Identity "******" | Export-Csv C:\Users\Desktop\123.csv

    Note: ***** means your Distribution Group name.

    Before doing this, you need to use admin account to connect to Exchange Online with Power Shell referring to the article: Connect to Exchange Online PowerShell.

    We are looking forward to your reply.

    Thanks,

    Vanessa

    Was this answer helpful?

    0 comments