Messy data on Excel

It looks like you have your operating system set to use a French localisation. This likely regards a comma as a decimal point, which stops it being able to be interpreted as a separator between values.

It might be possible to specify that commas should be used to separate cells during your import wizard in Excel. Otherwise, try googling for how to change this setting at an Excel or operating system level.

From within Excel, you can fix this manually by selecting the first column and then click the “Text to columns” button on the “Data” ribbon (or under the Data menu on a Mac), and specify that the delimiter is a comma.

It also looks like Excel is ignoring the UTF-8 Unicode text encoding of your file, leading to gibberish in non-ASCII characters. Try something like this to fix: https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

1 Like