A Microsoft Excel Workbook consisting of several worksheets can be split into individual files with minimal manual intervention. This can be done with the help of Excel Worksheet Separator: a powerful and user-friendly tool.
Do you want to separate large workbooks into individual files without having to copy and paste over and over again? there are some tools designed to help us avoid carrying out such repetitive tasks.
Click the "add" button to add a file or folder. It may take you some time to scan the subfolder.
If you add a folder, you will see the windows to choose whether to scan Excel files in the subfolder or not.
Click the "split" button or right click in the sheet list to split the marked sheets or all sheets.
Then select an output folder click "ok" to continue. It will end with the opening of the output folder.
When finished, you will see all the split worksheets as new Excel files in your folder.