When I import an Excel file in to Alteryx I get an error: “shared strings root=x:sst” and Alteryx cannot read the file.
I can work around this by manually opening and saving the excel before importing it into Alteryx but this is not ideal, especially considering the automation implications.
I believe this may be happening because the XLSX generated by the source of the report has a prefix “x:” in all the tags in the Shared String XML embedded in Excel. See: https://learn.microsoft.com/en-us/office/open-xml/working-with-the-shared-string-table
Essentially, it would appear Alteryx is not able to read generated Excel sheets which has the prefix "x:" (e.g. from a bot). The second file which has been opened and saved in Excel manually can be read by Alteryx correctly.
Example of file as exported from ”BOT”:
![PDempsey_0-1685619453716.jpeg PDempsey_0-1685619453716.jpeg](https://community.alteryx.com/t5/image/serverpage/image-id/307575i7D6D8A88F939614F/image-size/medium?v=v2&px=400)
How the same file looks once it is manually opened and saved:
![PDempsey_1-1685619453721.jpeg PDempsey_1-1685619453721.jpeg](https://community.alteryx.com/t5/image/serverpage/image-id/307574i0873075A2BAB5ED5/image-size/medium?v=v2&px=400)
Ideally Alteryx would read the file as is, i.e. with the "X:SST" tag seen above as having to manually open and save the excel before it can be read is rather clunky.
Thanks!