ZapKit

CSV validator

Find out why an import fails before you upload the file again: every structural problem is listed with its line number.

What is a CSV validator?

A CSV validator checks that a comma-separated file is well formed, so databases, CRMs and analytics tools can read it. Import errors like "unexpected number of columns" usually come from one bad row hidden among thousands, and a validator points straight to it.

Paste or open a file to get a verdict, the detected delimiter, line-ending style and whether a byte order mark is present. Each problem is listed with its line number and a plain explanation, and rows with errors are highlighted in the parsed preview below.

How to use the CSV validator

  1. 1.Paste or open the CSV

    The delimiter is detected automatically.

  2. 2.Read the report

    Errors in red, warnings in amber, each with its line.

  3. 3.Fix and re-check

    Edit in the box until the verdict says valid.

Example: a failed import

A six-line scores file that a database refused:

Line 4
3 fields, but the first row has 4 (missing score)
Line 5
unescaped quotes inside Jo "the pro" Fernandes
Line 6
5 fields: an extra value at the end
Line 7
repeats the header

Four quick fixes and the file imports cleanly.

What counts as valid

The rules follow RFC 4180, the closest thing CSV has to a standard. Every row should have the same number of fields as the first. A field containing the delimiter, a quote or a line break must be wrapped in double quotes, and quotes inside it must be doubled, so Jo "the pro" becomes "Jo ""the pro""".

Warnings cover things that parse but cause trouble: blank or repeated header names, a header row repeated mid-file, spaces around values, characters garbled by the wrong encoding, mixed line endings and empty rows.

Frequently asked questions

What does "text right after a closing quote" mean?

A quote ended the field early. Inner quotes must be doubled.

Is a byte order mark a problem?

Rarely. Excel adds one to UTF-8 files; a few older tools show it as junk at the start.

Can it fix the problems?

Edit the text in the box and watch issues clear, or use the CSV cleaner for spaces and empty rows.

Is my file uploaded?

No. It's checked locally.

More Developer tools