3 ms·
The problem is Excel's horrible CSV implementation, and opening the file in Excel is one of the main applications of CSV. The German version of Excel expects se
by CodesInChaos 8y ago
The problem is Excel's horrible CSV implementation, and opening the file in Excel is one of the main applications of CSV. The German version of Excel expects semicolon separated CSV, where comma serves are decimal point and the date format must also be German. I found no way to create a CSV file that opens in Excel, regardless of locale. (And there are a million other problems in Excel's CSV implementation)