readxl package

Import .xlsx files with readxl in R

The readxl package is a member of the tidyverse. It provides excellent tools for importing and exporting data from both .xls and .xlsx files.

One of the key benefits of the read_excel function is that it will not automatically convert any strings or characters into factor.

library("tidyverse")
library("readxl")

info <- read_excel("data-raw/transit-data.xlsx",
                   sheet = "info",
                   range = cell_cols("B:C")) #choose columns to import

write_csv(info, path = "data/timeperiods.csv")

transport_data <- read_excel("data-raw/transit-data.xlsx",
                             sheet = "transport data",
                             skip = 1) # skips rows to import

colnames(transport_data) <- make.names(colnames(transport_data)) # replace space in column names with a full stop.

colnames(transport_data)