Runs in your browser

CSV Quote Error Finder

Locate unclosed and bare quotes, then rewrite fields as valid CSV.

Your files never leave your device.

Drop a CSV with quote errors

CSV, TSV, or text. Processed locally — the file is never uploaded.

Try a sample:

How quotes break CSV

A quoted field may contain commas and line breaks. The field ends at the next quote that is not doubled. If that quote is missing, every later row is swallowed. If a quote appears in the middle of an unquoted city name, some parsers abort.

How this fixer works

It parses leniently, records unclosed and bare quotes, then writes a strict CSV: fields that need quoting are wrapped, and interior quotes become two quotes. Multiline comments remain multiline, still quoted.

Example

Malformed input:

id,name
1,"Anne

Repaired:

id,name
1,"Anne"

Limitations

Recovery cannot know where a missing quote should have been if the author intended to close it mid-row. Inspect the preview when the unclosed-quote error points at row 1 and the file has hundreds of lines.

FAQ

What is a bare quote?

A quotation mark inside a field that did not start with a quote. RFC 4180 does not allow it. The fixer treats it as literal text and quotes the field on output.

What happens on an unclosed quote?

The parser consumes the rest of the file as that field and reports the starting row. Re-serializing then writes a closing quote.

Are doubled quotes kept?

Yes. "" inside a quoted field is one quote character and round-trips correctly.

Related tools