Split Table Wizard for Microsoft Excel

Split a table into separate worksheets in Excel 2016 - 2007

Split Table Wizard add-in automates splitting your table data across multiple spreadsheets based on key values in the selected columns. Use it if you have a large Excel table with complete pieces of information that you need to have in separate worksheets or files.

  • Select columns with key values for grouping the split tables
  • Insert the divided tables into the current or new workbook, or paste each one into a separate file
  • Select the path on your PC for saving the unmerged data

Free download for:

Split Table Wizard will pull your table apart in seconds

Split second to divide a table in Excel

So, you have a huge Excel table with all your products, prices, suppliers, etc. You need to pull information that refers to the same product into an individual worksheet, name it accordingly, and copy the header to all new tables. There are 150 products stretched across 1000 rows of data.

It means sorting by product, then copying and pasting each part to a separate sheet in Excel 150 times, plus the header and the names! Sounds pretty time-consuming, right?

Not with Split Table Wizard that automatically divides your data into separate Excel worksheets. You can define where you want to save the extracted data and how you want to name the new spreadsheets.

Split table based on the key column

This 4-step wizard will guide you through the splitting process:

  • On step 1 select the table with the data you want to export to individual worksheets
  • On step 2 choose the column(s) with the key values for grouping the data, like the product name
  • On step 3 pick the destination for the resulting tables
  • On step 4 choose names for the split sheets.

In addition you can copy the header, preserve formatting, place the new spreadsheets into one or multiple Excel files, name new sheets by key values in the selected columns and add any text to the new Excel file names.

Split Table Wizard for Excel can do it all

  • Pick columns with the key values for grouping the split tables
  • Choose to insert the extracted data into the current or new workbook, or paste each sheet to a separate Excel file
  • Specify the path for saving the split tables on your PC
  • Copy header to all the resulting tables
  • Name the inserted tables by key column value or by number
  • Choose to add text before or after their names

Whenever you need to cut your table into logical pieces, Split Table Wizard for Microsoft Excel 2003 - 2013 is irreplaceable for the task. It handles your tables with care.

Read more:

Split Table Wizard for Excel screenshots

Select the table you need to split

On step 1 select the table for splitting

Choose the column(s) with the key values

On step 2 check the column(s) with key values for grouping the split data

Select destination for the resulting tables

Insert new spreadsheets in the current or new workbook, or as multiple new files

Have the table split in seconds

Have the table split in seconds

This add-in comes as part of Ultimate Suite - 60+ professional tools for Microsoft Excel

Download and try Ultimate Suite without any limitations for 14 days.

Free Download
Free 14-day trial version, 13 MB

System requirements:

Microsoft Excel

  • Microsoft Excel 2016 (32- and 64-bit)
  • Desktop Excel included in Office 365
  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016
  • .NET Framework 4.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Featured customers

Ablebits.com featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools - Ablebits.com