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.
@vijayyd The below post might be helpful
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Macro-covert-files-csv-and-xlsb-to-xlsx-format/td-p/742528
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 xlsxhttps://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/XLS-format-format-to-be-changed-to-xlsx/td-p/1141446
Converting .xls file to .xlsxhttps://community.alteryx.com/t5/Alteryx-Designer-Discussions/workflow-Converting-xls-file-to-xlsx/td-p/303040
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
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
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.
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
