Hi @Sarreddy
As far I could see in the partial screenshot, you have linked to the directory tool to input all the excel sheets.
It will input the list of file names, then you have only the sheet names.
Can you please show where exactly the error pop up.
Many thanks
Shanker V
Hi @Sarreddy
That option is only available for .xlsx files, and you are importing an .xls file
If you really need to, there is a python method in this thread here
But if you can convert your file to an .xlsx then that would be much easier :)
Ollie
Hi @Sarreddy
It's because you're trying to import a 97-2003 file which uses legacy drivers.
You have two choices; manually save the file as xlsx or use Alteryx to do that for you. More info here - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/workflow-Converting-xls-file-to-xlsx/t...