Skip to main content

Organize · browser workspace

Split CSV by Column Value - Separate Files by Category

Split CSV file into multiple files based on column values. Group rows by category. processed locally in your browser.

Quick start

Built for automatically split one file into many based on a specific column.

Everything runs in your browser, so you can test the workflow with sample data when available before using production files.

Output: A new file or report produced locally in your browser.

  1. 1Choose a supported file or use sample data when available.
  2. 2Set the options shown for this workflow.
  3. 3Process the file locally, inspect the result, and download a new copy.
Preparing your private workspace…

How to Split by Column

  1. 1Upload your CSV file
  2. 2Select the column to split by
  3. 3Download ZIP file containing separate CSVs for each unique value

Why Use This Tool?

  • ✓Smart Grouping - Automatically creates one file per unique value
  • ✓Preserves Headers - Each file includes the full header row
  • ✓Batch Output - All files packaged in convenient ZIP
  • ✓No Manual Work - Automates tedious copy-paste tasks
  • ✓Client-Side Processing - Your data never uploaded

Frequently Asked Questions

How are files named?

Files are named based on the column value. For example,if splitting by "Country", you'll get USA.csv, Canada.csv, etc.

What if I have thousands of unique values?

The tool creates one file per unique value. Be aware this could create many files if your column has high cardinality.

Can I split by multiple columns?

Currently, you can split by one column at a time. For complex splitting needs, try the Smart Split tool.