What's new with readxl? A Tidyverse solution for reading data stored in xls or xlsx format

May 10, 2017 Jenny Bryan

Like it or not, spreadsheets are a common data source for many of us. We’ll review the overall landscape for importing spreadsheet data into R and then go into detail for the readxl package specifically. readxl is the Tidyverse solution for reading data stored in the legacy xls format or the more modern xlsx format. It has no tricky external dependencies, is quite speedy, and is easy to install and use across all operating systems.

Download Materials

About the Author

Jenny Bryan

Jenny is a software engineer on the tidyverse team. She is a recovering biostatistician who takes special delight in eliminating the small agonies of data analysis. Jenny is known for smoothing the interfaces between R and spreadsheets, web APIs, and Git/GitHub. She’s been working in R/S for over 20 years and is a member of the R Foundation. She also serves in the leadership of rOpenSci and Forwards and is an adjunct professor at the University of British Columbia.

Follow on Twitter Visit Website More Content by Jenny Bryan
Previous Flipbook
RStudio IDE Cheat Sheet
RStudio IDE Cheat Sheet

No matter what you do with R, the RStudio IDE can help you do it faster. This cheat sheet will guide you th...

Next Video
Introducing blogdown, a new R package to make blogs and websites with R Markdown
Introducing blogdown, a new R package to make blogs and websites with R Markdown

The most typical use of R Markdown is to create a single output document from a source document, and there ...