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 :(
Not sure why this isn't a base functionality in MS Teams but GREATLY APPRECIATED!!! Trying to manage large channels, especially Shared Channels that have several hundred people, getting a list of members is critical to managing the channel over time. THANK YOU! And thanks to the person who developed the code!
@@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.
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.
If you have a Team or Channel with many members you may find that not all the members are exported. To make sure all the members are exported, when you go to the members, 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 will produce the spreadsheet with everyone in. The more members you have the longer it will take.
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
Excellent - but I have the same issue as a few below. I just get the owners of the team even if scrolled down... Do I need to change some values in the code?
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've done all the steps to expand and slowly scroll and load all members, but it's still only giving me the Onwers and none of the members. Has anyone else figured out this problem? Thanks!
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.
Any solution for those of us who are getting 'undefined' when we run the code. I'm working in Chrome and have tried both classic teams and new teams but the process continues to produce no results. 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.
Hello Nicos, my work computer can only see "Copy Ctrl+C" when I right click on the Teams member list screen... what should I do to make it work on my work PC?
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.
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.
Unfortunately when I click “inspect “ nothing happens , idk if it’s because of certain rules my organization has in place or if there is a work around ?
Hi I cannot get this to work, it does not allow me to right click on the page to execute the code, what am I doing wrong? I also tried to open teams on a new webpage I also tried it on Edge and Google?
Is anyone having issues with this method on Shared Channels? We have a shared channel with ~200 people and for some reason it's only downloading the OWNERS of the shared channel, as opposed to the 200 members that I'm trying to email. I have scrolled down to the bottom of the page to load the members so they're visible. Any ideas on how to adjust?
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!
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.
Can we download the list of items/files saved in teams channel. For example my task is to save 5 files daily to teams folder, on last day of month I need to do completeness to see if all files are there which is manual tedious task. Is there a code or so to check and export in excel
Hello Nicos, this looks great and I followed through every step exactly according to the turorial. However, I get an empty Excel sheet (except for the headers) and the final line in the console says: 0 participants exported: Display Name, UPN what could be the issue here?
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.
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
Hello! Thank you for this wonderful tool. The hiccup that I came across was that only 26 members out of 256 got exported to the file (4 Owners, 4 Members, 16 Guests). Any thoughts on why this might have occurred and what I can do to get the rest included?
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.
Thank you very much for the video, it worked almost perfectly. Unfortunately the display name, title, etc. are not in seperate columns in the csv or xlsx. May you help me?
I scrolled down slowly to load all of the names, then tried the code and it only exported the 7 owners and missed the 250 members. Any idea why and if I can solve it?
@@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
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
hi thanks for your tutorial. but this is working only for owners and not for the users maybe you can check again? thanks! and im usinh the old version of teams in browser!
Hello Nicos, I made sure to follow all the steps from your video but the exported report is empty. Under the copied code I see information: 0 participants exported. Any idea where the problem is?
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 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.
thank you i follow your advice to scroll down until the end but the final report only export me 100 lines and I have more users...do you know how can i resolve that? Thank you in advance
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.
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.
@@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.
Microsoft is such a crap company. How difficult can it be to have an 'Export Team Members' menu item in the hamburger menu? 1000s of other collaborative tools have this since ages. No, they come up with stupid beta tools like Copilot or that horrible Hololens instead of listening to their users. These guys really suck, letting us dabble around with scripts etc.
![Split a Mail Merged document into SEPARATE documents with custom file names [No Coding]](http://i.ytimg.com/vi/MsUpz6docZA/mqdefault.jpg)
![Megan Thee Stallion - Bigger In Texas [Official Video]](http://i.ytimg.com/vi/QxTkZTLWdo4/mqdefault.jpg)
![Quando Rondo - Life Goes On [Official Music Video]](http://i.ytimg.com/vi/eIf3fhMXAow/mqdefault.jpg)
Please note that to make this work you need switch to the old version of Teams.
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 :(
@@adele8408 if you click on the 3 dots next to your initials you should see the New Teams switch... (at least that was the case for me)
Not sure why this isn't a base functionality in MS Teams but GREATLY APPRECIATED!!! Trying to manage large channels, especially Shared Channels that have several hundred people, getting a list of members is critical to managing the channel over time. THANK YOU! And thanks to the person who developed the code!
SO true. Thanks for your comment and of course a big thanks to Guillaume Meyer for the code.
It does. It is located in the 3 dots in top right.
I am working on a new code for the new version of Teams.
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.
This is bananas! It works!
Just take note that it will not work if the browser has multiple tabs.
The teams page needs to be on its own.
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.
If you have a Team or Channel with many members you may find that not all the members are exported. To make sure all the members are exported, when you go to the members, 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 will produce the spreadsheet with everyone in. The more members you have the longer it will take.
Unfortunately it’s not working for me. Not sure why though. I followed the exact steps and facing a response “undefined”
In Edge I got the "undefined" response but it seems to work in Chrome
Amazing! The code definitely works!
I spent two hours looking at useless solutions...😵💫
You are the best Nicos!
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
Nicos! Always bringing us great content!
Thanks for your kind words. Ii am glad you find the content useful. 😊
Thank you for this. It has saved me a lot of grief. I will be sharing with my colleagues and subscribing
Glad it helped
Oh my... just discovered this video! Thanks for the mention Nicos!
It is a fantastic piece of code. Thanks for sharing your hard work. This code has made the lives of many educators easier.
Also following steps exactly, but after pressing enter, I get undefined and it doesn't create the file in my Download folder.
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
Excellent - but I have the same issue as a few below. I just get the owners of the team even if scrolled down... Do I need to change some values in the code?
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.
This is very useful - thank you for this help 🙂
You are welcome. Thanks for you comment.
Awesome!! Thanks! Worked pretty well.
Great to know. Thanks for the comment.
I've done all the steps to expand and slowly scroll and load all members, but it's still only giving me the Onwers and none of the members. Has anyone else figured out this problem? Thanks!
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.
Thank you. The code works.
Thanks so much - very useful!
Thanks for you comment
Any solution for those of us who are getting 'undefined' when we run the code. I'm working in Chrome and have tried both classic teams and new teams but the process continues to produce no results. 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.
Any idea why this could not be working? I paste the code and then nothing happens.
Switch to the old wrsion of Teams.
Awesome. Thank you!
Beautiful! Saved me a ton of time!
Glad it helped
Hello Nicos, my work computer can only see "Copy Ctrl+C" when I right click on the Teams member list screen... what should I do to make it work on my work PC?
Press F12 key on the keyboard
Hi! When i put he code (following the steps) and click enter, it responds with the message: "undefined", how can I fix this issue?
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.
Unfortunately when I click “inspect “ nothing happens , idk if it’s because of certain rules my organization has in place or if there is a work around ?
Switch to the old version of Teams
Brilliant! Cheers!
Hi I cannot get this to work, it does not allow me to right click on the page to execute the code, what am I doing wrong? I also tried to open teams on a new webpage I also tried it on Edge and Google?
There have been modifications in the new version of Teams. This will only work if you load the old version of Teams.
Is anyone having issues with this method on Shared Channels? We have a shared channel with ~200 people and for some reason it's only downloading the OWNERS of the shared channel, as opposed to the 200 members that I'm trying to email. I have scrolled down to the bottom of the page to load the members so they're visible. Any ideas on how to adjust?
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?
It works but only for download the owner , the members and guest section is being skipped. wondering if any modification to the script is required ?
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
restarted laptop, tried keeping only one tab open, still getting only owners. If anyone solved the problem, please reply, Thanks!
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!
Can we download the list of items/files saved in teams channel. For example my task is to save 5 files daily to teams folder, on last day of month I need to do completeness to see if all files are there which is manual tedious task. Is there a code or so to check and export in excel
Excelente video y muy util, sería genial ver uno para los contactos en microsoft 365
Hello Nicos, this looks great and I followed through every step exactly according to the turorial. However, I get an empty Excel sheet (except for the headers) and the final line in the console says:
0 participants exported:
Display Name, UPN
what could be the issue here?
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.
This didn't worked for me, however i followed the same step, CAn you please help? Getting undefined
switch to the old version of Teams
@@paphitisn using old version only but getting error as unauthorized
with new version of team , we can only export owners and not members. Need updated script
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
It doesn't work well if list of Teams members is long, like couple of hundreds. Not all the entries are copied.
They are if you scroll down slowly to load all the members before your use the code.
Thank you for sharing this. I`m following the steps, however it only downloads the owners of the Teams. Did I miss anything?
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.
I followed the steps and it is showing undefined...my web version is "microsoft teams classic", will it be the issue?
Hello! Thank you for this wonderful tool. The hiccup that I came across was that only 26 members out of 256 got exported to the file (4 Owners, 4 Members, 16 Guests). Any thoughts on why this might have occurred and what I can do to get the rest included?
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
Thank you very much for the video, it worked almost perfectly. Unfortunately the display name, title, etc. are not in seperate columns in the csv or xlsx. May you help me?
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!
I scrolled down slowly to load all of the names, then tried the code and it only exported the 7 owners and missed the 250 members. Any idea why and if I can solve it?
Anyone has an update to this on the new Teams and updated Chrome browser? Nicos' step no longer works =(
Hi, this code is working for me, but its only giving me the owners and not any of the members. Is there anything i can do to help this?
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
Thank you, Nicos, Which Language is this code developed? I need to customize this code for my internal purpose...
Could we somehow change the code so that it shows the information not in one column but in separate columns?
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 :)
hi thanks for your tutorial. but this is working only for owners and not for the users maybe you can check again? thanks! and im usinh the old version of teams in browser!
Hello Nicos, I made sure to follow all the steps from your video but the exported report is empty. Under the copied code I see information: 0 participants exported. Any idea where the problem is?
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 🙂
Just seen this and it's awesome! is there a way to include the tag?
Which tag?
@@paphitisn in the channel list of members there is a field called “tags”
Do you have a solution for the new Teams? The code does not work for the new Teams interface.
Sorry no. i am looking in to finding a new way.
Can we export files from Teams going to Excel
life saver
thank you i follow your advice to scroll down until the end but the final report only export me 100 lines and I have more users...do you know how can i resolve that? Thank you in advance
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
When I use this process, I only get 60 names of the 86 members of the team. Any thoughts?
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.
Awesome, thanks a lot. Unfortunately, it does not support Arabic names.
Not working for MS Teams v2
will only wort with the classic version.
gives me undefined as a result :(
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
Microsoft is such a crap company. How difficult can it be to have an 'Export Team Members' menu item in the hamburger menu? 1000s of other collaborative tools have this since ages. No, they come up with stupid beta tools like Copilot or that horrible Hololens instead of listening to their users. These guys really suck, letting us dabble around with scripts etc.
could not agree more.
Wow, you have to run third party code for this. What a crap tool.