CSV Column Stats
Profile every column of CSV, TSV or PSV data — counts, uniqueness, inferred type and numeric min/max/mean — locally in your browser.
- Runs locally in your browser
- No upload required
Capabilities
- Drag and drop
- Local file intake
Try it
Supported formats
Privacy
Runs entirely in your browser. Your input is never uploaded, stored, or sent to a third party.
Profiled 3 column(s) across 3 row(s).
How it works
- Parsed the delimited text per RFC 4180.
- Counted non-empty, empty and unique values in every column.
- Inferred a conservative type and computed min/max/mean only for numeric columns.
- An all-empty column is labelled empty; no value is invented.
Methodology
- Parse per RFC 4180 and treat each column independently.
- Count total, non-empty, empty and unique values; uniqueness uses the exact trimmed cell text.
- Infer integer/number/boolean/date/text only when every non-empty cell matches; compute min/max/mean only for numeric columns.
Usage
- Paste delimited text or choose a local file.
- Set the delimiter (or auto-detect) and whether the first row is a header.
- Read each column's counts, inferred type and numeric summary.
Examples
These are examples, not current values: they use fixed inputs, while the interactive tool computes live results in your browser.
Profile a mixed table
{
"text": "name,age,active\nAda,36,true\nAlan,41,false\nGrace,\"\",true",
"delimiterMode": "comma",
"delimiter": ",",
"firstRowHeader": true
}Limitations
Conservative typing
A column is typed integer, number, boolean or date only when every non-empty cell matches that shape. Any mismatch falls back to text, so a surprising type is never claimed.
Frequently asked questions
- Are the statistics exact?
- Yes — counts, uniqueness and numeric summaries are computed from the parsed cells; no value is estimated.
- Is my data uploaded?
- No. Profiling runs locally in your browser.
Sources
Send feedback
Tell us if this tool helped, report a problem, or suggest a tool. Only the message you type is sent — never the input you used in the tool.
Was this tool useful?
Prefer to write to us directly? See the contact page.