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

Download (13822 KB) Website Link to this page