Excel Sheets Separator

Excel Sheets Separator

It allows you to break one single Excel document into different files
 
0.3
Check the report.

Excel Sheets Separator is a small but useful application that allows you to break one single Excel document with more than one worksheet into separate files, converting each worksheet into one single Excel file.

One of the advantages of using this program is that you can select to separate one or more files at the same time. Another advantage is that the program supports both xls and xlsx excel formats.

There are two ways to add files. You can select file by file or select an entire folder. With the second option all the Excel files included in the folder will be automatically added.

The files to be separated are automatically added to a list on the Main window. Here you can change the order of the Excel documents. There also two more frames in the lower side of the main window, the Workbooks frame and the Worksheet frame. There you can manually select or unselect the worksheets you want to split for each file.

There are three ways to assign the names of the output files, you can assign the names based on their own sheet names, assign the name of the workbook name and sheet name, or you can assign consecutive numbers, 1.xls, 2.xls, 3.xls, and so on.

After this, the last thing to do is to click the Separate button, and you will be asked to choose the folder where the files will be saved.

Roberto Jimenez
Editor rating:

Review summary

Pros

  • You can select to separate one or more files at the same time.
  • The program supports both xls and xlsx excel formats.

Cons

  • Trial version is limited to split only 5 times.

Related stories

See all
How to randomly rename files in a folder
How to randomly rename files in a folder
Microsoft Office 2016 keyboard shortcuts: Microsoft Excel
Microsoft Office 2016 keyboard shortcuts: Microsoft Excel
The best tips and tricks for using the File Explorer
The best tips and tricks for using the File Explorer
Microsoft is injecting ads for OneDrive into File Explorer
Microsoft is injecting ads for OneDrive into File Explorer
Excel for Windows now has real-time collaboration abilities
Excel for Windows now has real-time collaboration abilities

SI comments

Thank you for rating the program!
Please add a comment explaining the reasoning behind your vote.
0 comments
Your vote:

Facebook comments

Info updated on: