CSVCSV GUIDE
Home›CSV Data Repair Tool
CSV REPAIR TOOL

CSV Data Repair Tool

Columns shifted, dates in five different formats, mojibake in the middle of a name — paste the file as it is and this tool finds the damage and repairs it.

Free diagnosticsIn-browserNo signupAI instructions
Diagnose and repair broken CSVrule fixes run locally

Ask AI in plain language (beta)

e.g. “split the address column into prefecture and city”, “drop honorifics”, “add a phone number column”

Up to 200 rows / 60,000 characters per run. Anything larger should go through the Repair button above (rule-based, no network, no row limit). In AI mode your CSV is sent to an LLM through our server — do not use it for confidential data.

How to use it (3 steps)

  1. Paste the broken CSVPaste it exactly as it is, or choose the file. Nothing needs cleaning up first.
  2. Run the diagnosisPress Diagnose to see what is wrong and how many rows are affected: mixed delimiters, uneven columns, unbalanced quotes and so on.
  3. Repair and downloadTick the fixes you want, press Repair, check the result, then download the cleaned CSV.

What makes it different

Mixed delimiters

A file that mixes commas and semicolons is normalised against the dominant delimiter.

Uneven column counts

Rows with too few columns get padded, rows with too many are trimmed, so the table lines up again.

Quote repair

Values that contain a delimiter or a line break but were never quoted get wrapped correctly.

Normalise formats

Full-width to half-width characters, trimming, dates unified to YYYY-MM-DD, and European decimals such as 1.234,56 converted.

Mojibake detection

Flags the classic broken patterns (é, �, 縺, 繧) and reports which rows are affected.

AI instructions

Describe what you want in plain language — “split the address into prefecture and city” — and the AI turns it into a repair plan.

Frequently asked questions

Does it overwrite my original file?
No. Your input stays untouched and the repaired data is offered as a separate download.
What kind of damage does it handle?
Mixed delimiters, inconsistent column counts, unbalanced quotes, full-width characters, stray whitespace, mixed date formats, European decimals, and mojibake detection.
Do I need the AI mode?
No. Every rule-based fix runs locally in your browser. The AI is only used when you want to describe a change in words.
Is it safe to paste confidential data?
Diagnosis and rule-based repair never leave your browser. Only if you use the AI instruction panel is the relevant data sent to the language model.
Will it restore garbled text automatically?
It detects and reports mojibake. Restoring it requires guessing the original encoding, which the dedicated garbled-text tool does.