how to import multiple excel files with multiple sheets and with difference schema

[Niks_diageo]

hey Guys,

i have one scenario here which talk about Multiple excel (.xlsx) files, with multiple excel tabs/sheets and has different schema. i want to consolidate into one file. PFA is the sample data.

Need you help to crack this. i have tried all possible combinations but it is not happening..

looking forward to your support..

thank you in advance.

Regards,

Nikhil Panchal

[flying008]

Hi, @Niks_diageo 

Maybe you can use the batch macro in gallery to input N .xlsx file, then filter the rows as your want.                        Batch Macro  for you.

[Niks_diageo]

Could you please help me sharing macro based on the this scenario.. i have used the features mentioned in the link but it didn't work

[flying008]

Sorry, due to security policy restrictions, I am unable to upload any .yx* files here. Please try it again

[Qiu · Accepted solution]

@Niks_diageo 
We can use the macro in the Gallery to import the files as below.