Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Read files from the folder and consolidate into one Excel

8 - Asteroid

Hi Guys ,

I am facing problem in creating a macro to read all the excels with multiple tabs from the folder and consolidate in one.


I am attaching sample data . These excels have multiple tabs which may vary (some excel have 1 tab, some have 2 tabs, some have 5 etc). i have 100 plus such files. and i need to read all the files from the folder and consolidate all the data in single excel .

Please help me with it.

Much help will be appreciated


Thank you  

Inactive User
Not applicable

CreW Macro Pack - download that. Then use the Dynamic XLSX Input. This will bring all sheets and files together and union them together.

8 - Asteroid

Excels files i am having have multiple tabs and also the schema is not same . Can Dynamic XLSX still work?