convert all different excel file type to xlsx

[vijayyd]

I am looking to convert xlsm, xls, xlsb, csv to xlsx. Have 50-60 different type of excel file and I need to convert all these file into xlsx.

[binuacs]

@vijayyd The below post might be helpful

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Macro-covert-files-csv-and-xls...

[ChrisTX]

See if the attached workflow helps.  It uses this EXE:  "C:\Program Files\Microsoft Office\root\Office16\excelcnv.exe"

A few related posts:

XLS format format to be changed to xlsx
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/XLS-format-format-to-be-change...

Converting .xls file to .xlsx
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/workflow-Converting-xls-file-to-xlsx/t...

a fantastic app that takes a directory path and converts all xls files to csv or .xlsx respectively.

The post is located all the way in the bottom.

https://community.alteryx.com/t5/Data-Sources/Error-opening-an-XLS-not-xlsx-file/td-p/47085/page/2

Chris

[vijayyd]

Thanks Chris, but I can not use EXE file link as I have to upload workflow on Alteryx server. Also, none of the resolution shared in link helped. appreciate your help and looking into this

[ChrisTX]

Try writing out Powershell commands to a batch file (extension .ps1), then running the batch file.

Google Powershell convert to XLSX or save as XLSX

Chris