This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The problem is that you're trying to use the Alteryx .xls driver to read what is essentially a flat csv file. Excel is clever enough to figure out that your .xls is actually a csv and then invoking the proper import routine. The Access driver, which is used to read legacy .xls files, isn't. It's expecting a binary format specific to .xls files and the flat csv format fails.
You can open it in Alteryx as a csv file format with a .xls extension. The problem will then be if you're trying to use the same Input tool to open files that could be either format.
Edit: Why the rename. If you leave it as .csv, Alteryx will be able to open it and double clicking on it will open it in Excel, assuming you haven't changed the default file extension mappings