Splitting an excel file with multiple tabs

[Lucasbmccarthy]

Hi, new Alteryx user here.  Is there a way to import an excel file with multiple tabs, and then have Alteryx split the file out by tab?

[jrgo]

Hopefully one of these solved posts should answer your question. If not, please share a bit more on what exactly you're trying to do.

Getting specific tabs from multiple Excel files

splitting one excel file into many tabs.

Multiple Outputs to one tab on excel file

Single Excel File, Multiple Tabs, Different Schema...

[cmcclellan]

I would use an Input Data tool to get the list of sheets, then run through Dynamic Input tool to pull in the sheets. By that time you have all the data and the sheet names as well, then an Output Data tool to save as different files using the Sheet name to create the output filename. 

[Lucasbmccarthy]

Thanks, do I need to have a filter tool in between the Input tool and Dynamic input tool?

[cmcclellan]

Not necessarily, it depends on your data and what you're trying to achieve.

[Lucasbmccarthy]

Okay, thanks.  I am trying to import 1 Excel file with multiple sheets.  Eventually I will need to use all the data in the sheets, but first I'd like to perform multiple calculations depending on the sheet.

[cmcclellan · Accepted solution]

Ah ok, so filter AFTER the Dynamic Input ... you will have the data then.

Check it out and write a simple workflow and you will see :) 

[Lucasbmccarthy]

Worked! Thank you!