24 ms·
If it provides any comfort, Excel in turn is unable to properly open/save a CSV with the separator being a comma (!) unless the regional settings of Windows are
by rickdeckard 2y ago
If it provides any comfort, Excel in turn is unable to properly open/save a CSV with the separator being a comma (!) unless the regional settings of Windows are not defining it as such.
On german systems it's for example a semicolon, so a CSV is basically a "semicolon separated value" file, and there is no working solution around that...
- erk__ 2y agoHow do you make a comma seperated CSV with numbers with commas in them?
- fragmede 2y agoyou don't. use SQLite instead
- rickdeckard 2y agoA comma separated CSV with decimal numbers uses a dot as a decimal point (US regional setting) A German CSV uses a semicolon as a separator and a comma as a decimal point (German regional setting) To create a US-style CSV on a German PC (with expectation to create a common CSV format) you need to change the regional setting of Windows before opening Excel...
- silisili 2y agoThe standard way is to wrap the field in quotes.