Reading and loading multiple Excel sheets in R

Question

I want to read and load an Excel file into my environment, I'm just getting a list.

path <- "data/data.xlsx"

path %>% 
  excel_sheets() %>% 
  set_names() %>% 
  map(read_excel, path = path)

Are you trying to read multiple files into R or just a single one? From the last line in your code it is a bit unclear which? — Harvey Ellis
– Harvey Ellis, Commented Mar 7, 2019 at 21:18

Raul Guerrero · Accepted Answer · 2019-03-07 21:48:53Z

2

You could try: For this example i made a xlsx with 3 sheets.

library(readxl)
# Get the sheets count
sheets <- excel_sheets("some.xlsx")

for (i in 1 : length(sheets)) {

 shts <- paste("x", i, sep = ".")
 # Read every single sheet and assign to variable x1, x2, x3 etc...
 assign(shts, read_excel("c:/Temporal/TEST.xlsx", sheet=sheets[i]))
}

Result:

I hope this helps!

answered Mar 7, 2019 at 21:48

Raul Guerrero

4083 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matt Simonson Over a year ago

This works great for loading multiple sheets but is there an easy way to add the sheet name to the dataframe?

Collectives™ on Stack Overflow

Reading and loading multiple Excel sheets in R

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related