The default setting for exports of CSV files (grades, enrollment lists, quiz statistics etc.) is made to fit other locales that Swedish. That means that when you open the files in Excel it won't recognize some characters (like Å, Ä, Ö) or column separation. To fix this you can turn on two different settings from Account, Settings and then scroll down to the bottom.

Screenshot of settings to fix CSV file exports for Excel.

Both these settings should be turned on for you to be able to open them in Excel with ease. The Byte-Order Mark fixes the characters and the semicolons fixes the columns. These settings can be turned on and off at any time and only affects the exports you make yourself.

Does the issue remain?

If the same issue(s) remain after checking the settings above, you can manually import the data into Excel using the following steps.

Open a new spreadsheet in Excel.
Switch to the Data tab.
Click From Text/CSV.
Select the CSV file you just downloaded from Canvas.
Switch the file origin to 65001: Unicode (UTF-8).
Confirm that the delimiter value is Comma.
Click Load.

Screenshots showing the steps to import a CSV file into Excel. You should now have your data correctly displayed and formatted as a table.