Skip to main content
Author: Sun Last Modified: 2021-04-19
Quickly Split Workbook free trial buy now
Split workbook and save the sheets as new separated workbooks or other formatting files
split workbook 1

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


A Good Tool Never Be Afraid Of Contrast

Seconds to split one workbook to multiple workbooks


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



Copy and Paste And Move and Copy

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

waste time

Support varied formats preservation


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



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

no path

A Tool You Deserved

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

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

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
filter hidden filter blank

Protect original data

original data


List all sheet names

list sheets 1

Split accurately

bullseye 1


Easy to use

steps 1

Product Guarantee

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

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.