Read list of excel files with similar filenames in a folder (multiple sheets)

[Paddi]

Hi all,

I'm trying to read multiple files with similar filename in one folder, the name of each of the excel files is like:

Testing1.xlsx

Testing2.xlsx

Testing3.xlsx

and each of the files has 4 sheets: sheet1,sheet2,sheet3, sheet4, 

What I want to to is to combine all sheet1 from Testing1,2,3 together, combine all sheet2 from Testing1,2,3 together, etc.

I tried to import the files using Testing *.xlsx, but it can only input data from Testing1.xlsx (records in Testing2.xlsx not shown)

Do you have any idea about how to deal with this issue? Thank you.

[caltang · Accepted solution]

Just solved something similar just now here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Load-large-number-of-excel-fil...

You can use the workflow I attached there.

[ChrisTX · Accepted solution]

@Paddi a few other posts that may be helpful:

Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Load multiple Excel files from specific folders

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Load-multiple-Excel-files-from-specifi...

Chris

[Paddi]

Thank you, the solution works with minor adjustment to specific cases.

[Paddi]

@caltang Hi, thanks for your help, it works perfect with .xlsx files, but fails when it comes to .xls files, do you have any additional suggestion about reading list of .xls files with similar filename? Thank you.

[caltang]

Your original question involved .xlsx. If it solved your need, then it's already correct and you can mark both Chris and I's solution as accepted solutions. 

Now you are asking for .xls, and that is slightly different. Since my input path uses *.xlsx, you can change it to *.xls instead and make sure to point it to where it is stored accordingly.

If you need more material: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309