This is a test version of Biostars. For the public version, visit https://www.biostars.org.
how to appropriately export datasets from R studio in an appropriate style?

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.

r excel
• 2,082 views • link
updated by lokraj2003 lokraj2003 • written by Mozart Mozart

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

• 0 views • link
written by zx8754 zx8754

1 answer

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

• 0 views • link
written by lokraj2003 lokraj2003

Log in to answer this question.

More posts like this