Forum Discussion
Teams
Hi all - not sure where to post this. I love Teams - using it for assignments and grades is excellent. What I don't like is the way the grades are formatted when opened in excel. I want to have the student name down the left of the xcel spreadsheet and the task across the top. I wonder if the Team at Teams could sort this for me.
1 Reply
hi basnettj here you go..I understand what you mean about the Excel export format from Teams assignments. By default, the export lists data vertically (one assignment per row), which can be hard to read when you’re tracking multiple students.
At the moment, Teams doesn’t offer a built-in option to change that layout directly, but there’s a quick workaround:
Once you’ve opened the Excel file, you can use PivotTable or Excel’s “Transpose” feature (Copy → Paste Special → Transpose) to flip the data so that students appear in rows and assignments across columns.
Alternatively, you can use Power Query in Excel to reshape the data automatically each time you export.
It’s also worth posting this idea to the https://feedbackportal.microsoft.com/feedback
under the Education section — that’s where the product team reviews feature suggestions like this.
Hope that helps a bit until an update makes the export format more flexible!
