Allow sorting by column and export to excel in new Teams Admin Center
I like the new interface of the Manage Teams page. Please add sort options on columns (Channels, Members, etc.) and the ability to export to excel.

23 comments
-
Teams User commented
Attached is a screen shot of my work Teams application. In a given team, in the members tab, the user should be able to sort the members alphabetically, and in general any of the other categories but definitely alphabetically for the members. with 100'+ members it's difficult to see if someone is listed.
-
Ashley Lindsay commented
It is the largest nuisance trying to utilize the GUI to sift through our Teams tenancy. I am surprised sorting capabilities were not apart of the ground zero design. We have 3,000 + users and even more telephone numbers to sift through, and each city has too many area codes. To be able to "sort by" location in ascending or descending order would be basic functionality.
How is this post 2 years old with out ANY engagement from Microsoft?
-
Beth commented
I exported my teams finished assignment page to excel. In teams the students last name is sorted first, in alphabetical order with the grade of assignment next to it. Yet it does not translate the same in excel. The list of students is now listed as first name first, and not in alphabetical order. It is very time consuming taking all the steps in excel to merge and then sort while trying not to lose the data. Please Is there something I can do in Teams to avoid this or is there a speedier way to make a list of my students with last name first in alphabetical order with their grades in excel?
-
Gin McMillan commented
sorting by columns is so necessary, and should have been added from the beginning
-
Anonymous commented
It is really so tedious work to find them without sorting when I get 200 students in the class, please add sorting option ASAP. Please.
-
Kris J commented
Ditto - sorting columns (by name, title, location, etc.) would be EXTREMELY helpful and create greater efficiencies.
-
Mark Lonac commented
Echoing what others have said...would be really nice to be able to sort columns in Teams.
-
Bill@UAkron commented
Sorting, especially in an educational setting, seems like a no-brainer. When my school's IT team added members to my class teams, not only did they appear randomly, some were Lastname,Firstname while others were Firstname,Lastname. Not sure how that happened since the official class lists are Lastname,Firstname.
Come on Microsoft! Get with it! -
Doug Marlowe commented
This is not rocket science, All owners and members should have the ability to sort on column headings within the teams interface. I swear, while teams is a great replacement for Skype for Business, it was obviously rushed into service with a beta release. If you want us to crowdsource an issues list, put it in github!
Doug Marlowe, President,
teachITnow, Inc. -
Anonymous commented
Please add alpha sorting by last name.
-
Anonymous commented
We all are liking teams but there should be some small features like when do Manage Teams page. Please add sort options on members name columns Channels, Members, etc.
-
Diana G commented
Please sort by columns and/or add Export to Teams members list.
-
Abir Gharib commented
Allow sorting by column and export to excel in new Teams Admin Center
-
Anonymous commented
Please add sorting by column in the Teams Admin Center! It is very difficult to use as an effective tool once there are more than a handful of teams
-
Andy commented
There has got to be a simple fix here...come on MS Teams Team. I really need to be able to see my team members alphabetically.
-
Mike commented
please add sorting to the teams admin center
-
Nick Manganiello commented
This is insanity that this basic functionality is not there - get yourselves together guys - this is embarassing.
-
Jody Dardis commented
Yes please a sort function is crucial to the admin of the all
-
George Metcalf commented
In 2020, practically every software on the planet has a "sort" function - except Microsoft teams
-
Dean Gross commented
and the ability to adjust the width of the columns,