Open CSV-file in Excel

Start with a blank worksheet in Excel. Click on Data (1), Get data (2), From file (3), from text/CSV (4).

Locate the downloaded file on your computer and click "Import". The file will be named "total_marks_and_grade_summary" followed by a number and the date when it was dowloaded.

In the pop-up menu you see an overview of how the data will look after being imported. If you have strange characters, for example if Å,Ä,Ö are not showing correctly, try switching to Unicode (UTF-8) (1) in the File origin menu. When the table looks ok, click on Load (2).

To be able to sort by last name, you must first divide the information in the first column. Highlight the name column, and select the tool Text to Columns (1), available under Data (2).

Choose the option Delimited (1) and then click Next (2).

Click the checkbox Space (1), make sure that the preview is showing last names in a separate column (2), click finish (3)

Click on the little arrow (1) in the last namne column and select Sort A-Z (2).