But on European Windows versions this character is reserved as the Decimal Symbol and the 'List Separator' is set by default to the semicolon:.On American Windows versions, the comma is set as default for the 'List Separator', which is okay for CSV files.The standard field delimiters for CSV files are commas: ,.When opening standard CSV (Comma Separated Values) files in Excel you may find that Excel did not recognize the fields and simply displays all data in the first column. Trouble With Opening CSV Files With Excel? The Comma and Semicolon Issue in Excel Due to Regional Settings for Europe
