, Can Alteryx be used to split multiple sheets from multiple Excel files?

[zhengtianxiang]

 For example, if I have 10 Excel files, each with 3 sheets, is it possible to output 30 separate Excel files?

[alexnajm]

Yes very possible, you just need some way to create 30 unique file names and use that in your Output Data tool in the bottom section!

Decide on how the new naming convention would be, use a Formula (most likely) to make those file names, and reference that path column in your output

[flying008]

Hi, @zhengtianxiang 

Dear, you will have the following questions to consider:
1- Do you need to keep the original format and schema for each independent Sheet you output?
If the answer is yes, then the Output tool may not meet your needs. You need to use PowerShell scripts in tools like Run Command to split the Sheets of the original xlsx file and output them.
2- Are the Schema of all Sheets the same?
If the answer is yes, then you can use the Output tool to meet your Split output needs.

[caltang · Accepted solution]

Yes possible. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Splitting-Excel-File-to-multip... -> This but with a bit more configuration at the beginning to identify the sheet names from the settings. :)