Split an Excel sheet by one or more columns

Turn one master table into separate worksheets using the exact category columns you select.

Windows 10/11 · Works with .xlsx files · Source files stay unchanged

BEFORE

ID	Group	Amount
A01	North	120
A02	South	80

AFTER

Result sheet	ID	Amount
North	A01	120
South	A02	80

Illustrative sample data, not a software screenshot. Each group becomes a separate worksheet with the original columns preserved. This index shows where each row goes.

How do I split rows by a column value into worksheets?

For a small number of categories, filter each value and copy the complete rows with their headers. In DExcel, choose the category columns to generate one worksheet per value combination.

Simple example

A table containing North and South becomes a new workbook with a worksheet for each region.

Scope: This groups records, not text inside a cell. The output is worksheets in one workbook, not a separate file for every category.

BEFORE

What takes time today

Filters applied and copied repeatedly

Multi-column categories are easy to mix up

Manual sheet naming takes extra time

AFTER

What you get instead

One worksheet for every value combination

Original headers and values preserved

A separate output workbook ready to share

HOW IT WORKS

Choose. Configure. Save.

Add one .xlsx workbook and choose the source worksheet.

Select one or more split columns; nothing is preselected.

Generate a new workbook containing the separated worksheets.

Test it with your own workbook.

Free Windows preview · .xlsx files · Review your new workbook in Excel or WPS.