Split by column value
Split a CSV by Column Value
Choose one column and create a separate CSV for each value, such as a store, region, or owner. Up to 100 output files are created entirely in your browser.
CSV processing stays in your browser
Your files are not uploaded to a server.
File selection
Drop a CSV file here
or
1 CSV file, up to 50 MiB
Import settings
Change character encoding and header row settings
How it works
Example: split a CSV by values in the Store column
How it works
Example: split a CSV by values in the Store column
Choose the Store column to create separate CSV files for the New York and Chicago rows.
Before splitting
| Order ID | Store | Product |
|---|---|---|
| 1001 | New York | Apples |
| 1002 | Chicago | Oranges |
| 1003 | New York | Bananas |
After splitting
| Created file | Order IDs included |
|---|---|
| New York.csv | 1001, 1003 |
| Chicago.csv | 1002 |
The original CSV is not modified. The split CSV files and a row-count report are saved together in one ZIP file.
Your selected CSV is processed entirely in your browser and is never uploaded to a server.
Split a CSV by column value
Create one CSV for every value in a selected column, such as store, department, or owner, and download a ZIP.
Features
- Choose a column from a list that shows both its number and name. This also works when names repeat or the file has no header.
- Put blank values in a separate file, exclude them, stop processing, or replace them with a value you provide.
How it works
- Choose a CSV and confirm its encoding, delimiter, and header setting.
- Choose the target column and how blank values should be handled.
- Run the split and download the value-based CSV files and row report in a ZIP.
Before you start
- Limits: one 50 MiB CSV and 100 outputs. Processing stops if the column contains more than 100 output groups.
- Characters and reserved names that are unsafe in Windows file names are converted to safe names.
Related tools
Use the standard Split tool for fixed row counts or target file sizes. To count or total each value without creating separate files, use Group and summarize.