How to use the Convert European CSV to US Format
- 1 Drop the European CSV on the studio, or try the example.
- 2 In the step, leave “The numbers are written as” on detect, or choose European. Pick the target format (US by default).
- 3 Read the notes: columns that cannot be told apart are listed, not guessed.
- 4 Under Export options the delimiter is already a comma. Download.
Two things differ
A file made in the Netherlands, Germany, France or most of Europe differs from a US one in two ways. The fields are separated by a semicolon, because the comma is the decimal mark. And numbers look like 1.234,56 instead of 1,234.56. Software that expects one convention reads the other as nonsense – or worse, as different numbers.
Converted as text, not as numbers
The studio never turns your values into floating-point numbers and back. It reads the digits, the sign and the separators and writes them again in the target format, so 12345678901234567890,123456789 stays exactly that, with no rounding and no scientific notation. Currency and percent signs are kept with their spacing. Negative numbers in parentheses, (1.000,00), become -1,000.00.
When it refuses to guess
1.234 is one thousand two hundred thirty-four in Europe and one point two three four in the US. The studio looks at every value of a column: if another value has a decimal part (12,5) the format is clear; if all values fit both, it warns that the column is ambiguous and leaves it unchanged until you choose the format. Columns that look like identifiers – postcodes, ids, anything with leading zeros – are skipped, and values that are not numbers (n/a, -) are kept as they are.
Limits
Dates are not converted. Swiss (1'234.56) and French/Russian (1 234,56) styles can be read and written too; which convention a country uses is collected in the Unicode CLDR. Excel on a US system opens a comma-delimited file as expected; if the columns still do not split, see fixing the delimiter, and to keep postcodes intact see leading zeros.
Frequently asked questions
Does it round my numbers?
No. Digits are rewritten, not recalculated, so nothing is rounded.
Why was one column not converted?
Either it looks like an identifier (leading zeros, postcodes) or the format is ambiguous. The notes under the step name the column.
Can I go the other way, US to European?
Yes. Choose US as the source format and European as the target, and export with a semicolon.
Last updated: