KutoolsforOffice — One Suite. Five Tools. Get More Done.

Split, combine & merge Excel data

Make Excel splitting, combining, and merging easier with Kutools for Excel.

Turn time-consuming workbook and table tasks into guided workflows—from splitting workbooks and combining worksheets to reorganizing datasets and merging related tables.

Download Kutools for Excel Explore All Features →

30-day full-featured free trial · No limitations

Kutools Plus ribbon showing workbook and worksheet tools

The workbook and sheet tools are available directly from the Kutools Plus ribbon in Excel.

Four practical tools

From splitting workbooks to merging Excel data.

See how each tool turns a common multi-step Excel task into a simpler, guided workflow.

01 · Split Workbook

Split one workbook into separate files.

Save selected worksheets as separate Excel files while keeping the original workbook unchanged.

1 workbook→multiple files
Split Workbook in Kutools for Excel
02 · Combine Worksheets

Bring many worksheets into one organized result.

Bring data from multiple worksheets and workbooks together—combine ranges, merge matching sheets, collect sheets into one workbook, or consolidate data into a summary.

scattered sheets→combined result
Combine Worksheets in Kutools for Excel
03 · Split Data

Turn one large dataset into multiple worksheets.

Split rows into separate worksheets based on the values in a specific column. For example, select the Department column to create a separate worksheet for each department.

one dataset→organized sheets
Split data into multiple worksheets by Department
04 · Tables Merge

Merge and update related Excel tables.

Match records between two tables to update existing values, add new columns and rows, and bring related data into the main table.

main table+lookup table→updated main table
Tables Merge in Kutools for Excel

History of Kutools

See how Kutools for Excel has grown and evolved since 2008.

Kutools for Excel has been helping Excel users work more efficiently since 2008. Developed and continuously refined by an experienced team, it is now trusted by more than 500,000 users worldwide, including 80,000+ businesses. With practical, easy-to-use features and reliable support, Kutools is built for both individual users and organizations that depend on Excel every day.

Hear From Our Satisfied Customers

See what our satisfied customers are saying about Kutools for Excel.

  • "Hello, I am a private user and I use Excel to study. I am in awe of the power of the Kutools tool. I have tried various add-ins and the best tool is Kutools. The kindness of the support is noteworthy, quick response and excellent willingness to collaborate. 100% recommendable! Thanks Kutools team!!"

    Charles

  • "This software is genius. A colleague of mine uses Kutools for her PhD in engineering and spoke wonders of it. I gave it a try and loved it. It saved me so many hours in Excel that I can't quantify how much time I gained."

    Alexandre

  • "I usually work with Excel and I found Kutools as a tool to make work more effective. It's an excellent tool. Now I'm working on a large Excel document with many worksheets — Kutools helps me work faster and easier. Thank you for this great tool."

    Isabel

  • "As a 70-year-old, I find Excel's functions complicated and time-consuming. Excel is great, but with Kutools it becomes superb. Kutools makes complex tasks easy and saves loads of time. Highly recommended!"

    Ed

  • "Kutools is absolutely the business! It does all the stuff that Excel should do but can't. Every time I discover another function, I smile. This is not a paid review — it's just a bloody handy tool. Many thanks!"

    Ray

Frequently Asked Questions

Questions about Kutools for Excel

Everything you may want to know before getting started.

Yes. Kutools for Excel includes a 30-day free trial with full access to its features, so you can try the splitting, combining, and merging tools shown on this page before purchasing.

Each Kutools for Excel license can be used on 2 computers, such as one office computer and one home computer.

For Terminal Server or Citrix Server environments, a separate desktop application license is required for each desktop that accesses the application.

View the End User License Agreement

Your license is for lifetime use and includes free updates for 2 years. After the update period ends, you can continue using the version you already have permanently.

Yes. Kutools for Excel comes with a 60-day unconditional money-back guarantee. If it does not meet your needs within 60 days of purchase, you can request a full refund.

View the Refund Policy

?
Still have questions?24/7 online email support is available whenever you need help.
Contact Support →
30-DAY FREE TRIAL

Ready to simplify your Excel workflow?

Try Kutools for Excel and get full access to the tools for splitting, combining, merging, and much more.

Download Free Trial → Explore All Features
30 days freeFull-featured trialNo limitations
30 DAYS FREE
Try Kutools for Excel freeTry the split, combine, and merge tools in your own Excel files before you buy.
300+ toolsFull-featured trialNo limitations
Download Free Trial →