CSV type profiler
Open CSV type profiler 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-type-profiler",
"category": "data-tools",
"built": true,
"requirements": "Leading-zero codes stay text. The most frequent nonempty observed type wins; tied types are mixed. The result describes this sample, not a permanent database schema. 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"
]
}
],
"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. Infer the dominant nonempty type per column and locate exceptions. Ties are mixed; leading-zero codes remain text. Dates use YYYY-MM-DD and booleans use lowercase true/false. Inference describes this sample, not every possible future value.",
"experience": {
"automatic": true,
"single": false,
"inputMaxLength": 1000000,
"inputMode": "text",
"label": "CSV data",
"placeholder": "code,amount\n001,10\n002,11\n003,oops",
"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
Find the dominant type of each CSV column and locate the records that do not fit.
How to use CSV type profiler
- Paste a CSV with unique column names.
- Review inferred types, empty counts and the record numbers of exceptions.
- Download the JSON report for your cleanup workflow.
Useful next steps
Prepare the source
Paste a CSV with unique column names.
Choose the matching rules
Review inferred types, empty counts and the record numbers of exceptions.
Review and keep the result
Download the JSON report for your cleanup workflow. Leading-zero codes stay text. The most frequent nonempty observed type wins; tied types are mixed. The result describes this sample, not a permanent database schema.