Split Table Wizard for Microsoft Excel - Split an Excel worksheet into separate tables by column value
Split Table Wizard instantly splits an Excel worksheet across multiple tables based on key values in selected columns. Use this add-in if you have a large table with complete pieces of information that you need to have in separate spreadsheets.
The wizard will guide you through the splitting process: easily select the table you need to separate, choose the key column or columns and pick the destination and names for the resulting tables.
With Split Tables for Excel you can:
- Select columns with the key values by which to split the data
- Indicate if your table has headers
- Insert the resulting tables into the current or new Excel workbook
- Choose to insert each new table into a separate workbook
- Select the folder for saving the split tables
- Copy a header to all split tables
- Name the inserted worksheets by key column value or by number
Just try it and it will make the splitting routine a breath!
The add-in works with Microsoft Excel 2013 32-bit and 64-bit, 2010, 2007, 2003.
For more information please visit http://www.ablebits.com
What's New: New release
Limitations: 15 Days Trial

Split Table Wizard for Microsoft Excel 2.1.2 is 100% clean
This download (excel-split-table-wizard.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

 

1. Ablebits.com Workbook Manager for Excel 2.0 - See all opened books & sheets in a tree view. Easily sort, insert, rename, copy
2. Fuzzy Duplicate Finder for Excel 4.1 - Find and remove partial duplicates, misprints and typos from Excel worksheets.
3. Merge Tables Wizard for Microsoft Excel 3.1.6 - Match and merge two Excel spreadsheets in 5 quick steps
4. Random Sorter for Microsoft Excel 2.1.2 - Shuffle cells, rows or columns; randomly select a number or percentage of data
5. Ablebits.com Duplicate Remover for Excel 3.1.5 - Remove duplicates from Excel list, compare two worksheets for duplicates/uniques
6. Advanced Find & Replace for Excel 5.0 - Find and Replace in values, formulas and comments in all opened workbooks.
7. Merge Cells Wizard for Excel 4.1.15 - Merge Excel cells preserving all data, join by rows or columns.
8. Cells Assistant for Microsoft Excel 1.5.0.1 - An Excel tool that enriches the built-in Special Cells dialog.
9. AutoFormat for Excel PivotTables 2.0.3 - Create, store and apply your own formats for excel pivot tables
10. PivotTable Helper for Microsoft Excel 1.1.0.17 - It makes working with pivot tables comfortable and fast.