Split CSV by column value online free
Turn one CSV into a separate file for each value in a column — one per country, region, store, or category — and download them together as a ZIP.
Split one CSV up to 100 MB entirely in your browser without uploading it. Choose a column and the tool uses each distinct value as the base name for a CSV, makes the name filesystem-safe and unique, applies any filename prefix or suffix you choose, and downloads all outputs together in one ZIP. Empty split values can be skipped; if you keep them, they go into (empty).csv. The tool handles one input file at a time and creates at most 2000 groups. A column where almost every row has a different value, such as an ID, costs much more memory than splitting the same file into a dozen groups, so you may see a memory warning before the split starts.
Split workspace
Pick the column that defines each output file, then review the groups before downloading.
Results will appear here
Add valid data in the workspace above to preview and download the result.
Split one export into per-value files
- 1
Upload the CSV you want to break apart.
- 2
Choose a grouping column such as country, region, store, or category. Avoid near-unique IDs, because every distinct value can become another file.
- 3
Review how many rows land in each group and how empty values are handled before you run the split.
- 4
Decide whether every file repeats the header row.
- 5
Run the split, check the file and skipped-row counts, then download one ZIP containing a CSV per value.
Built for the real task
- One output file per distinct value
- Header repeated in every file
- Filesystem-safe filenames
- Single ZIP download
See the transformation
One file per value, ready to send
Turn one sales file into a separate CSV for each country, with headers kept in every file.
Browser limits
Files are limited to 100 MB to protect browser stability, especially on phones. Processing stays on this device.
Turn one CSV into a separate file for each value in a column — one per country, region, store, or category — and download them together as a ZIP.
The selected file is not uploaded to Nablyx.
No. This tool reads and transforms the file locally in your browser.
Common uses
- One output file per distinct value
- Header repeated in every file
- Filesystem-safe filenames
- Single ZIP download
Related tools
Continue with a related Nablyx tool.
- Split large CSV files online freeSplit one large CSV by row count, maximum file size, or a target number of balanced parts, then download every part in one ZIP.
- Clean and fix CSV files — no uploadRepair common CSV problems including wrong delimiters, uneven rows, empty lines, whitespace, BOM markers, and duplicate headers.
- Remove duplicate CSV rows online freeChoose the columns that define a duplicate, preview the cleanup, and download both the cleaned CSV and removed rows.
- CSV column mapper and renamerRename, reorder, and remove CSV columns before importing data into a CRM, store, database, or accounting system — without uploading your file.
Ready to work on your file?
Return to the workspace and process it locally.