CSV Empty Column Remover

Remove columns whose data cells are all empty, with an explicit option to treat whitespace-only cells as empty.

Processing happens in this browser. Your CSV inputs are not uploaded.

Each input: up to 200,000 characters, 200 unique nonempty headers and 10,000 data rows. Maximum output: two million characters.

Headers do not count as data. Zero, false, null and N/A remain values. Header-only inputs and an all-empty result produce an error.

Preserve mode keeps cell strings. Protection prefixes cells beginning with =, +, - or @ after whitespace with an apostrophe, including negative numbers. This changes values. Quoting and line endings are normalized.

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.