The purpose of this guide is to highlight the many ways to read and write Excel files from R, and discuss alternatives along the way.
Bad (but easy) approaches
Import Dataset button
In RStudio’s Environment pane there is an ‘Import Dataset’ button. Use this button if you are only ever going to read in the data once and are going to write less than 10 lines of code.