how to appropriately export datasets from R studio in an appropriate style?

Question

[Mozart]

Hello there, I really need to export my dataset in excel for a submission. I tried with "write.csv" but unfortunately all the columns turn to be merged in one, when I open the file in excel; I don't know why this is happening. It also seems that numbers change a bit? is it possible? for example in R a value has 1.237598e+01 and when I export in excel it changes in 1,2376E+12?

can you suggest a definitive way to export a simple dataset in order to avoid to further fix it on excel, please? I really tried my best to look online for troubleshooting but unfortunately I was not able to do that.

Thanks in advance.

[zx8754]

Try to open the file using plain text editor like Notepad++.

Answer 1

[lokraj2003]

Maybe you can export into Excel format (.xlsx) instead of .csv format. You can use xlsx package to export the data into excel format.