Export a list of all Teams members as a CSV file

Learn how to generate a list of all Teams members from any type of Microsoft Team. The list will include Display name and email address. Use the list to email all members of a Team, Mail Merge or simply use it to generate a spreadsheet or class list.

Access the code used here:

Tutorial on emailing all members of a Class Team:

Credit to Guillaume Meyer, the creator of the code used in this tutorial:

[paphitisn]

Please note that to make this work you need switch to the old version of Teams.

[rodneyandrews]

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!

[nrqydpn]

Amazing! The code definitely works!
I spent two hours looking at useless solutions...😵‍💫
You are the best Nicos!

[elizabethsimpson]

Nicos! Always bringing us great content!

[chrisabrey]

Thank you for this. It has saved me a lot of grief. I will be sharing with my colleagues and subscribing

[guillaumemeyer]

Oh my... just discovered this video! Thanks for the mention Nicos!

[mdhidayat]

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.

[catlovers]

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

[mattdavies]

This is very useful - thank you for this help 🙂

[paphitisn]

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.

[ismaileducation]

Thank you, Nicos, Which Language is this code developed? I need to customize this code for my internal purpose...

[gdzyzmh]

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?

[paphitisn]

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.

[rsperry]

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?

[manssorensen]

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?

[purinyo]

I followed the steps and it is showing undefined...my web version is "microsoft teams classic", will it be the issue?

[missoftenchang]

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?

[sfvn]

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?

[schnapsii]

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!

[johncasino-ygvc]

Can we export files from Teams going to Excel