Importing multiple excel files

Zaid

Hi All,

I have found multiple threads with the issue but somehow i am unable to implement it correctly at my end. I would be glad if somebody could elaborate the steps.

The main objective is to import multiple excel files having one sheet in each of them. The column headers and the number of columns is identical in all the files. I want to bring data from all the excel files in one excel file. For example, lets say that I have data for for all months in different excel files. Now, i want them to combine all of them and bring them in one excel file.

Can you please elaborate, how this can be achieved using dynamic input and directory or some other tools.

Thanks

Zaid

LordNeilLord

Hey @Zaid

First option (if all the files are the same and the sheets are the same) would be simply use the wildcard input function:  https://www.youtube.com/watch?v=1y1gFXDkYwA

If you want to go down the dynamic input route...try this blog: https://nalediholly.wordpress.com/2017/04/22/import-multiple-files-to-alteryx-with-the-directory-tool/

If that fails (your getting schema errors) you'll need a batch macro to import the sheets: https://www.concentra.co.uk/blog/how-import-multiple-excel-sheets-and-files-different-schemas-alteryx