Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Convert excel file format xls to xlsx


I have some reports arriving to me in xls format, but I would like winautomation to automatically convert format to xlsx. 

Any idea? Many thanks!


Hi, Sergiu.

There are multiple ways to perform this tasks:

(i) Through Excel actions - Open each file and rename it.

(ii) Through VBscript

Without opening the file, you can rename it through Command prompt using "REN" command.

Syntax: Ren [full path including the file extension] [new filename/extension]

Eg: Ren C:\Users\ABC\Desktop\Example_Sheet.xlsx Example_Sheet.xls

I hope this helps in resolving your issue.

Open them one at a time and save them as the new preferred format.

Find me on LinkedIn if you need instruction :)

Login or Signup to post a comment