A worked example, rendered from real sample data. Sign in to run the tool on your own input.
name:string
email:email
age:number
active:boolean
---
name,email,age,active
Alice,alice@test.com,30,true
Bob,not-an-email,abc,maybe═══ Summary ═══
Data rows: 2
Rows passing: 1 (50%)
Rows failing: 1
Cell failures: 3
Delimiter: ,
Schema columns: 4 | CSV columns: 4
✗ The file does not satisfy the schema
═══ Schema ═══
name: string, required
email: email, required
age: number, required
active: boolean, required
═══ Failures by column ═══
email: 1 failure (50% of rows)
age: 1 failure (50% of rows)
active: 1 failure (50% of rows)
═══ Failures (3) ═══
✗ Row 2 (line 3), column 2 "email": not a valid email address — got "not-an-email"
✗ Row 2 (line 3), column 3 "age": expected a number — got "abc"
✗ Row 2 (line 3), column 4 "active": expected true/false, 1/0 or yes/no — got "maybe"
═══ Notes ═══
ℹ Row numbers count data rows; the line number counts the header row too, so it matches your editor.
ℹ Empty cells only fail when the column is required — mark a column optional to allow blanks.
Validate CSV data against a column schema definition. Part of the DevTools Surf developer suite. Browse more tools in the Data / SQL collection.