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.
I have exported data from an online CRM to excel. The file downloads as a .xls file, but when I try to connect to it in Alteryx I get the below message.
I can connect to other .xls files without issues so I assume there is something else wrong with the file besides the .xls format (I also can't open it using Tableau or Microsoft Power Query).
I have tried opening the file in Excel, then saving it as a .csv. The problem with this is that one of the fields has many (but not all) entries starting with zero and these leading zeros are not retained when I save it as a .csv file
Does anyone have any suggestions? I need the file in a format that Alteryx can connect to with the leading zeros retained