Earlier quoted context omitted.
Reall? Libreoffice at least has a File > Open menu that allows you to specify the separator and other CSV stuff, like the quote character
You have to be inside Excel and use the data import tools. You cannot double click to open, it outs everything in one cell…
The day I found that Intellij has a built in CSV tabular editor and viewer was the best day.