Alteryx designer Discussions

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

Alteryx Macro Excel Workbook


Hello Community,


Please find my question below. Do you have any solution ?


I have 3 excel workbook with 5 sheets each. I wanted to combine all the excel workbooks using Alteryx macro into one excel workbook.


Can it be done in alteryx ? I f yes how ?


Please find the attached excel workbook below.




Alteryx Certified Partner

Hi @chhamanshu ,


I'm attaching one example that uses a sheet finder macro to get all sheets from all files and a batch macro to open one by one and concatenate all of them into the same file.

There is also a great macro from @MarqueeCrew that does exactly what you are looking for. It is the 'Wildcard XLSX Input'


Let me know if that works for you.


Fernando Vizcaino


Thanks a lot