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
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
CSV validator in three steps
No account, no email, no waiting for an upload.
- STEP 01
Load your CSV
Use a .csv, .tsv, .tab or .txt file.
- STEP 02
Set the basics
Leave the separator on detect, or choose one. Say whether the first row is a header.
- STEP 03
Read the report
Problems are listed by line. A valid file also gives you a clean copy.
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.
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 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
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
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.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends 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.
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.