No code method to extract/export group members

%3CLINGO-SUB%20id%3D%22lingo-sub-777966%22%20slang%3D%22en-US%22%3ENo%20code%20method%20to%20extract%2Fexport%20group%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777966%22%20slang%3D%22en-US%22%3E%3CP%3EHere's%20a%20quick%20no-code%20method%20to%20extract%20all%20Team%2FGroup%20members%20into%20an%20Excel%20list.%20I've%20seen%20PowerShell%20scripts%20that%20do%20the%20same%2C%20but%20this%20is%20quick%20and%20easy%20and%20anyone%20can%20do%20it%20for%20any%20team%2Fgroup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20the%20Group%20creates%20a%20distribution%20list%20of%20the%20same%20name%2C%20do%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EEnter%20the%20group%20name%20in%20a%20new%20email%3C%2FLI%3E%3CLI%3EExpand%20the%20group%20and%20copy%2Fpaste%20into%20Excel%3C%2FLI%3E%3CLI%3EUse%20Data%20%26gt%3B%20Text-to-Columns%20to%20split%20it%20into%20columns%20by%20semicolon%20delimiter%3C%2FLI%3E%3CLI%3ECopy%20all%20values%3C%2FLI%3E%3CLI%3EPaste%20Special%20%26gt%3B%20Transpose%3C%2FLI%3E%3CLI%3E(optional)%20Use%26nbsp%3BData%20%26gt%3B%20Text-to-Columns%20to%20separate%20the%20names%20and%20emails%20into%20separate%20columns%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-777966%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional 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