Excel Sheets Separator

Excel Sheets Separator

It allows you to break one single Excel document into different files
 
0.7
Check the report.
Used by: 9 people
License: Shareware
Developer:
trusted DOWNLOAD 1.4 MB

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.

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:

Related stories

See all
Windows Search alternatives: find a file in record time
Windows Search alternatives: find a file in record time
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
Thank you for rating the program!
Please add a comment explaining the reasoning behind your vote.
0 comments
Your vote:

Latest stories

See all
Modders are looking to recreate Red Dead Redemption in GTA V
Modders are looking to recreate Red Dead Redemption in GTA V
Best new tweaks coming to Windows 10
Best new tweaks coming to Windows 10
The first DLC for Sniper Elite 4 will arrive on March 21st
The first DLC for Sniper Elite 4 will arrive on March 21st
Upload photos from Windows 10 to Instagram
Upload photos from Windows 10 to Instagram
Do you own a new generation CPU? You MUST use Windows 10
Do you own a new generation CPU? You MUST use Windows 10
Info updated on: