About Select CSV columns
Select CSV columns online when a destination needs only part of an exported table. Use the header checklist to remove unwanted columns from CSV before converting the result to JSON or TSV. Retained columns follow their source order, and retained cell text stays intact except when spreadsheet formula protection adds an apostrophe.
How to keep selected columns in a CSV file
- Paste or import UTF-8 CSV content and confirm the input delimiter.
- Select the column headers to keep and review formula-cell protection.
- Select Process, inspect the retained fields, and download selected-columns.csv or continue to CSV to JSON.
A practical example
- Input
id,name,internal 1,Ada,review 2,Lin,draft
- Result
id,name 1,Ada 2,Lin
Keeping id and name removes internal. Row order and the original order of the retained columns stay the same.
Supported input and limitations
- Input is limited to 5 MB, 100,000 data rows, 1,000 columns, and 1,000,000 data cells. Header names must be nonempty and unique, and all records must match the header width.
- At least one column must be selected. This tool does not rename, rearrange, calculate, or filter rows. Output is comma-separated CSV; blank records are skipped and formula protection can change risky cell text.
Processing happens on your device. Read about local processing and optional workspace recovery.
Frequently asked questions
Can I select a CSV column whose name contains a comma?
Yes. Quoted headers are parsed as complete names and appear in the checklist. Select the displayed header rather than typing a comma-separated list.
Does selecting CSV columns change the row order?
No. Records remain in their source order and selected columns keep their source order. All columns starts with the full table; uncheck the fields you do not need.