Batch Macros Excel data with different schema.

[Dave]

Hi All

I have a folder with a few hundred excel files. All have 1 tab, with the same tab name, but the Schemas are all over the place. Can you recommend a batch macros that will just pull all the data into a single worksheet?

I have tried a few with no luck.

Regards

Dave

[aatalai]

@Dave do the columns have the same name (different order) or same order (but different names)?

[binuacs · Accepted solution]

@Dave 

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[Dave]

Thank you - I have solved :)