Split Table Wizard for Microsoft Excel for Windows

Used Split Table Wizard for Microsoft Excel for Windows?

Editors’ Review

Download.com staffJuly 30, 2026

This Excel add-in splits a single large table into multiple separate tables or workbooks. A step-by-step wizard guides you through selecting key columns and choosing output destinations for the organized data.

Top Recommended Alternative

PresentationPro Express Plugin for PowerPoint

Trial version

Pros
- Splits tables based on values in one or more key columns.
- Wizard-guided interface simplifies the splitting process.
- Outputs tables to current workbook, new workbooks, or separate files.
- Automatically copies the original header to all new tables.
- Names new worksheets dynamically using key values or sequential numbers.
Cons
- Requires installation as an external Excel add-in.
- Only splits data based on column content.
- Lacks ability to split tables by row count.
- Does not provide functionality for merging or combining tables.
- No documented support for scripting or automation.