Export a list of all Teams members as a CSV file 

Doesn't seem possible to switch to old version of Teams in the browser version. Switching in my Desktop version doesn't affect the browser version it seems. So the script doesn't work :(

Great video! when do you think you will have the new code for the new version of teams ready? Thanks!!

@@joanneb.8059 unfortunately first attempts were not successful with the new version of teams. We can get data exported but it will not export the data from all members. Reason is that the old version would load all the info of all the members as you scrolled down. The new version does not do this. It only holds the info of the members in current view.

SO true. Thanks for your comment and of course a big thanks to Guillaume Meyer for the code.

In Edge I got the "undefined" response but it seems to work in Chrome

could not agree more.

no you should not need to change any values. make sure you have no other browser tabs open. Also try using a different browser. It should work fine as i have many educators using this feature frequently. Maybe stating the obvious but restart your device, not shut down but restart. Let us know if you get it working and if you do, what worked for you.

I have the same problem. The first time, I get the admins only. Second time, I get undefined.

I then moved from chrome to Firefox, there I managed

Switch to the old wrsion of Teams.

Switch Teams back to the old version abd try. There is a toggle switch which allows you to go back to using the old version or new. Switch back to the old and try.

@@paphitisn I doubt if that toggle switch still exists in teams, couldnt find Thanks!

Make sure no other tabs are open. Also make sure that all the members load before running the code. I have not experienced this issue so cannot fault find.

Press F12 key on the keyboard

Make sure you only have one tab open in your browser. See if that works

Have just tested and works fine with Chrome. the only difference i saw was that when pasting the code in the console a warning message popped up which required you to type Allow Pasting before being able to paste the code for security reasons.

Thanks for your feedback. I am glad you found a solution that works for you. I must admit, i use this frequently. I dont bother saving the lists as it is so easy to generate a new one everytime and it is updated

i have tested this with the new version and it works fine.

if the new version is causing and issue for you ten you can switch to the old version by clicking the ellipsis at the top right of Teams and sliding the switch

Please check the steps carefully. Are you sure you copying the entire code? are you sure you are entering the code in the console? are you sure you gave the page enough time to load all the members?

Hey, i am facing the same problem, it worked fine for the first try, but i didn't load all the team members. Upon loading all the members and rerunning tge script, i am getting the same ". undefined" problem.

I'm also receiving "undefined". Followed instructions perfectly.

Me too, I also get the Undefined error. Seems these are all happening recently

this is strange as i use this often and have just tested. Works great with over 1000 members. have tested on 3 devices and works great. Make sure you paste the code in Console.

Switch to the old version of Teams

They are if you scroll down slowly to load all the members before your use the code.

you need to expand the members list and then scroll down to display all 200 members (scroll down slowly so that it loads the profile picture of the members). After you have done this, run the code and it will export all the members.

@@paphitisnThanks for the response, I am indeed scrolling down and loading all the members yet still only getting the channel owners. I'm using a Chrome Browser. Not sure what's causing the issue, but works fine with regular channels. Likely is something locked down on my corporate computer. Great workaround for standard channels!

strange, i have just tested with a private teams channel and it works fine. Have you tried using a different device?

Thank you for your comment. The tip on multiple tabs will definately help others facing issues. It is not a scenario i gave tested so thanks for sharing.

Make sure to expand the members and scroll down so that every member is loaded. Then use the code.

@@paphitisn I did this (so slowly) and still its only giving me the owners and not the members. Surely even if i didnt load all the members, it would have extracted the members on the page that had loaded. But it hasnt. Its just the members. The elements youve used in the code seem to not be attached to the members at all. and just the owners.

@@connorm691000 strange, try using a different device see if it works. I am using the same code i have linked to the video with Chrome and it works without issues.Try a different device and let me know

Make sure that you expand rhe members list and that you scroll all the way down to the last member. It will only export what the browser displays.

make sure you expand to see all the members of the team in Teams and make sure you scroll down to the very last one. While scrolling make sure you see the profile picture of every member load. Once you have done this then go to inspect and run the code in console. If you have many members we have noticed that you need to scroll all the way down to the very last member and then back up again making sure all the members are loaded and you see their profile pictures load. Then run the code. Let mem know how it goes.

You need to expand the members section so that all members are listed before you use the code.

@@paphitisn mine used to work with loading all members, now only spits out the group owners

Make sure to expaned the members so that it loads them all first. Scrill down to see all the members and then use the code.

nope, this script no longer works like it used to@@paphitisn

Sorry no. i am looking in to finding a new way.

switch to the old version of Teams

@@paphitisn using old version only but getting error as unauthorized

It is a fantastic piece of code. Thanks for sharing your hard work. This code has made the lives of many educators easier.

Glad it helped

When you show the list of members in the team, scroll down slowly so that the browser has time to load all the members. When you reach the end scroll back up again slowly to load all members. Then run the code and you will get all the members exported.

@@paphitisn Brilliant - It worked! Thanks for the help

Thanks for you comment

You need to change the delimiter symbol in excel to be a comma , so that it places data after a comma in a new column

@@paphitisn Thank you it worked!

You are welcome. Thanks for you comment.

will only wort with the classic version.

Great to know. Thanks for the comment.

Which tag?

@@paphitisn in the channel list of members there is a field called “tags”

Switch to the old version of Teams

@@paphitisn it is old version :)

@@ulugbektojiboyev3852 that is strange as i have just tested it and it works. Maybe a browser change? make sure you are copying all the code and pasting in console.

But still it did not work

@@paphitisn it is correctly copied, It was a company’s MsTeams, probably some security issues

it does display in separate columns unless i am not understanding your comment. Display name, Title, Location, Role, and UPN in separate columns. See 5:08 of the video

@@paphitisn turns out my excel wasn’t treating commas correctly, all good now :)

@@suviste Excellent! Well done :)

Thanks for your kind words. Ii am glad you find the content useful. 😊

Please see the pinned post. You need to scroll down so that all participants are loaded, if there are many members then scroll back up so that all the members are displayed. Then run the code

@@paphitisn I made sure to do it, more than once, still to no success.

@@paphitisn I have an update - it worked but the data shows in the console it's not automatically exported to Excel. Still, I can copy it to Excel and sort the data there.

@@Lewa59 What browser are you using? Maybe a different browser. I use Chrome

@@paphitisn Also Chrome. Idk what is wrong but thanks anyway - I have what I wanted 🙂

Glad it helped

Nevermind, I did it again and now have all 86 members in the list. Not sure what happened (I did scroll all the way down to the bottom of the list, actually the last person in the Teams list was on the csv file, but the first few were missing).

What happened was that you did not scroll down the list of members so that they all loaded before using the code. The more members you have the more time it takes to load them all. I have exported over 900 members i a team but i had to take time to scroll down to load all members and then scroll to the top again.

When you scroll down make sure you have given it enough time to load all the users. I have used this with a Team that contains over 1000 members and it works great. You need to be able to see the last members profile pic in the list.

Hi there. I'm having the same issue, it suggests I've gotten to the bottom of the list and left lots of loading time but it will only get me 91 lines of 267. Any ideas how to fix this? Amazing video BTW, thanks so much

@@jada8270 Ok try the following. Scroll down so that all members load. Make sure you see that it displays all the profile icons for the users. Once you reach the bottom, scroll back up again slowly so that you again see all the profile pictures of all members. Then go to inspect, console and paste your code. Give it a while and it should produce the spreadsheet with everyone in. The more members you have the longer it will take. i have just tested with 818 members and it works. Scrolling down quickly to the bottom only generated 95 members of the 818. Scrolling back up slowly to see all the profile pics produced a list with all 818 members. Please let us know if this works for you.

@@paphitisn Hi, morning :) Its worked! I'm so happy :) I very slowly scrolled back up to the top ensuring each of the photos loaded fully. Unbelievable, thanks so much for such create tutorials and advice.

@@jada8270 Excellent. thanks for coming back an letting us know. I will pin the instructions in the comments