How to Convert xls to xlsx within Alteryx workflow

[Dhilip_Kumar]

Hi All,

Alteryx 64 bit does not allowed xls format files as input, So I want convert all xls files on the folder and convert it into xlsx folder then use the same file as input. I have attached my input files and workflow. Please help me where to place run command and how to use that.

Since the xls format not support I used xlsx version as input in my workflow.

Thanks

Dhilip

[ChrisTX]

I have Alteryx 64 bit, version 2023.2.

Using the Input Data tool, in the drop down menu for File Format, I have an option for "Microsoft Excel 1997-2003 (*.xls)"

Do you not have this option?

Chris

[alexnajm · Accepted solution]

How about this Python option? Solved: XLS format format to be changed to xlsx - Alteryx Community

Any options here work? convert all different excel file type to xlsx - Alteryx Community

[Raj]

@Dhilip_Kumar 
you can refer this as well
Converting xls to xlsx files in Alteryx – Creative Data

[Dhilip_Kumar]

@RajI have a access restriction to download and install exe files. Also the same problem to download Libreoffice as well.

Thanks for your help!!!

[Dhilip_Kumar]

@alexnajm Thanks for the suggestion. Python option works well but Could you please help us how can i get input those xlsx file after the conversion by Python tool.

I appreciate all your help.

[alexnajm]

You can either do it in the Python code, or you can read them in via a Directory tool + Dynamic Input or Batch macro: The Ultimate Input Data Flowchart (alteryx.com)