DEV Community

loading...

Split/Save Each Worksheet of One Workbook as Separate Excel/Txt/Csv/Pdf Files in Excel 365!!

excelgeek profile image Andrews Originally published at geekexcel.com on ・6 min read

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

Note: kutools for Excel 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 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
Select the Split Worksheet option

  • 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
Split Worksheet Dialog Box

  • 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
Select Folder Dialog Box

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

Output
Output

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
Select the Split Worksheet option

  • 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
Split Workbook Dialog box

  • 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
Click OK button

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

Output
Output

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 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
Select the Split Worksheet option

  • 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
Split Workbook Dialog box

  • 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
Click OK button

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

Result
Result

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 that you want to split the sheets.
  • Then, on the Kutools Plus Tab, select the Workbook option, then choose the Split Workbook option from the menu.

Select the Split Worksheet option
Select the Split Worksheet option

  • 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
Split Workbook Dialog box

  • 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
Click OK button

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

Output
Output

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. Keep Learning!

Read Also:

Discussion

pic
Editor guide