You can select the separator when opening the file in LibreOffice Calc (don't have Excel on this machine but I know it's possible as well). Setting it to ";" fi

You can select the separator when opening the file in LibreOffice Calc (don't have Excel on this machine but I know it's possible as well). Setting it to ";" fixes this for all European data sets I have worked with that use "," where "." would be used in the U.S. You can also specify the separator in pretty much every other tool that imports CSV (for example in R).