No code method to extract/export group members

Brass Contributor

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
0 Replies