cancel
Showing results for 
Search instead for 
Did you mean: 

combining over 200 excel files of data

SOLVED
Highlighted
Kirstyp
Asteroid

Hi

 

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.

smoskowitz
Asteroid

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

 

Seth

Kirstyp
Asteroid

Hi

 

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.