Hi everyone,
I have a .XLS file downloaded from a website. I wanted to convert the file to .xlsx first before using the file as an input. Do you have any suggestions on how can I make this possible? Thanks.
Solved! Go to Solution.
@johnrexrima_19 if you are using Alteryx to webscrape and download the data in a workflow (via the Download tool) you can save this as a XLSX file. However you can simply use a combination of the Select and Output Tool to convert the data to XLSX.
Can you share the website you get the XLS files from?
@RishiK I am not yet using the Alteryx to download the file from the website - it is downloaded manually. The website is https://securities.citidirect.com.
It works! Thanks @JosephSerpis and @RishiK !