Combine multiple tabs with different schema from multiple excel files

[Praneeth1996]

Hi team,

I have 30 excel files. Each excel file can have different number of tabs i.e one excel can have 1 tab and second excel can have 5 tabs. The data is all these tabs might have different format and sturcture.

Is it possible to combine all the tabs in these 30 files into one file with multiple tabs.

If there are 80 tabs combined in all these excel files - I want a output file with 80 different tabs.

Please help.

[Qiu]

@Praneeth1996 
This macro should be a good start.

[Praneeth1996]

@Qiu 

I am getting the below error when I try to open the provided zip file.

Failure to Import \\Desktop\Multi Sheet Import Example 2.yxzp.There was an error opening "\\Desktop\Multi Sheet Import Example 2\Multi Sheet Import Example 2.yxmd":

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using

[Qiu]

@Praneeth1996 
Your alteryx is of old version... 🙄

[atcodedog05]

Hi @Praneeth1996 

Try this guide to downgrade version https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/... 

Hope this helps : )