When opening a CSV file, make Excel recognise it as a CSV file!
Currently when I import data from a CSV file, Excel doesn't recognise that it is CSV even though the file name ends in ".csv"! I have to tell the program that the data file has delimited fields and define the separator as comma for it to import the data correctly. Surely this is basic stuff for a program like Excel?
Tom Stein commented
They ignored the world (and the name of the format) for decades! Why should they change it? Just because every other program does a better job dealing with CSV? Just because the users complain how dumb Excel is?
Btw, if you add the following line as a new first line, Excel can open this non-conforming-CSV with a double-click:
Cas Per commented
Yeah this really baffles me too...