CSV Cleaner help
Clean up a CSV without a spreadsheet. The file is read on your device and the cleaned copy is built there too.
Operations
- Trim whitespace from every cell, and optionally collapse repeated spaces.
- Drop blank rows where every cell is empty, and blank columns that are empty in every data row.
- Remove duplicate rows, optionally ignoring case.
- Fill down copies the value above into a blank cell, per column.
- Find and replace, plain text or a regular expression, across all columns.
- Header case reformats just the first row to lowercase, Title Case, snake_case, or kebab-case.
Steps
- Drop a CSV. The delimiter is auto-detected.
- Tick the operations you want; the preview and the row and column counts update live.
- Download the cleaned CSV.
Notes
- Operations run in the order listed above.
- The preview shows the first 50 rows; the download has all of them.
- Nothing is uploaded.
Everything runs in your browser. Nothing you enter or drop is uploaded.
Back to CSV Cleaner