In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Creating a copy of a file with a different format type.

XiaoDSJ
5 - Atom

Hi all,

 

I have a .xlsx file with multiple sheets that needs to be converted to a .xls file. 

It is part of a larger Alteryx+Python workflow, so manually opening the file and saving it in a different format every time is unfortunately not doable.

I have tried using the community Copy and Move Tool, however, it does not seem to work for this task.

I have also tried using python shutil.copyfile and os.rename, but the file is still being read as a .xlsx (opening the file in excel throws a warning that the file format and file extension do not match)

 

Opening the file with the "file input" tool and directly putting it into an output tool works in theory, but would have to be set up for each individual sheet in the file (of which there are many).

 

Not sure where to go from here, but I am open to python and/or Alteryx based solutions 

 

Thanks!

0 REPLIES 0
Labels
Top Solution Authors