Comment by ozlikethewizard
2 days ago
this seems like less of an excel problem and more of an issue with an improperly escaped data set though?
2 days ago
this seems like less of an excel problem and more of an issue with an improperly escaped data set though?
No. Excel changes the SEPERATOR when parsing depending on the locale settings. This means a CSV generated or saved with a decimal of . will not be able to be opened by one with a , and vice-versa. This is an Excel issue, as it doesn’t even try to determine or ask which separator to use. Hence why the comment above said you need to use the import wizard and not double click.