Learning R: 17 Read in multiple excel files in R and combine Data

This video shows you how to read in multiple excel files in R, and then combine the data. The packages readxl and tidyr are used. If you find this video helpful please subscribe to my channel.

[@Dilgazab]

Thanks Mate.. Its 2021 and still helpful !

[@AnalyticoHub]

You're welcome!

[@ericksousa5666]

Dude, great video! I watched others that were longer and way confusing. Yours is very clear and worked combining 77 files into one, with more than 80k obs. Thanks a lot!

[@GauriSharma-m7k]

Very Helpful

[@elainelu4568]

the easiest and clearest tutorial I've ever seen. Thanks!

[@oluwaseyidada3828]

Hey Dude, Great video !! it worked for me, your methodology was simple and on point but plz remember to always increase the volume next time cuz i had to put my volume to 100% before i could hear you.

[@dinhoin]

Nice and clear! Thanks!

[@mariviana.]

thanks a lot, used it for my uni's project

[@Xnko100]

Very helpful! Thanks a lot :)

[@vaibhavborgaonkar7706]

Extra Ordinary, you deserve half of my pay from this week, lol!

[@AnalyticoHub]

Happy to help. Please consider subscribing.

[@imranahmad4840]

Very helpful

[@AnalyticoHub]

Glad you think so!

[@grzegorzpochwatko2596]

hi, very helpful, thanks! BUT for some reason I get a df with just filenames, unless I specify cell range. I see that you specified just the certain sheet,. any idea why?

[@fauzanraeva4806]

i've done it, but this will change my column names, how i change my column names back to the original?

[@user-cg8ey9rv4u]

great，but how i can combine diffrent columns numbers

[@agent1759]

How do you get 4 different tbls with the same name as the file ?

[@biancacosta5374]

I did exactly how you said, but i got only a list of the names of the files. Also I need to merge those files skipping the first 7 rows, how can I do it?

[@AnalyticoHub]

can you post or send me a copy of the script? To skip first 7 rows, you can use the skip = 7 argument in line 15.

[@takla195]

Hi! If u have a minute :D After running my files a list of xlsx files have been shown up properly but lapply runs with a "path does not exist" error. Specificly with one file but it is there :D. I try to find out why is that but you maybe faster than me :D Thx

[@livingwithtrend]

pls answers

[@livingwithtrend]

im getting expected < error

[@AnalyticoHub]

What is the exact error you are getting? Do all files have same number of columns and data types?

[@livingwithtrend]

resolved when i changed file extension from xlsb to xlsx

[@natalialago690]

@@AnalyticoHubI keep getting an error because I have a different number of columns. I then tried using bind_rows instead and I got the error 'Arguments 17 must have names'
Any ideas?

[@AnalyticoHub]

@@natalialago690 What I do is only call the number or columns that I need from all files. see line 16 in the video.