So true... opening a CSV in Excel is like playing the lottery. Sometimes it opens fine, sometimes not, it even depends on the character encoding of the CSV and whether you double-click the file, open it or drag it inside Excel. Sometimes you get the "import text file" window where you have to choose the delimiter, sometimes everything gets in a single column, and sometimes you get what you want.