Skip to content
dotXLSOpen Workspace

Split Worksheet by Column

Split one worksheet into separate worksheets based on unique values in a selected column.

Choose a column, analyze its unique values, preview the worksheet plan, then create separate worksheets while keeping the source unchanged.

Paste Data

Copy cells from Excel or Google Sheets and paste them here.

Import a spreadsheet file

Import CSV or XLSX data into the current dotXLS workspace. Files are processed in your browser.

Tools

The first row is protected as the header. Each unique value in the selected column becomes a separate worksheet; the source remains unchanged.

Split Worksheet by Column

Excel worksheet names are sanitized automatically. Existing or duplicate names receive a safe numeric suffix. A warning is shown before creating more than 25 worksheets; more than 100 are blocked.

Undo and Redo controls are available with the current grid.

Paste spreadsheet data to create your workspace.

Name	Department	Amount
Ahmed	Sales	1200
Maria	HR	950

Your data stays in this browser tab and is not sent to WordPress.

Export result

Download the current workspace data after editing or cleaning.