undefined | Better HN

0 pointsrickdeckard11mo ago0 comments

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...

0 comments

erk__11mo ago

How do you make a comma seperated CSV with numbers with commas in them?

rickdeckardOP11mo ago

A 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...

silisili11mo ago

The standard way is to wrap the field in quotes.

fragmede11mo ago

you don't. use SQLite instead

j / k navigate · click thread line to collapse