No code method to extract/export group members

[Brian Riesen]

Here's a quick no-code method to extract all Team/Group members into an Excel list. I've seen PowerShell scripts that do the same, but this is quick and easy and anyone can do it for any team/group.

Since the Group creates a distribution list of the same name, do the following:

1. Enter the group name in a new email
2. Expand the group and copy/paste into Excel
3. Use Data > Text-to-Columns to split it into columns by semicolon delimiter
4. Copy all values
5. Paste Special > Transpose
6. (optional) Use Data > Text-to-Columns to separate the names and emails into separate columns