How can I combine excel sheets in different excel workbooks that have the same schema?

[ytorjim8]

I have around 16 excel workbooks that each contain 1 sheet with the same schema and I need to combine all the rows in these sheets into one workbook, what is the best solution for this?

[Raj]

Use dynamic input tool to do so
you can refer to the example attached to the tool as well

[Qiu]

@ytorjim8 
Maybe you can also try ths macro.

https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750

[grazitti_sapna]

Hi @ytorjim8 

First you would need to make sure the excel files are named in identical structure, for example-:

File Name 1 - Book1.xlsx contains first two records
File Name 2 - Book2.xlsx contains other two records
\Book*.xlsx (for eg)

Please review attached file. If it helps please accept it as solution.
Thanks 

[wsalaz01]

Hello Sapna,

Very helpful!  I have several excel files over 10Millions rows in 100+ excel files that I was able to read data among all of them in matter of minutes!!

thank you so much for the tip using dynamic input tool.

wil