Converting .XLS to .XLSX

[johnrexrima_19]

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.

[JosephSerpis · Accepted solution]

You could use an output tool and save the file as .xlsx

[RishiK]

@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?

[johnrexrima_19]

@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.

[johnrexrima_19]

It works! Thanks @JosephSerpis and @RishiK !