Consolidate data from multiple excel sheets (Multiple Tabs, Inconsistent columns)

Question

Hello Community,

I am looking for a macro (prepared and shared by someone from Alteryx community), where I can consolidate data from multiple excel sheets(Multiple Tabs, Inconsistent columns). This was available in the gallery few years back but I can't find it now. So, please help me! Any new similar macro you found in the gallery would also work.

Thanks!

Hammad

atcodedog05 · Answer

Hi @Hammad23

Try this article

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

Hope this helps : )

mceleavey · Answer

Hi @Hammad23 ,

Obviously if you have inconsistent columns you will need to do a manual mapping exercise, but I've attached the tools I published a while back to the gallery.

I've also attached an example of how they work.

I hope this helps,

M

Multi Sheet Import Example 2.yxzp

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

Qiu · Answer

@Hammad23 
This is my collection as well.

Multi Sheet Import Example 2.yxzp