Free online data tools
Split Your CSV or Excel Data by Column Value
One sheet holding every region, customer or month often needs to become one file per value. Pick the column to split on and this tool writes a separate CSV, a separate Excel file, or a separate sheet for each unique value it finds.
Load your data
Choose your files, then select Load Data to get started.
Your files are processed locally in this tab.
Select one or more files.
Choose your options
Split by which column?
You get one result for each different value in this column. Tick more than one column to split by a combination.
Setting up…
Your file is processed inside this browser tab and is never uploaded.
How it works
- Pick the file you loaded. If it is an Excel file, pick the sheet too.
- Choose whether you want one CSV, one Excel file, or one Excel sheet per value.
- Tick the column to split on. Tick more than one to split on a combination of values.
- Click Split File, then download each result file.
Frequently asked questions
Can I split on more than one column?
Yes. Tick several columns and you get one output per unique combination of their values.
What are the output files named?
Each file is named after the value it holds, so splitting a Region column gives you North.csv, South.csv, and so on.
Are the original rows changed?
No. Rows are grouped and copied out unchanged, including all their other columns.
Other free tools
- Combine Data — Combine data from multiple files or Excel sheets into a single file.
- Merge Data — Merge or join a dataset from two different files on a shared column.
- Compare Data — Compare data from two different files and see exactly what changed.
- Change File Format — Convert data between csv, xlsx, xls, json and html.