readxl
Read excel files (.xls and .xlsx) into R
The readxl package imports Excel data into R, supporting both .xls and .xlsx formats. It reads tabular data from Excel files without requiring external dependencies like Java or Perl, making it easy to install across all operating systems.
The package automatically handles common Excel quirks like date specifications (Windows 1900 and Mac 1904), re-encodes non-ASCII characters to UTF-8, and detects the minimal data rectangle to import. Users can control which cells to read through flexible range specification, skip rows, limit the number of rows read, and customize column names and types. Returns are tibbles for better integration with tidyverse workflows.
Contributors#
Resources featuring readxl#
What’s New With Readxl | RStudio Webinar - 2017
This is a recording of an RStudio webinar. You can subscribe to receive invitations to future webinars at https://www.rstudio.com/resources/webinars/ . We try to host a couple each month with the goal of furthering the R community’s understanding of R and RStudio’s capabilities.
We are always interested in receiving feedback, so please don’t hesitate to comment or reach out with a personal message
