SplitExcel is a free command line tool to split sheets of Excel file. It takes an XLS or XLSX file from you and then extracts all the sheets from it and then save them to separate Excel files. However, in the output, it can only generate the Excel File in XLSX format only. No matter if you supplied an XLS or XLSx file, you will only get XLSX file in the output.
Splitting an excel sheet can be useful at many places. Suppose you were saving records of each person in your team in different sheets of an Excel workbook and later you want to save them as separate files, then you will need a tool to do that for you. In that case, SplitExcel comes in handy. You just give it a source Excel file and it will split it. Also, being a command line tool, you can make a batch file with this. And with the batch file, you can split multiple Excel workbooks by their sheets.
How to Split Sheets of Excel File with this Free Command Line Tool?
SplitExcel is an open source tool as well. If you want to sneak into its code, then you can find that on GitHub. And to run this, there is just a simple command you have to run. There is no need to install any other tool or software to assist it. Just start using it after you download it.
Here are some steps to use this tool to split an Excel file.
Step 1: You can clone the repository of SplitExcel and then extract it to some place of your choice. After that, open the folder “SplitExcel\bin\Debug”. Next, you will see an EXE file there and you have to open a command prompt there.
Step 2: Now, copy the Excel File in the the folder of SplitExcel tool. For simplicity, you can change the name of the Excel file to a short one like “test” or “sample”.
Step 3: Now, run this command in this syntax. It will take the specified Excel workbook and will extract each sheet from it and save it as a separate Excel file in the same directory. And no matter if the source Excel file is XLS or XLSX, it can split them all in a couple of seconds.
In this way, you can easily split an Excel workbook using this free command line tool. All you have to do is run simple command and get the output. Also, if you know how to make batch files, then you can use this tool to split multiple Excel files in one go.
If you have been looking for a tool to split the sheets from an Excel file to separate Excel files, then you have come to the right place. The tool that I have explained above works perfect when it comes to split XLS or XLSX files. There is just a simple command that you have to execute to split an Excel file in a few seconds. However, you may not be able to merge them back.