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 recovering biostatistician who takes special delight in eliminating the small agonies of data analysis. She’s part of Hadley’s team, working on R packages and integrating them into fluid workflows. She’s been working in R/S for over 20 years, serves in the leadership of rOpenSci and Forwards, and is an Ordinary Member of the R Foundation. Jenny is an Associate Professor of Statistics (on leave) at the University of British Columbia, where she created the course STAT 545.

Follow on Twitter Visit Website More Content by Jenny Bryan

No Previous Videos

Next Video
The Grammar and Graphics of Data Science
The Grammar and Graphics of Data Science

Data science is the process of turning data into understanding and actionable insight. Two key data science...