CSV SPLITTER
Split a CSV by Column Number or Header Name
Choose a column to create one CSV per value. Auto-detect UTF-8 or Shift_JIS input, or select CP949, Big5, or GB18030 manually. Choose any of the five encodings independently for output. Files up to 50 MB stay 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 MB
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.