Hacker News new | ask | show | jobs
by erk__ 437 days ago
How do you make a comma seperated CSV with numbers with commas in them?
3 comments

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

The standard way is to wrap the field in quotes.
you don't. use SQLite instead