How to change tab names in multiple excel sheets

Question

We have a workflow where we are pulling in data from 30 excel files and 2 tabs in each file. And we have to do this for each month.

The challenge is that the tabs are named differently in each file. (example- xyz, x y z, x-y-z, x-yz, etc.)

Is there a way in Alteryx, by which I can pick all these excel sheets and rename all the tabs together?

I have added a set of sample files. Let's assume we want the first sheet in each of these sample files to be named as 'Sheet'.

Thank You

Alteryx Community.zip

Gandalf_NotGrey · Answer

Thank You so much @Felipe_Ribeir0 @davidskaife @ShankerV for your solutions.

Felipe_Ribeir0 · Answer

Hi @Gandalf_NotGrey

To just rename the sheets, you gonna need the help of some programming language.

But using the batch input macro properly configured, you can import all the data to Alteryx, change the necessary sheet names and create a new file. If this is not a problem for you, you can try with this.

OBS: the sheets must have data inside to this to work.

workflow.yxzp

davidskaife · Answer

Hi @Gandalf_NotGrey

Yes there is a way of doing this, but it can be reasonably complex.

You have two options; VBA script and the Run Command tool, or Python. Having had a quick look on the community @PhilipMannering posted a solution using Python a few months back, which seems to match what you're looking for - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Tab-Renaming-with-Python/m-p/962361#U962361