Split Table Wizard for Microsoft Excel

Split a table into separate worksheets in Excel 2013 - 2003

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

Complete support 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! Split Table Wizard will automatically divide 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 3-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 and names for your tables

In addition you can copy the header, 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.

19.95
Buy now

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

Free Download
Free 15-day trial version, 9/12/2014

Split Table Wizard for Excel system requirements:

Operating System

  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Vista (32- and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 2.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

Microsoft Excel

  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Split Table Wizard version

Current add-in version: 2.3.4
published on: Sep 12, 2014

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
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
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
Awesome!!!
Sheila Blanchard