Menu
  1. Accueil
  2. How To
  3. Software
  4. Office Software
  5. Excel
Thanks
2
Thanks

A few words of thanks would be greatly appreciated.

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

Latest update on by Irene Burn .

A Microsoft Excel Workbook consisting of several worksheets can be split into individual files with minimal manual intervention. This can be done with the help of Excel Worksheet Separator: a powerful and user-friendly tool.

Intro

Do you want to separate large workbooks into individual files without having to copy and paste over and over again? there are some tools designed to help us avoid carrying out such repetitive tasks.

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

How to use it

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 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.

Foto: © Everypixel

Thanks
2
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
Related
This document, titled « How to split multi-worksheet Excel files into individual files? », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!