CSV & Data Validation

Validate before you import.
Not after it breaks.

Catch delimiter issues, encoding problems, malformed quotes, column count mismatches, and field length violations before they corrupt your database, CRM, or ERP.

Download Free Trial From $79

10 Validation Rules

Fully Offline

Evidence Pack Output

Auto-Detect Encoding

One bad CSV can ruin your entire import.

Silent encoding corruption

UTF-16, BOM, Latin-1 — encoding mismatches silently corrupt data during import. By the time you notice, the damage is done.

Web validators fail on large files

csvlint is web-only and chokes on anything over a few megabytes. You can't upload sensitive data to a web tool anyway.

No proof validation happened

Compliance requires documenting that validation was performed before import. Excel can't prove anything. You need an evidence pack.

csvkit requires Python

Great for developers, useless for IT admins. No GUI, no evidence pack, no audit output.

Three validation modes

Choose the level of rigor that fits your workflow.

Scan Mode

Auto-detect everything, report all findings. Best for exploratory checks on unknown data files.

Strict Mode

Enforce all rules strictly — any violation is an error. Best for gating imports into production systems.

Schema Mode (Pro+)

Validate against a custom JSON schema defining expected columns, types, and requirements. Best for repeatable validation workflows.

Questions

What encodings does it detect?

UTF-8 (with and without BOM), UTF-16 LE, UTF-16 BE, and ANSI/Latin-1. Detection is automatic — no configuration needed.

What delimiters does it support?

Comma, semicolon, tab, and pipe. Auto-detected from the first 20 lines using coefficient of variation scoring. You can also specify a delimiter manually.

Can I validate TSV and other delimited files?

Yes. The tool handles .csv, .tsv, and .txt files. Delimiter is auto-detected regardless of file extension.

How does schema validation work?

Define a JSON schema file specifying expected column names, whether each column is required, and optional delimiter and header settings. The tool validates your CSV against the schema and reports deviations. Pro+ only.