How do i read all the excel files along with their sheets

Theja_G

I have different dates of excel files and in that each file have different sheets example - File1 - 25-04-2023 | sheet1, sheet2, File2 - 26-04-2023 | sheet1, sheet2, sheet3, File3 - 27-04-2023 | sheet1, sheet2

Now how do i read all the excel files along with different sheets into Alteryx? i tried using dynamic input tool but its throwing an error for sheet3.

Yoshiro_Fujimori

Hi @Theja_G ,

I followed the link How To: Import Multiple Excel Sheets or a Specific... - Alteryx Community, which @messi007 provided,

and it worked as attachment. (Please unzip the file in the same folder)

Could you check if there are any differences with your workflow?

Input Data

Each sheet has one cell as below with File Name and Sheet Name.

Result window (with "Show All Macro Messages" on)

Output

MultiExcelBooks_Sheets.zip