Input Multiple excel files

[Tym868]

Hey everyone,

I'm having trouble importing and cleaning multiple excel files with multiple sheets. The sheets have different templates and the data set is relatively large. I made a macro but it only works with 1 of the sheets. I also used the directory tool but it only pulls up the file name. Can someone help me, please?

[afv2688]

Hello @Tym868,

are you working with xls or xlsx files?

Regards

[Tym868]

Hey, 

I'm using xlsx files 

[Qiu]

@Tym868 

You shouldl try the CReW Wildcard xlsx input macro. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combining-Different-Sheets-with-Differ...

[afv2688 · Accepted solution]

Hello @Tym868 ,

Try this macro and let me know your thoghts.

Regards

[Tym868]

Hey,

That's the same steps I did and only the sheet names and file came up. Not sure where I went wrong. 

[afv2688]

Hello @Tym868 ,

Without taking a look at your macro I won't be able to know. Maybe if you share it I can take a look at it.

Regards

[Tym868]

I got through. Thank you so much.