Ask a question »

How to split multi-worksheet Excel files into individual files?

April 2015

A Microsoft Excel Workbook consisting of several worksheets can be split into individual files with minimal manual intervention. Separating worksheets into individual files can be done with the help of Excel Worksheet Separator. Excel Worksheet Separator is a powerful and user-friendly tool that can split multiple-sheet Excel office software files into single sheet files. The tool is quick and can split an Excel Workbook into separate files in a few seconds. Excel Worksheet Separator can be downloaded for free from the internet. Excel Worksheet Separator will save you a lot of time and effort.

How to split multi-worksheet Excel files into individual files?




Do you want to separate large workbooks into individual files without having to copy and paste over and over again? It's very boring. Now, there are some tools designed to help us avoid carrying out such repetitive tasks. Excel Worksheet Separator may do you a favour!

Excel Worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split

multi-sheet Excel files into single sheet Excel files very quickly. It can easily sort through

your Excel files in seconds. Make the complicated and boring Excel work into an easy one!

Let's have a try.

Step 1


Click the "add" button to add a file or folder.
It may take you some time to scan the subfolder.
Then select the files or folder.

If you add a folder, you will see the windows (see below) to choose whether to scan Excel files

in the subfolder or not.

Step 2


Click the combo box to mark the file/sheet. Or right click the file/sheet list.

Mark the selected file/sheet.
Then select the way to name the output file.
You can double click the sheet in sheet list to open the sheet.

Step 3


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.

You can Google Excel Worksheet Separator and download it.

Note


Thanks to mokdeeo for this tip on the forum.
For unlimited offline reading, you can download this article for free in PDF format:
How-to-split-multi-worksheet-excel-files-into-individual-files.pdf

See also

In the same category

Published by aakai1056. - Latest update by Virginia Parsons
This document entitled « How to split multi-worksheet Excel files into individual files? » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.