CSV / TSV Fixer
Normalise CSV/TSV separators, quoting and line endings
About this tool
Normalise CSV/TSV quoting, separators and record endings without changing the cell matrix. Automatic separator detection is a heuristic; choose the input separator explicitly for ambiguous data. Double quotes, escaped double quotes, multiline cells, empty fields and a UTF-8 BOM are supported.
Malformed quotes report their physical line/column and produce no partial output. The tool does not guess missing quotes or repair their contents. A final record ending is preserved. Newlines inside quoted cells remain unchanged. The preview textarea displays LF; copy/download preserves the selected LF/CRLF/CR record endings exactly.
Changes update after a short typing pause; Ctrl/⌘+Enter converts immediately. Processing stays local in a cancellable worker. Open reads UTF-8 CSV/TSV files, up to 8 MiB and 2000000 characters. Imported line endings are kept until the source is edited in the textarea, which uses LF. Entered source/settings are retained locally; generated output is not saved. Limits: 100000 records and 4000000 output characters. Formula-like cell values remain unchanged.