Skip to main content
CSV First Aid

CSV Validator — check CSV quality

Before COPY FROM or pd.read_csv(), run this. 14 checks — encoding, BOM, delimiter, quotes, column counts, duplicates, invisible chars — each with the line numbers that triggered it.

Drop your CSV file here

or click to browse

Checks for 14 types of CSV problems.

How it works

  1. 1Drop your CSV file above. It stays in your browser — nothing is uploaded.
  2. 2CSV First Aid runs all 14 diagnostic checks and reports every issue found with severity levels.
  3. 3Review the report. If issues are found, click 'Fix all' to jump to the fixer.

FAQ

What does it check for?

14 checks: encoding, BOM, delimiter, column count, empty rows, duplicates, whitespace, invisible characters, number format, date format, headers, quoting, unnamed index, and line endings.

Is this the same as CSV Lint?

Similar concept, but we check more issue types (14 vs typically 3-5) and all processing is in your browser — no upload.

Related tools

CSV Viewer

A CSV rendered as a real table — zebra rows, a search box, page through 200K rows without ever opening Excel. Encoding and delimiter are figured out from the bytes.

CSV to JSON

CSV in, JSON array out. Headers become the object keys. Works with any delimiter the file uses — comma, semicolon, tab, pipe.

Fix CSV encoding

Seeing é, ü, ö where you expected é, ü, ö? The file was saved in one encoding and read in another. We figure out which one, then convert to UTF-8 so Müller looks like Müller again.