How to correctly export a table from R to Excel?

Question

R

There was a problem when exporting a table from R. For some reason, all the data is written in one line (the data is not split into columns, as it should be). At the same time, using View(), the table is displayed in the correct form. I save the table to a csv file using the function

write.table(res.tab, file="/Users/.../result.txt", fileEncoding='UTF-8', dec = ",", sep = "\t")

This is how the table is shown using View()

And this is how when opening a csv file in Excel (all data is written in one line, not split into columns)

Answer 1

Select the first column in its entirety, go to the "Data" section, then click the "Text to Columns" function. In the pop-up window, click "With separator", and then select the tab separator.