Spreadsheets & data · ONLINE TOOL

Split Excel by column value

Preview column groups, choose which ones to export, and review output names/files before creating the XLSX or CSV ZIP.

Local processingNo account required

USE CASES

When to use Split Excel by column value?

Prepare and distribute rows from an Excel sheet by distinct value: preview groups, choose which ones to produce, and review output file names before creating the ZIP.

Create only the needed files per department or location
Split an export by owner after checking group volumes
Exclude selected groups before producing a distribution ZIP

CONCRETE EXAMPLE

HR export by department

BEFORE

One 18,000-row sheet with a Department column

→

AFTER

Preflight 24 departments → select 18 → ZIP of 18 XLSX/CSV files + value/file/row-count report

PRIVACY

Your data stays in the browser

Processed content is not uploaded to WorkToolset. Required libraries may be loaded by the site, but the file stays in the browser.

GOOD TO KNOW

Limitations to know

Output copies visible calculated values, not formulas, styles, charts, connections, macros or signatures.
Maximum: 250 groups and 250,000 rows; file names are sanitized and outputs should be reviewed before sharing.

HOW IT WORKS

A straightforward workflow.

1Prepare the required input and choose useful options.
2Review previews, warnings and limitations before export.
3Download a new copy or report: the original stays unchanged.

PRIVACY

Frequently asked questions

Are my files uploaded to WorkToolset?

No. This tool runs locally in your browser.

Is my original file modified?

No. WorkToolset creates a new copy or export.

Do I need an account?

No for this free tool. Accounts are mainly used for favorites, presets and future workflows.