CSV number format fixer — European to US
In Europe 1.234,56 means one thousand two hundred thirty-four point fifty-six. In the US it means 1,234.56. We spot the European pattern across a whole column and rewrite it to the international format — the one every database actually accepts.
Number format fixed
Before
1.234,56 9.876,54
After
1234.56 9876.54
Drop your CSV file here
or click to browse
The "number format" fix will be auto-detected.
What is this and why does it matter?
Number formatting varies by locale. In Germany, France, and much of Europe, 1.234,56 means one thousand two hundred thirty-four point fifty-six. In the US and UK, the same number is written 1,234.56. When European CSVs are imported into US-locale tools, numbers are misinterpreted.
CSV First Aid detects columns with European-format numbers by scanning for the pattern: digits, dots as thousands separators, and a comma before the decimal digits. It converts them to the international format while preserving non-numeric text.
The detection is conservative: a value like '1,5' could be European 1.5 or a comma-separated pair. The tool only converts when the pattern is unambiguous across the column.
How it works
- 1Drop your CSV. The detector scans each column for European number patterns.
- 2Affected columns are flagged with the count of cells to convert.
- 3Apply the fix — dots (thousands separator) are removed, commas become decimal points. Download.
FAQ
Will this break currency values like €1.234,56?
Currency symbols and text around numbers are preserved. Only the numeric formatting changes: €1.234,56 becomes €1234.56.
What about Swiss format (1'234.56)?
Currently we handle the dot-thousands/comma-decimal European format. Swiss apostrophe thousands separators are not yet detected, but planned.
Can I convert US to European format?
Currently the tool converts European → US/international only. This covers the most common pain point (importing European data into US tools).
Related tools
CSV date normalizer
One column with 01/03/2024, 2024-03-01, and 'March 1, 2024' mixed together is a column that can't be sorted. We rewrite everything to YYYY-MM-DD — unambiguous, sortable, safe for every database.
CSV whitespace trimmer
A single trailing space is why your VLOOKUP misses, why two rows look like duplicates but aren't, why the join silently loses half the records. One pass trims every cell — matches start working again.
CSV delimiter fixer
European exports use semicolons. Database dumps use tabs or pipes. Your import expects commas. We sniff out what the file actually uses and rewrite it to what your tool wants — comma, semicolon, tab, or pipe.