Used Split Table Wizard for Microsoft Excel for Windows?


Editors’ Review

Download.com staff
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.
Enlarged image for Split Table Wizard for Mi…
Split Table Wizard for Microsoft Excel 0/1
  • 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.

Used Split Table Wizard for Microsoft Excel for Windows?


Explore More


Full Specifications

GENERAL
Release
Latest update
Version
2.0
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 7
  • Windows 2003
  • Windows Vista
  • Windows XP
  • Windows 2000
  • Windows 10
Additional Requirements
Microsoft Excel 2003/ 200/ 2010 32-bit and 64-bit
POPULARITY
Total Downloads
114
Downloads Last Week
0

Report Software

Program available in other languages


Last Updated


Developer’s Description

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.

Download.com
Your review for Split Table Wizard for Microsoft Excel