Combine Multiple Excel Sheets into a Single Table using R Tidyverse

[ikhlashusein]

Hey Jonathan. thank you for your valuable information. Just a quick question; how can i view the new file that combined those datasheets?

[valensrwema]

Hi Jonathan, Thank you for the amazing work, I really appreciate it,
Quick question: How to skip a sheet while combining other sheets together as one data frame?
Thank you

[clerisduchrist]

I really appreciate this video ! The tidyverse is a really powerful tool

[nurseryrhymes]

Thank you for this video. Is there any online link available on how to use data in the dt objects, for example, taking one column from one sheet and adding to another column in another sheet etc etc. Thank you.

[ThePlum]

Hello Jonathan, thank you for the video and keeping it simple. How to do the same exercise with CSV file having data in multiple sheets?

[leesummers]

Thank you so much for making this video. Extremely helpful.

[lorenasalcesdourado]

Thank you Jonathan, very helpful!!
How can I adapt this if one of the Excel Sheets does not have column names?

[NhuNguyen-mrmm]

Thank you for the clip Jonathan. I wish to ask if there is a neat way to combine multiple sheets of an Excel file with sheets of another Excel file? Basically each Excel file has 10 sheets. The sheets within each Excel file has different format, but the 10 sheets of Excel file 1 have the same names and format as the associated 10 sheets of Excel file 2. Essentially each Excel file holds the different types of information of a different country, but the types of information collected are the same for each country. And I have many countries so I'm thinking of using a loop.

[JidduVillarin]

Hey Jonathan, Thanks for the information presented. It's an approach I haven't come across yet and it seems like a nice addition to the toolbox. Is there a variant that pulls all the sheets from multiple files?

[abderrahmankilali]

Thank you Jonathan this is really helpful

[kehindeodubela]

Thanks for the video! Is there a way to include a column in the combined table that shows the sheet where the data came from, or any other identifier? Thanks.

[DudeGuyWho]

Awesome content! Can you help me understand how to download a multi-sheet xlsx workbook from URL into R? It's only two tabs and I do know how to merge the tabs into a single dataframe once downloaded.

[stevemack]

Side question. I've used the XLConnect package because it was the first one I came across and it worked. Is the readxl package objectively superior for some reason? Thanks...

[anamitralayek]

Hi Jonathan thanks for this video. I have two excel sheets and i just want some of the columns from the two sheets, the columns are same in both sheets . How can i make a consolidated excel file in R ?

[parishahid]

Nicely explained the complex thing. Let me know how to export these merged excel file as new excel file.

[janardhanvenkatarama]

Hi Jonathan,
Here you combine all sheets within a xlsx workbook.
Can we do this also with xlsx files which are in a folder but with specifying a certain sheet within these xlsx files (e.g. from all xlsx files in a folder combining sheet number 3)?

[alexcloake]

When I do this, it gives me ‘Error in %|| 0): attempt to apply non function’ what does this mean?
I have updated all packages
Many thanks

[GorArkson]

I already added this to my "codes to remember" list, but the tilde and dot still keeps bothering my curiosity. Can you further explain why I needed the tilde and dot, and what does an anonymous function mean?


btw, I tried experimenting it by removing it and adding it back to find some clues on what it actually returns. But I still did not understand it. Thanks again for the great upload!

[darozo]

Bro thanks, !! very simple explanation and high save of time!

[taranaferdous]

What if some of these sheets have different variable?