Bulk file conversion

[omkarshinde]

I am trying to do a bulk files conversion of xls to xlsx how can i proceed please help?

[binuacs]

@omkarshinde https://community.alteryx.com/t5/Community-Gallery/Convert-xls-into-xlsx-and-parse-the-input/ta-p/99...

[omkarshinde]

hey thanks for this however how to change the path where final output of xlsx files will be stored @binuacs ?

[binuacs]

@omkarshinde by default the output files are saved in the same folder where the .xls files exist, if you want to save the .xlsx files into a different location the you need to make changes in the macro where the python tool saved

[omkarshinde]

@binuacs which part of this python tool macro do i need to modify for new path?

[binuacs]

@omkarshinde macro updated to write into the specific output folder

[omkarshinde]

@binuacs thanks "output\" in your formula tool is where i am supposed to paste my desired output directory folder path correct?

[binuacs · Accepted solution]

@omkarshinde if you want you can replace the all given strings ([director/output)) and specify your own path

[omkarshinde]

thanks a lot!