Importing multiple excel workbooks having multiple sheets

[Govind_Dileep_G]

Hi,

I have around 20 excel workbooks with each one having 4 sheets in them. The schema is same for all. I need to load all these excel workbooks at once in Alteryx so that I get all the data in a single excel workbook having only 4 sheets. I tried the wildcard function but it will require me to take 4 input data tool for getting the 4 sheets. So. I am looking for some other way. Is there anyway? It would really help me a lot if anyone can give any info regarding this

[apathetichell]

put them in a standalone directory on your computer and use a directory tool... Then try this nifty macro that I have - sending the full path in... (fixed to include .yxzp version)

[rkapoor · Accepted solution]

@Govind_Dileep_G I think this macro will help you to read in the data in one go.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynami...

[apathetichell]

@rkapoorIf you get a chance  can you testdrive my batchs? Trying to get feedback if they work as desired and are therefore gallery-worthy. Hypothetically they should take in an .xlsx or .xls file in a directory and union them all with no limitations on schema or multi-sheet files for .xls. Obviously this is easily done with a batch for .xlsx so the value-add is multi-sheet .xls.

It goes the R-route.

[rkapoor]

@apathetichell yes sure, I will have a play and let you know

[Govind_Dileep_G]

Thankyou. Helped a lot

[Govind_Dileep_G]

Thankyou