How to Convert xls to xlsx within Alteryx workflow

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

Grapes.xls

Orange.xls

Testing Workflow.yxmc

Apple.xls

Banana.xls

Workflow

Developer

Designer Cloud

Output

Macros

Batch Macro

Dynamic Processing

Run Command

Accepted answers

alexnajm

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

All comments

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

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)

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703