Spreadsheets

Split Excel Files By Column

Split one spreadsheet into multiple files or sheets - one per unique value in a column.

When to split Excel files

Breaking a company-wide report into separate files per region or department
Splitting a customer list by account manager before distributing
Separating survey responses by location or category for individual analysis
Creating per-team budget files from a single consolidated spreadsheet

How to split Excel files

01

Drop your file

Select a .xlsx or .csv file to split

02

Pick the split column(s)

Choose one or more columns to group by

03

Download results

Get files per unique value or a single file with multiple sheets

Your files never leave your browser

Your files never touch our servers

Excel Splitter runs entirely in your browser. There are no servers receiving your files - we literally cannot see what you split. Close the tab and everything is gone.

Frequently asked questions

Are my Excel files uploaded to a server?+

No. Everything runs in your browser. Your files never leave your device and are never sent to any server.

How many files can it split into?+

As many as there are unique values in your chosen column - one output file or sheet per value.

Can I split by multiple columns at once?+

Yes - check multiple columns and the tool will split by every unique combination, like Region + Year.

What's the difference between separate files and multiple sheets?+

Separate files gives you a ZIP archive with one .xlsx per group. Multiple sheets puts all groups into one .xlsx file, each as its own sheet.

Does it work with CSV files?+

Yes, it supports both .xlsx and .csv files.

Is there a file size limit?+

No strict limit - processing happens in your browser so performance depends on your device memory.

Is Excel Splitter free?+

Yes, free for 5 uses per month with no signup. Upgrade to Pro for unlimited uses at €10/month.

Related tools

Spreadsheets

Excel Merger

Merge multiple Excel or CSV files - stack rows on top of each other, or join by a shared key column.

Use tool
Spreadsheets

Excel Change Tracker

Find rows that were added, removed, or changed between two spreadsheet versions.

Use tool
Spreadsheets

Excel Filter & Export

Filter rows by one or more conditions - equals, contains, greater than, and more - then download the results.

Use tool
Spreadsheets

Formula Stripper

Replace all formulas with their computed values across every sheet - like Paste Special → Values for the whole file.

Use tool