Remove unused fields from a CSV export
Paste CSV with a header row and at least one data record, then choose Remove empty columns. A column is removed only when every data cell in that column is empty under the selected rule. Header text is not included in the emptiness check. Remaining columns and records preserve their original order.
Example: remove an unused notes column
Load the example with name,notes,score. Both notes fields are empty, so the result contains name and score only. Ada's value of 0 remains because zero is a value, not an empty cell. The output summary reports two columns and two data rows; the header is excluded from the row count.
Empty versus whitespace-only
By default, only the exact empty string counts as empty. A cell containing spaces or tabs keeps its column. Enable Treat whitespace-only cells as empty to remove columns containing only empty strings and whitespace. That option is used solely to decide whether a column remains; it does not trim the values in retained columns.
The strings null, N/A, false and 0 are not treated as missing values. A column with even one nonempty data cell remains. The tool does not remove empty rows, merge repeated columns or infer the meaning of placeholders used by another application.
Errors and safe export
The input must have unique nonempty headers and equal row widths. Supported limits are 200,000 characters, 200 columns and 10,000 data rows. A header-only input is rejected because there are no records to inspect. If every column would be removed, the tool reports that there is no table to export instead of downloading an empty file.
Quoted CSV cells can contain commas or line breaks. Preserve mode keeps the retained cell strings, with normalized quotes and line endings. Optional spreadsheet protection adds apostrophes before formula-like cells, including negative numbers, so it intentionally changes those values. Processing is local to this browser and never modifies the original file.
Use CSV Row Filter to select records, CSV Deduplicator to remove repeated rows, or CSV Column Selector when you want to select fields manually. Input and option edits clear the previous output and download link.





