Canvas Exporting – Group Set Data

Currently Canvas does not have the ability for teaching staff to export student group lists to a .csv spreadsheet OR have groups listed in one of the spreadsheet column.  You can find students who aren’t assigned to a group, but not those who are without using the dropdowns and searching each group.
A very clever Canvas user has come up with a fix on the Canvas Community for this issue by creating an Excel spreadsheet which can read data from Canvas.  Please make sure you read the notes at the bottom of the Canvas Community post before attempting this fix.

Screen Dump of Spreadsheet
Source: Jaap Stelpstra, Canvas Community, https://community.canvaslms.com/docs/DOC-11862-download-and-create-report-of-course-group-sets-groups-and-members

Thanks to Jeff Hughes, School of Science for sharing this information.