CSV Column Splitter

Split one CSV into two CSV files by choosing which columns go to which output. Paste or upload CSV, select columns, then copy or download both results. Fast, free, and runs entirely in your browser.

Paste CSV Clear

Or upload a CSV file

In your browser · Up to 200 MB (50+ MB may feel slow)

Options First row is a header

Column names will appear here after CSV is loaded.

Where do selected columns go? A B

Results

Output A

Download CSV

Output B

Download CSV

Files are processed entirely in your browser and are never uploaded to any server.

How it works

How to split a CSV by columns

Upload your CSV, choose which columns to split, and download two separate CSV files. Everything runs in your browser with no uploads or data leaving your device.

Upload or paste your CSV file

Paste your CSV data or upload a file. The first row should contain your column headers.

Choose columns to split into a new CSV

Select the columns you want in one output file. The remaining columns will automatically go into the second CSV.

Download both CSV files

Split the data and download each output as a separate CSV, or copy them to your clipboard.

FAQ

CSV Column Splitter Questions

How do I split specific columns from a CSV file?

Paste your CSV or upload a file, enable “header row” if your file has column names, then select the columns you want to extract. Click “Split Columns” to generate two outputs: one with your selected columns and one with the remaining data.

Can I extract columns from a CSV without Excel?

Yes. This tool runs entirely in your browser and lets you split columns instantly without Excel, Google Sheets, or any software installation.

What happens to the header row when splitting?

If “First row is a header” is enabled, the selected columns keep their original column names in the output. The remaining columns also retain their headers. If disabled, columns are treated by position (Column 1, Column 2, etc.).

Does this tool keep my data private?

Yes. All processing happens locally in your browser. Your CSV data is not uploaded or stored anywhere.

Can I download both split CSV files separately?

Yes. Each result (selected columns and remaining columns) has its own download button, so you can save them as separate CSV files.

What if I select all or none of the columns?

If you select all columns, one output will contain the full dataset and the other will be empty. If you select none, the opposite occurs. The tool will still generate valid CSV outputs in both cases.

Will this work with large CSV files?

It supports moderately large files in the browser. Performance depends on your device and browser, but typical datasets (thousands of rows) work smoothly.

Does it handle commas inside quoted values correctly?

Yes. The parser respects standard CSV formatting, including quoted values, commas inside quotes, and escaped characters.