Data. Hämta data, från fil, från text/csv

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.
Välj Unicode UTF-8 och kommavgränsning

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).

Text till kolumner - verktyg

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).

Avgränsade fält - meny

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

Blanksteg- slutför

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

Kolumn sorterad på efternamn

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