CSV tool
Remove empty columns from a CSV
Exports often include a spare column that never got a value. CleanCSV lists those columns and waits for you to confirm before they disappear.
Drop a CSV here
Comma, semicolon, tab, or pipe. Quotes, commas, and line breaks inside a cell stay intact. The file is read here and is not saved on the server.
Up to 32 MB. Files over 8.0 MB ask before parsing.
A header does not make a column full
A column is empty when every data cell is blank or spaces. The header can still say Unused, or it can be blank. Both are listed by name in the preview. Columns that have any real value stay, and their cells stay on the same header.
If every column is empty, the operation refuses. That usually means the delimiter is wrong and the grid is not the table you think it is. Switch delimiter and look again. You can also delete or rename individual columns in the column editor, which is a separate preview.
Questions about this tool
Related
- Remove empty rows — Find CSV rows whose cells are blank or only spaces, preview them, and delete those rows without touching the rest.
- CSV validator — Check a CSV for parse errors, ragged rows, blank headers, duplicate headers, encoding issues, and formula-like cells.
- All CSV tools — Pick a CSV tool for duplicates, empty rows, empty columns, whitespace, viewing, validation, or TSV export. All of them run locally.