combining over 200 excel files of data

I have approximately 200 workbooks of data (individual excel files), which I want to input and then join using a union tool.

Is there a quick way to do a input of multiple excel files rather than individual inputs for each? This is workbooks not sheets within a document, they are individual files.

Thanks for your help in advance.

Preparation

Accepted answers

smoskowitz

Do all the Excel files have the same structure? If so, you could use the dynamic input tool to achieve this.

Seth

All comments

smoskowitz

Do all the Excel files have the same structure? If so, you could use the dynamic input tool to achieve this.

Seth

Kirstyp

Yes they do. I'm hoping to be able to reformat them and join they are slightly unstructured at the moment (I've sent another post).

I haven't used that tool before but I will give it a go. thanks.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703