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

Processed entirely in your browser

Options First row is a header

Column names will appear here after CSV is loaded.

Where do selected columns go? A B

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

How it works

How to Split a CSV by Columns

Everything runs in your browser. No account, no software, no data leaving your device.

Paste CSV or upload a file

Paste comma-separated data into the input box or upload a CSV file. Choose whether the first row is a header.

Select columns for one output

Check the columns that should go into Output A (or Output B if you change the option). Use Select all or Clear to adjust quickly.

Split and review

Click Split Columns. Output A and Output B show the two CSVs. Row order and header (if enabled) are preserved.

Copy or download both

Copy or download each output as a separate CSV file.

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.