ONLINE TOOL

Split Excel by column value

Locally create one XLSX or CSV file per distinct column value, with explicit limits and a split report.

Local processingNo account required
CONCRETE EXAMPLE

HR export by department

BEFORE
One 18,000-row sheet with a Department column
AFTER
ZIP of 24 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; review outputs before sharing.
HOW IT WORKS

A straightforward workflow.

  1. 1Prepare the required input and choose useful options.
  2. 2Review previews, warnings and limitations before export.
  3. 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.

WWorkToolset
or with email
WORKTOOLSET PRO

When work becomes repeatable, Pro saves you time.

20×Batch processingPDF · Image · Data · Media
Reusable workflowsSteps · settings · templates
PDFProfessional reportsStructured reports · share-ready exports
Work continuitySessions · projects · history
100 presets · 50 projects · 20 templates · 500 favorites

Payments, taxes and invoices are managed by Paddle. Your documents are never part of payment data.

Esc
Type a tool name, a format, or a request such as “compare two Excel lists”.