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

[zhuyyu]

Thanks Chris. It works well except one thing. For some csv file, there are fields about zipcode start with 0, after the convertion, all those 0s are gone. Is there anyway to keep that. 

When I open them with excel directly, excel did ask me whether convert the field to number or keep as strings. 

[dreldrel]

You can use the dictionary tool to ingest the files. I believe Python also has libraries available to handle the file conversion process. Hope this helps