CSV and Excel data profiler
csv_profileProfile a CSV, TSV, XLSX or JSON table: row and column counts plus type, nulls, distinct values, min, max and samples for every column. Cost: 1 credit per call. File input (file): base64 string, data: URI or {"url": "https://..."}. Output: JSON. {rows, cols, columns: [{name, inferred_type, null_count, distinct_count, distinct_capped, min, max, sample}]}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | The table: base64 string (or data: URI) or {"url": "https://..."}. Up to 10 MB. | |
| from | No | Source format. Omit to auto-detect. | |
| sheet | No | xlsx input: sheet name, or 0-based sheet index (default: the first sheet). | |
| header | No | The first row holds column names. false: columns are named col1, col2, ... | |
| encoding | No | Text encoding of csv/tsv/json input (utf-8 falls back to cp1252). | utf-8 |
| max_rows | No | Reject inputs with more data rows than this (413). | |
| delimiter | No | csv input: field delimiter (default: detected among , ; tab |). |