Jump to content

How to separate Excel Workbooks into new files


mokdeeo

Recommended Posts

If you have a large workbooks that you need to separate into individual files? Do you feel

 

boring to splitting multi-worksheet excel files into single-worksheet ones? 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 with high speed. It can easy to find

 

your excel files in seconds. Originaly change the complicated ,duplicate and boring excel

 

work into easy one.

 

 

You can google Excel Worksheet Separator and download it.

 

Step 1: Click the "add" button to add 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 as below to choose whether scan excel file in

 

the subfolder or not.

 

 

Step 2: click the combo box to mark the file/sheet. Or right click the file/sheet list to

 

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 opening output folder.

 

 

When finished,you will see all the split worksheets as new excel files in your folder.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...