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

Question

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!

PanPP · Answer

This is how the Input tool should be configured.

Import only the sheet names.

Hope this helps.

Armon24 · Answer

Hi @chokwoo

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

chokwoo · Answer

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.