Summary

Microsoft Excel and Google Sheets are two of the most popular spreadsheet systems. Being able to interact with data stored in Excel and Google Sheets files directly from R is a superpower!

  • In this chapter we learned how to read data into R from spreadsheets and from Excel with read_excel() from the readxl package and from Google Sheets with read_sheet() from the googlesheets4 package.