Batch Input multiple .xlsb files

bunzzz

Good Morning Community!

I have a problem myself and @dcampana2 are trying to solve. We have large quantity .xlsb files that we need to input. The files have different names but they all have the same named tab. Is there a way to input them all? I have tried numerous "tricks" but none have worked thus far.

GiuseppeC

Hi @bunzzz,

the error that you are getting is due to the fact that the Sheet name is most likely not identical in all files.

I was able to replicate it by creating 3 .xlsb files, 2 containing a sheet named Sheet1 and the the third, SheetA.

There are a few posts and solutions on Community on how to import multiple files with different sheet names.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/using-dynamic-input-on-excel-files-with-different-tab-worksheet/td-p/3503

Finally, to your point of your files not being in the same directory, I'd suggest to replicate this approach to all the different directories you have files in, import multiple files from each, and using the Union tool to stack the data from the multiple connections.

Hope this helps!

Giuseppe