R write.csv not handling characters like é correctly

Question

When I look at data in R, it has characters like "é" displayed correctly.

I export it to excel using write.csv. When I open the csv file, "é" is displayed as "√©". Is the problem with write.csv or with excel? What can I do to fix it?

Thanks

Answer 1

Try the write_excel_csv() function from the readr package

readr::write_excel_csv(your_dataframe, "file_path")

Answer 2

It's a problem with Excel. Try Importing data instead of Opening the file.

Go to: 'Data' --> 'From Text/CSV' and then select '65001:Unicode (UTF-8)'. That will match the encoding from R.