Data and JSON tools Free · No sign-up · No upload

CSV Validator

Find out why a CSV will not import. The validator lists stray quotes, unclosed fields and rows with the wrong number of columns, each with its line number. Local to your browser.

  • Unlimited runs
  • No data leaves the tab
  • Errors with line numbers
  • Clean copy when valid
Your data
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: CSV → OUT: Report
How was CSV validator?
How it works

CSV validator in three steps

No account, no email, no waiting for an upload.

  1. STEP 01

    Load your CSV

    Use a .csv, .tsv, .tab or .txt file.

  2. STEP 02

    Set the basics

    Leave the separator on detect, or choose one. Say whether the first row is a header.

  3. STEP 03

    Read the report

    Problems are listed by line. A valid file also gives you a clean copy.

What you get

What CSV validator does, and what it doesn't

We'd rather tell you up front than surprise you after the download.

What you get

  • Quote problemsFinds a quoted field that is never closed, text after a closing quote, and a quote inside an unquoted value.
  • Column count checkEvery row is compared with the header (or first row), and rows with too many or too few fields are listed.
  • Warnings tooEmpty or repeated header names and blank lines are flagged as warnings, since they often cause trouble later.
  • A quick summarySee the separator, the number of rows and the number of columns.
  • Sorted by lineErrors appear in line order so you can fix them top to bottom.

Good to know

  • Structure onlyIt checks the shape of the file, not whether the values make sense. A date in the wrong format passes.
  • Long lists are cutAt most 50 wrong-length rows are listed individually, followed by a count of the rest.
  • Fix, then repairAfter correcting quotes, tidy the file with the CSV formatter.
Private by design

Your data never leave your device

The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.

Typical online tool upload

Your device→Their server→Your device

Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.

Mediaextractr no upload

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

When people use CSV validator

Debug a failed import

Find the row that makes a database or CRM reject your file.

Check a vendor export

Confirm a supplied file is consistent before processing it.

Test generated CSV

Validate output from a script or a report job.

Learn CSV rules

See why a quote placed in the middle of a value is a problem.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends on their servers

The usual suspects

Most CSV problems come from quoting. A value that contains the separator, a quote or a line break must be wrapped in quotes, and any quote inside it must be doubled. When that goes wrong, a parser either fails or silently merges rows.

The other big cause is a row with a different number of fields, often from an unquoted comma in a name or address.

How to read the report

Each line starts with the line number where the problem was found. A short list of meanings:

  • 'A quoted field is never closed': a quote was opened and the file ended before it was closed. Search for the first quote at that line.
  • 'Text after a closing quote': a value like "abc"def. Double the inner quote or remove the extra text.
  • 'Fields, expected N': the row has the wrong number of cells.
  • Once the file is valid, view it with the CSV viewer or convert it with CSV to JSON.

Making validation part of your routine

Run a check on every file you receive from another team or system, before it enters an import job. A clean report takes seconds and prevents half-loaded tables. When a vendor sends a file that fails, the line numbers in the report make it easy to send back a precise complaint.

FAQ

Questions, answered

How do I check a CSV for errors?

Paste it and read the report. It lists broken quotes and rows with the wrong number of fields.

Does checking my CSV for errors upload it?

No. The validation pass runs in this browser tab, so the data in your file is never transmitted.

What does 'expected N fields' mean?

The row has a different number of cells from the header. Look for an unquoted separator inside a value.

Does it follow RFC 4180?

Its quoting rules match RFC 4180: values with separators, quotes or line breaks are wrapped, and inner quotes are doubled. It also accepts other separators and LF line endings.

What if my file has no header?

Turn off 'First row is a header'. Rows are compared with the first row.

Is the report readable on a small screen?

Yes. Paste or open the file in a current mobile browser. The report is plain text with line numbers.