Forum Discussion
Exporting list of Team members without coding
Hi, I'm just a regular joe Teams owner - not and IT person. Is there anyway to export the list of members from Teams without coding? (I saw the answer from 2020 about looking at your list of groups i...
If you have admin permissions, you can export the list via the Teams admin center, or PowerShell. If not, it's a bit more complicated. There are some workarounds via Outlook, but those require the Team to be "visible" therein, which doesn't seem to be the case. Instead, consider using a Flow, such as the one here: https://emea.flow.microsoft.com/en-us/galleries/public/templates/2cc5e634806746aba3d303c3e905001c/get-a-weekly-email-with-the-members-of-all-my-office-365-groups/
Or you can open the Team Members page, select all text via CTRL+A, then copy/paste. It will require some cleanup, but at least it doesn't involve using any other tools 🙂
Or you can open the Team Members page, select all text via CTRL+A, then copy/paste. It will require some cleanup, but at least it doesn't involve using any other tools 🙂
VasilMichev copy and paste puts it into one column for me in Excel - NOT USEFUL!
WHY IS IT SO F%#F$#@# HARD TO GET A LIST OF MEMBERS FOR A MICROSOFT TEAM? WHY does microsoft make such crap?! WHy not just allow when you're listing the group in teams, something simple -- like copy / paste -- So that you can generate an email, paste the $@$#!# names in and BAM super simple, you've got an email, you can send it to the entire group. I've been F$@!!ing with this for 45 min and still can't send a simple email to my team. Why do I have to go to powershell, run a script or go to any other software other than TEAMS to do this crap?
- I feel for you...why is everything so hard and difficult. MS stop focusing on the shinny objects and build functionality that works and makes sense for users.
- Agreed! I am supposed to have 180 people in my group but there are only 120. This is a database - why can you not simply right click on members and export to Excel or CSV?!!! There is no simple way to find out which people are missing from my group - this is a time waster for me!
