combine excel files with different numbers of sheets

[sbacalso]

Hi,

Newbie here. 

I have a Multiple excel files that I want to Load using get data (Folder) and Merge/Append them all in to one Table.  but have some challenges.

1. The excel files have different number of sheets and it keeps on adding. 

2. Only the 1st sheet of the excel file have Header Name on it and the rest don't. 

Thank you. 

[GilbertQ]

Hi there

This can be done and should be achieved using the loading using the Folder Option because it should not look at the sheet names.

There are multiple ways to do this, it all depends on what will work for you. It depends on your requirements.

[sbacalso]

@GilbertQThank you so much for your response. 

Is there any tutorial/reference where I can find in our forum regarding this? Thanks

[GilbertQ · Accepted solution]

Hi there

here is a great video by Avi who shows you how to do it

https://www.youtube.com/watch?v=9sfCDCpWTfc