CSV schema validator
Open CSV schema validator on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.
Tool capabilities
{
"id": "csv-schema-validator",
"category": "data-tools",
"built": true,
"requirements": "Use happytails-csv-contract-v1 with text, integer, decimal, boolean or date types. Numeric bounds are decimal strings. Extra columns are rejected unless allowExtraColumns is true. Optional empty cells skip value checks. Up to 1,000,000 characters, 10,000 data records, 100 columns and 100,000 cells across the sources. Files for multi-source tools are limited to 4,000,000 bytes total. Reports retain at most 500 diagnostic findings and state any omitted count. CSV and JSON outputs are limited to 4,000,000 characters.",
"implementation": {
"fields": [
{
"key": "separator",
"label": "Input CSV separator",
"value": ",",
"type": "select",
"values": [
",",
";",
"\t"
]
},
{
"key": "contract",
"label": "Data contract (JSON)",
"value": "{\n \"format\": \"happytails-csv-contract-v1\",\n \"columns\": [\n {\n \"name\": \"id\",\n \"type\": \"text\",\n \"required\": true,\n \"unique\": true\n },\n {\n \"name\": \"amount\",\n \"type\": \"decimal\",\n \"required\": true,\n \"min\": \"0\"\n }\n ]\n}",
"type": "textarea",
"help": "Types: text, integer, decimal, boolean or date. Optional per-field rules: required, unique, min, max, enum, minLength, maxLength. Numeric bounds are quoted decimal strings. Set allowExtraColumns to true if needed."
}
],
"live": true,
"presentation": "metrics",
"note": "Runs locally on your device. CSV requires unique nonempty headers. Up to 1,000,000 characters, 10,000 data records and 100,000 cells across inputs, with 100 columns. Quoted multiline cells are supported. Each JSON settings field is limited to 100,000 characters. Output files are bounded to 4,000,000 characters. Diagnostic reports contain at most 500 findings and disclose the omitted count. Check an explicit happytails-csv-contract-v1 contract. Every declared column must exist. Empty optional cells skip value constraints. Unique compares exact nonempty strings; lengths count Unicode code points. Numeric arithmetic is exact.",
"experience": {
"automatic": true,
"single": false,
"inputMaxLength": 1000000,
"inputMode": "text",
"label": "CSV data",
"placeholder": "id,amount\nA,10\nA,-1",
"help": "Paste CSV data with unique column headers. Quoted multiline cells are supported. Results update as you type. Up to 1,000,000 characters.",
"helpParts": [
"Paste CSV data with unique column headers. Quoted multiline cells are supported.",
"Results update as you type.",
"Up to 1,000,000 characters."
],
"action": null
},
"mode": "automatic",
"interactive": false
},
"execution": "Browser interface",
"api": null,
"browser_agent": {
"supported": true,
"name": "run_current_tool",
"discovery": "WebMCP on the human page in a supporting browser",
"verification": "See audit/API-AUDIT.md; availability is not verification"
}
}Page guide
Check CSV columns, data types and value constraints against an explicit data contract.
How to use CSV schema validator
- Paste the CSV to validate.
- Define columns and constraints in the displayed JSON contract.
- Review violations by field and data-record number, then download the report.
Useful next steps
Prepare the source
Paste the CSV to validate.
Choose the matching rules
Define columns and constraints in the displayed JSON contract.
Review and keep the result
Review violations by field and data-record number, then download the report. Use happytails-csv-contract-v1 with text, integer, decimal, boolean or date types. Numeric bounds are decimal strings. Extra columns are rejected unless allowExtraColumns is true. Optional empty cells skip value checks.