EXCEL TOOLS

Split an Excel File

Split a spreadsheet by values in one column, such as owner, team, or category.

Unlimited freeNo sign-upProcessed in browser

How to split Excel by owner or category

Use it for owner-specific task lists, department handoffs, or category-based product lists.

Processed in your browser

The selected file is read and the result is made in the current browser.

Source stays unchanged

Only a new result file is created; the source stays unchanged.

Check the result

Open the downloaded file and check its headers and row count.

PRACTICAL GUIDE

How to use it

  1. Choose an XLSX or XLS file.
  2. Select the source sheet and the column to split by.
  3. Download a ZIP containing an XLSX file for each value.

Frequently asked questions

What format is the result?

The tool makes one XLSX file per selected column value and puts them in one ZIP.

Does each file keep the header?

Yes. Every result file includes the original header row.

What happens to blank rows?

Completely blank rows are not included in the results.

Related Excel tools