Swiss and European number formats: 1'234.50 and 1.234,50 to plain numbers

Switzerland groups thousands with an apostrophe (1'234.50); Germany, Italy and much of Europe group with a dot and write the decimals after a comma (1.234,50). Read with the wrong convention, 1.234,50 becomes 1.23 or text, and a sum is silently wrong.

Column type: NUMBER

In the fileCleanedStatus
1'234.501234.50clean
12'00012000clean
980.25980.25clean
1'000'000.751000000.75clean
45.0045.00clean

Column type: NUMBER

In the fileCleanedStatus
1.234,501234.50clean
12.000,0012000.00clean
980,25980.25clean
1.000.000,751000000.75clean
45,0045.00clean

What happened

The separators are read from the column: which character groups the thousands and which one starts the decimals. Every cell comes back as a plain number with a dot for the decimals and no grouping, ready to sum.

Do it yourself

curl -X POST https://data-cleaner.com/clean/v1/column \
  -H 'Content-Type: application/json' \
  -d '{"values": ["1'\''234.50", "12'\''000", "980.25", "1'\''000'\''000.75", "45.00"]}'

The answers above are the API's own, captured when this page was built.

More guides