Split/Save Each Worksheet of One Workbook as Separate Excel/Txt/Csv/Pdf Files in Excel 365!!
Tags: kutoolsexceltutorial, splitworksheetofonew, kutools
Published: 2020-11-25 09:55:00

---
title: Split/Save Each Worksheet of One Workbook as Separate Excel/Txt/Csv/Pdf Files in Excel 365!!
published: true
date: 2020-11-25 07:00:32 UTC
tags: KutoolsExcelTutorial,SplitworksheetofOneW,Kutools
canonical_url: https://geekexcel.com/split-save-each-worksheet-of-one-workbook-as-separate-excel-txt-csv-pdf-files-in-excel-365/
---

In this tutorial, we will guide you to know the steps to **save or split a worksheet from one workbook as a new Excel file**. To do this, you need to follow the instructions given below. Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Split or Save Worksheet of One Workbook as Separate Excel Files:

To save each or specific worksheet as separate Excel files, follow the below steps.

- You need to [**open the workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that you want to save as Excel files.
- Go to the **Kutools Plus Tab, select** the **Workbook** option, then **choose** the **Split Workbook** option from the menu.

![Select the Split Worksheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Split-Worksheet-option.png)<figcaption id="caption-attachment-18080">Select the Split Worksheet option</figcaption>

- Then, it will open the **Split Workbook** Dialog box.
- **Worksheet name –** In this section, you need to **check the worksheet** that you want to split as a new **Excel file.**
- **Options –** Here, you need to **select Skip hidden worksheets** or **Skip blank worksheets** option.
- **Save as type –** In this drop-down list, you need to select the **Excel Workbook(&.xlsx)** or **Excel 97-2003(\*.xls) **option.
- Then, you need to **click** the **Split** button.

![Split Worksheet Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Split-Worksheet-Dialog-Box.png)<figcaption id="caption-attachment-18085">Split Worksheet Dialog Box</figcaption>

- Then, the **Select Folder** dialog box will be displayed.
- You need to **specify the location** for the split files and **click** the **OK** button.

![Select Folder Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Folder-Dialog-Box.png)<figcaption id="caption-attachment-18086">Select Folder Dialog Box</figcaption>

- Finally, you can see that the specific worksheets are saves as Excel files as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-13.png)<figcaption id="caption-attachment-18087">Output</figcaption>

## Steps to Split/Save Worksheet as Separate TXT Files:

If you want to split worksheets of one workbook as separate TXT files, then follow the below steps.

- First, you need to **activate the workbook** that you want to split.
- On the **Kutools Plus Tab, select** the **Workbook** option, then **choose** the **Split Workbook** option from the menu.

![Select the Split Worksheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Split-Worksheet-option.png)<figcaption id="caption-attachment-18080">Select the Split Worksheet option</figcaption>

- Then, it will open the **Split Workbook** Dialog box.
- **Worksheet name –** In this section, you need to **check the worksheet** that you want to split as a new **TXT file.**
- **Options –** Here, you need to **select Skip hidden worksheets** or **Skip blank worksheets** option.
- **Save as type –** In this drop-down list, you need to select the **Unicode Text (\*txt)**** **option.
- Then, you need to **click** the **Split** button.

![Split Workbook Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-44.png)<figcaption id="caption-attachment-18088">Split Workbook Dialog box</figcaption>

- Then, the **Select Folder** dialog box will be displayed.
- You need to **specify the location** for the split files and **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-43.png)<figcaption id="caption-attachment-18089">Click OK button</figcaption>

- Now, you will see all the worksheets are saved as separate **TXT files** as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-41.png)<figcaption id="caption-attachment-18090">Output</figcaption>

## Split or Save Worksheet of One Workbook as Separate CSV Files:

You can split or save the worksheet of one workbook as separate CSV files in Excel, follow the below steps.

- You need to [**open the workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that you want to save as **CSV** files.
- Go to the **Kutools Plus Tab, select** the **Workbook** option, then **choose** the **Split Workbook** option from the menu.

![Select the Split Worksheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Split-Worksheet-option.png)<figcaption id="caption-attachment-18080">Select the Split Worksheet option</figcaption>

- Then, it will open the **Split Workbook** Dialog box.
- **Worksheet name –** In this section, you need to **check the worksheet** that you want to split as a new **CSV file.**
- **Options –** Here, you need to **select Skip hidden worksheets** or **Skip blank worksheets** option.
- **Save as type –** In this drop-down list, you need to select the **CSV (Macintosh) (\*csv)** option.
- Then, you need to **click** the **Split** button.

![Split Workbook Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-37.png)<figcaption id="caption-attachment-18091">Split Workbook Dialog box</figcaption>

- Then, the **Select Folder** dialog box will be displayed.
- You need to **specify the location** for the split files and **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-43.png)<figcaption id="caption-attachment-18089">Click OK button</figcaption>

- At last, you will see the **CSV files** stored in the specified folder as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-32.png)<figcaption id="caption-attachment-18092">Result</figcaption>

## Steps to Split/Save Worksheet as Separate PDF Files:

To split or save the worksheet as separate **PDF files,** then follow the below steps.

- You need to **[open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/)** that you want to split the [sheets](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/).
- Then, on the **Kutools Plus Tab, select** the **Workbook** option, then **choose** the **Split Workbook** option from the menu.

![Select the Split Worksheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Split-Worksheet-option.png)<figcaption id="caption-attachment-18080">Select the Split Worksheet option</figcaption>

- Then, it will open the **Split Workbook** Dialog box.
- **Worksheet name –** In this section, you need to **check the worksheet** that you want to split as a new **PDF file.**
- **Options –** Here, you need to **select Skip hidden worksheets** or **Skip blank worksheets** option.
- **Save as type –** In this drop-down list, you need to select the **PDF(\*pdf)**** **option.
- Then, you need to **click** the **Split** button.

![Split Workbook Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-30.png)<figcaption id="caption-attachment-18093">Split Workbook Dialog box</figcaption>

- Then, the **Select Folder** dialog box will be displayed.
- You need to **specify the location** for the split files and **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-43.png)<figcaption id="caption-attachment-18089">Click OK button</figcaption>

- Finally, all specified worksheets are saved as individual **PDF files** as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-28.png)<figcaption id="caption-attachment-18094">Output</figcaption>

## End of the Article:

In this tutorial, we guided you to learn the steps to **Split/Save Each Worksheet of One Workbook as Separate Excel/TXT/CSV/PDF Files in Excel** Office 365 using **Kutools. ** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Take a Snapshot of Current Workbook at Any Time in Excel Office 365!!](https://geekexcel.com/take-a-snapshot-of-current-workbook-at-any-time-in-excel-office-365/)
- [Import Data from Another Worksheet or Text Files in Excel Office 365!!](https://geekexcel.com/import-data-from-another-worksheet-or-text-files-in-excel-office-365/)