CSV check & repair
Find quoting errors and uneven records, check the delimiter and encoding, then export a UTF-8 CSV with explicit settings.
- 01 Add data
- 02 Review
- 03 Export
Start with your source.
Encoding applies to selected files. Pasted text is already decoded by your browser.
Add a file, paste some text, or try the example. Nothing is uploaded.
Review your result
UTF-8 text · CRLF record separators
CSV cannot store spreadsheet column types. Confirm import settings and formula-protected values.
What can a CSV repair actually fix?
This tool changes separators and decodes bytes with the encoding you select. It cannot reconstruct missing characters. Quoting errors identify a record, physical line and field; uneven-record diagnostics show the starting line and expected field count. These are format checks, not a validation of business rules or every CSV dialect.
A record can span several lines
A quoted note containing a line break is still one record. Physical line numbers count CRLF as one line break. Source record numbers include the header, when present. Use both locations to inspect the source without splitting a valid multiline field. If auto detection cannot parse your text, select the delimiter explicitly for a precise quoting error.
Understand CSV quoting → · Clean duplicates and empty records →
Check more than the first few records
The preview displays twenty data records per page and every parsed column. Scroll inside the table for wide files, use Next for later records, or filter a specific column. The source record number is a preview label, never an extra output column. Quoted line breaks belong to a field, so a record can span several physical lines.
Choose All result records to export the complete result, or Only records matching the filter to export all matches across all pages. The current preview page does not determine the download. The header, when enabled, is retained in either export. Zero matches disable a matching export.
What happens to my original file?
The selected file is read locally. Downloads create a new file; the original is not overwritten. Changing input or processing options disables export until you preview again. Clear input releases the tool's current data references.
Can this recover already-missing zeros or characters?
No. Use the original export. Neither encoding changes nor cleaning can infer which characters were lost without a separate source of truth.
Find a guide for your import problem →