- In short
- Splits the selected table by the values in a column you choose. Each group can go to its own sheet in this workbook or to its own Excel file in a folder you pick. Your original table is not changed and no data leaves your computer. There is no undo because new sheets or files are created, so delete them if you do not want them. New sheets (this workbook) or .xlsx files (chosen folder). The source table is left as it is.
What it is for
Split Data is used to split a table by a column's unique values into separate sheets or .xlsx files.
When to use it
It earns its place whenever you have to split one table into per-branch/region/rep files.
Example scenarios
- Split one table into per-branch/region/rep files.
What it needs
A table selection (single-cell/whole-row refused) and an options dialog; many-groups (≥50/≥200) confirm. Supported data types: text, number, date (by selection).
How to use it
- Select the range to summarize.
- Run Split Data from the Summarize & Prepare group on the XLMind Plus tab.
- Adjust the options in the window to fit your case.
- Confirm; new sheets (this workbook) or .xlsx files (chosen folder).
What it produces
New sheets (this workbook) or .xlsx files (chosen folder).
Effect on your data and undo
Split Data does not change your source data; the result is added as a separate item.
How it differs from similar tools
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
Confirmation for large operations. Single cell only; whole row refused; size limits (≥50/≥200).
Limitations
Single cell only; whole row refused; size limits (≥50/≥200).
Frequently asked questions
- Where will I see the result?
- New sheets (this workbook) or .xlsx files (chosen folder). Nothing is written on the sheet holding your source table.
- What happens to invalid or unexpected values?
- Text-safe.
- How are blank cells handled?
- Optionally included.
- Does the result stay linked to the source?
- No, the output is static; rerun the tool after changing the source data for a current view.
- Any known limits?
- Single cell only; whole row refused; size limits (≥50/≥200).
Works well with
- As a preparation step, try Unpivot Columns
- Often used alongside this tool: Group By
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.