Question: how to import an excel file in rstudio?
Answer: 1 Saving the data in the right format. Generelly, finding the right format to import Excel can be tricky. ... 
2 Saving the data in your working directory. To function properly, you have to set a working directory for RStudio first. ... 
3 Loading the data. To import the data, simply click on the file in the bottom-right pane.