Right click on download .csv and click “save link as”. Open this text file in excel. Open the file in excel; it might instantly convert it to columns in which you can work.
If not; Press data > Text to Columns
Press delimited and select “comma” as a delimiter.
Open file with... a text editor (i.e. Notepad or Wordpad)
Add a new row on top and add the text "sep=," or "sep=;" depending on whether the seperator is a comma or a semicolumn (don't add the quotation marks)
Save the file
Open file with... Microsoft Excel
Same as method 1.
Press data > New Query > From File > From Text > Select the downloaded file
Wait for the query editor to load
Press close and load.