Downloading data from Kaggle to Excel

[Mas_Peter]

I downloaded this dataset but when i open it in excel the format of some data are not match with the original dataset. How can I fix this error? I am living in Vietnam if it helps.

 

[vletm]

Mas_Peter​

You wrote ... the format of some data are not match with the original dataset
and next You asked ... How can I fix this error?
Do You mean those some different letters or what?
... have You tried to use other font ... which has those letters?

 

[Mas_Peter]

Sorry for my explanation. I've applied some other fonts but it doesn't help. Those letters seem just appeared randomly. Here's the link to the kaggle dataset : https://www.kaggle.com/datasets/yag...aset-for-cleaning-exploring?resource=download.

When i download and open it those letters show up.

 

[GraH - Guido]

You might want to import the data in excel, using utf8 standard. Those weird letters ad you call them are accented letters, like é, â, ç, etc. Or if they are in the source, they are exported incorrectly.

 

[Mas_Peter]

Thank you very much ! I fixed it.