Teams Attendance Sorter

Copy the exported attendance list from a Teams lesson into the A column of this spreadsheet and press Sort Attendance. It will get rid of repeated names, separate first and last names, and sort the list in alphabetical order. For me, this has made doing attendance from a Teams meeting substantially quicker.

You will need to enable macros to make this spreadsheet work and names may not be in perfect order if the pupil does not have a First Name Last Name naming structure.