Split One Excel File to Multiple Sheets in New file

You can use the “Excel command” action (formerly “Excel metadata”) to obtain a list of sheets in the workbook. Then use iterations to load each sheet and save it in a separate file.

Check out also this topic: Multiple files, small variation in sheet name, import with parameter

1 Like