Splitting an Excel workbook into separate files is useful for many users. For example, if you take data from different people in different Excel sheets and then need to save them in separate files, this is where SplitExcel comes in. It takes the source Excel file (XLS or XLSX), splits it, and saves it as separate Excel files (XLSX).

SplitExcel is a command-line program that lets you split an Excel workbook with a simple command.

How to Use SplitExcel

Follow these steps to split your Excel sheets:

  1. First, download SplitExcel.
  2. No installation is required, nor any additional platform.
  3. After unzipping the folder, go to the directory: SplitExcel – bin – Debug.
  4. There you'll find the file SplitExcel.exe.
  5. Open a CMD window and drag the file into the command prompt dialog.
SplitExcel: How to Split Sheets of Excel Files
No installation needed
  1. Copy the Excel file you need to split into the Debug directory.
  2. In the CMD window, add a space and type the name of the file to split, in this case Libro1.xlsx.
SplitExcel: How to Split Sheets of Excel Files
You can do it in a few steps
  1. Press Enter and the platform will list the sheets as separate files in the Debug folder.

As you can see, splitting the sheets of an Excel workbook into XLSX files with SplitExcel is a simple task that you can do with a simple command.

Official site: