Skip to main content

Explore the new, free version of Kutools for Outlook today!

Author: Sun Last Modified: 2024-12-10
Quickly Split Workbook free trial shot buy now
Split workbook and save the sheets as new separated workbooks or other formatting files

Split Workbook, We Are Professional

Split Workbook feature supports to split or save all sheets in one workbook to independent workbooks or other formatting files, and then save them to a specified folder you defined.

★  Separate to workbooks (XLS)
★  Separate to workbooks (XLSX)
★  Separate to CSV files
★  Separate to PDF files
★  Separate to TXT files

 shot features

A Good Tool Never Be Afraid Of Contrast

Seconds to split one workbook to multiple workbooks

Kutools

◆ Split and save all sheets of current workbook to separated workbooks at once

shot flash

 VS

Copy and Paste And Move and Copy

◆ Only split a sheet from workbook at once, it is time-wasted when split multiple sheets

shot waste time

Support varied formats preservation

Kutools

◆ Quickly save the separated sheets as independent workbooks, or other file formats, such as PDF, CSV, TXT
◆ Easily choose saving locations as you need

shot path

 VS

VBA Code

◆ One code only can save sheets as one type of file, if you want to save as other types, you need to research other codes
◆ Manually typing saving location in the code

shot no path

A Tool You Deserved

shot select sheet  

Separate any sheet(s) you need

▲ Support separate all sheets from the workbook, also can separate the specified sheets you need from the workbook
▲ List all worksheets of the workbook including hidden and blank sheets. By default, all sheets are selected for separating, you can tick the sheets you want to separate manually
shot save path  

Save sheets to any location you want

▲ Separate sheets from workbook and save them to a specified folder you defined at the meantime
▲ Remember the last saving location, and also support to change or create a new saving location
shot save formatting  

Save separated sheets as the file format you choose

Provide 5 file formats for you to save
▲  Excel Workbook(*.xlsx)
▲  Excel 97-2003 Workbook(*.xls)
▲  CSV(Macintosh)(*.csv)
▲  Unicode Text(*.txt)
▲  PDF(*.pdf)
○ Skip hidden sheets ○ Skip blank sheets
shot filter hidden shot filter blank

Protect original data

shot original data

  

List all sheet names

shot list sheets 1

Split accurately

shot bullseye 1

  

Easy to use

shot steps 1

Product Guarantee

shot free try shot refund shot service
30-day no limited free trial 60-day no reason refund 24 X 7 E-mail service
shot lifetime use shot upgrade shot benifits
Buy once to use forever Free upgrade in two years Other 300+ features for you

shot info  Split Workbook is one of features in Kutools for Excel. Except Split Workbook, Kutools for Excel collects else more than 300 tools, which covers text editing, advanced formulas, professional charts, worksheet & workbook combination, passwords management and so on. In a word, Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel and saves Excel users a mass of working time and improves working efficiency greatly.