CSV cleaner
Clean delimited data without losing what matters.
Paste text or open one UTF-8 file. Detect the delimiter, preview every requested cleanup, preserve variable-width rows by default, and export CSV or TSV.
- Data stays in this browser
- Original rows stay recoverable
- Spreadsheet-safe export by default
Load data
Paste text or choose one file
Nothing is cleaned automatically. Load the source first, then choose exactly which changes to preview.
CSV, TSV, semicolon-separated and pipe-separated text are supported.
{{ selectedFile ? t('input.fileSelected', { name: selectedFile.name }) : t('input.noFileSelected') }}
One file only. It must be valid UTF-8, with or without a UTF-8 BOM.
Files are decoded strictly as UTF-8. Invalid byte sequences are rejected rather than replaced.
Review source
Loaded data
{{ loadedSourceLabel() }}
{{ detectedMessage }}
{{ overrideMessage }}
{{ t('dataset.raggedWarning', { count: n(currentStats.raggedRows) }) }}
All loaded rows currently have the same width.
Choose changes
Cleaning options
Every destructive option starts off. Preview the result before applying it.
Trim fields; remove truly empty rows; remove duplicates; pad short rows. Selected-column duplicate comparison checks each field separately; it never joins fields into one string, and a missing field is different from an empty field.
Inspect result
Preview
{{ previewResult ? t('preview.hint') : t('preview.currentHint') }}
Proposed changes
- {{ t('preview.trimmed', { count: n(previewResult.changes.trimmedCells) }) }}
- {{ t('preview.emptyRemoved', { count: n(previewResult.changes.emptyRowsRemoved) }) }}
- {{ t('preview.duplicatesRemoved', { count: n(previewResult.changes.duplicateRowsRemoved) }) }}
- {{ t('preview.padded', { count: n(previewResult.changes.paddedCells) }) }}
These options leave the current data unchanged. You can export it as-is or choose different cleaning options.
Marked cells change when this preview is applied.
| Row | {{ columnLabel(column) }} |
|---|---|
| {{ n(previewStartHuman + localIndex) }} | (missing field) (empty field) {{ cellValue(row, column) }} {{ cellChangeLabel(cellChangeType(previewStartHuman - 1 + localIndex, column)) }} |
{{ t('preview.columnLimit', { shown: n(PREVIEW_COLUMN_LIMIT), total: n(activeStats.maxColumns) }) }}
Rows that would be removed
Removed-row previews use the current row numbers before cleaning.
-
{{ t('preview.removedRow', { number: n(item.inputIndex + 1) }) }}{{ removedReason(item) }}
{{ value }}
No rows would be removed.
Export
Create CSV or TSV
Export uses the currently applied data. Quoting is added wherever the selected delimiter, quotes or line breaks require it.
{{ t('export.safeCount', { count: n(currentStats.formulaCells) }) }}
Raw export keeps those values exact. Opening the file in spreadsheet software may interpret them as formulas or commands.