MULTIPLE EXCEL IN ONE EXCEL

Question

HI All,

I have atleast more than 15 excel files and I have to merge all the excel files in one excel files with different tabs of name (15 excel files name) and delete all the previous 15 excel files and have only the resultant one excel file.

Please suggest some solution for this.

Thankyou

Assaf_m · Answer

Have you tried the wildcard xlsx input tool in the crew macros?

if not, check the below link

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740

mceleavey · Answer

Hi @vijaylnyadav ,

I've written some macros I use all the time for this.

I've attached the workflow example and the macros.

I hope this helps.

M.

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema xlsx.yxmc

Multi Sheet Import Example.yxmd