Inputting excel but is not being read as excel. Transform file type at source?

Jes

I have a process that generates a daily file that is being recognized as a MS Excel 97-2003 worksheet file on my computer.

I am able to open the excel file and interact with the data in the file without any issues outside of Alteryx.

When I use Input Data tool to input the excel file, I see the following error. 

I have suspicions that the MS 97-2003 file is not actually an excel file given that when I try to save the excel file, I see the following message.

If I save the excel file by changing the format to .xlsx for example, Alteryx has no issue reading the file. However, this adds a manual step to the process, which I am trying to avoid.

Any suggestions on how to read the source file as is, or if I can somehow transform the file using Alteryx to get to the underlying data?

Emil_Kos

Hi @Jes,

I searched for it in the community and it looks like this might be related to some kind of driver issues but I am not sure how to get the correct drivers:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-will-not-read-in-xls-files/m-p/517605/highlight/true#M108407