Skip to main content

locacsv.comSplit a CSV by Column Number or Header Name

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 MiB 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 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, or Taiwan, 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.