Skip to main content

locacsv.comSplit a CSV by Column Value

CSV SPLIT BY 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.

How to useSpecifications & limits

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

Auto-detection covers only UTF-8 and Shift_JIS. For CSV files from mainland China, Korea, Taiwan, or Western Europe, select the matching encoding manually.

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

3 columns · 3 rows
Before splitting
Order IDStoreProduct
1001New YorkApples
1002ChicagoOranges
1003New YorkBananas

After splitting

2 columns · 2 rows
After splitting
Created fileOrder IDs included
New York.csv1001, 1003
Chicago.csv1002
The left table shows the input, and the right table shows the output.

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.