Export individual tabs in 1 excel file into it's own separate excel file

[chokwoo]

Hello, so I have 1 excel file with 10 different tabs with unique names. I'd like to use alteryx to export each tab as a separate excel file and name the file according to the names of the tabs. Any help is appreciated!

[Felipe_Ribeir0]

Hi @chokwoo 

Try the attached workflow, just point the input tool to your main file and run.

[chokwoo]

Hello @Felipe_Ribeir0 , thank you for your response!

I imported the file and ran the workflow but getting a Parse Error at the Formula tool. could you please advise?

Also, when I import the file, should I just import under "Select a Sheet"?

Much appreciated.

[Armon24]

Hi @chokwoo 

When you import the file, select import only the list of sheet names. This should get the formula tool to work.

[PanPP]

This is how the Input tool should be configured. 

Import only the sheet names.

Hope this helps.