Analytics builder
Select columns, filter rows, group by a field, aggregate a metric and chart the result.
/analytics
Free · no account · nothing uploaded
CSV data profiler
Drop a CSV and get the shape of it in one pass — what each column really contains, where the gaps are, how the numbers are distributed, and which fields move together.
CSV profiler
Say it the way you would say it to a person. Your words are matched to one of 18 tools by readable rules, and the tool runs right here in your browser. No upload, no account.
This tool runs in your browser and needs JavaScript turned on.
esc
How to use the CSV profiler
- Drop a CSV or TSV file into “Your files”, or paste the table into the message box.
- Type “profile this table”, or ask something specific: “which columns have missing values?”
- Read each column’s inferred type, its blank and unique counts and, for numbers, the minimum, maximum, mean and spread.
- Ask “which columns are correlated?” for a correlation table, and download the profile as JSON.
Things you can type: profile this table which columns are correlated?
Look at the data before you trust it
Every dataset arrives with a story about what it contains, and the story is usually a little wrong. A column typed as a number holds three text values. A field that should never be empty is empty 8% of the time. A category has forty-one distinct values, of which four are spelling variants of the same thing.
Profiling is the cheap step that catches this before it reaches an analysis, a chart or a model. It takes seconds and it changes conclusions.
What the profile covers
- Inferred type per column, with the values that contradict it.
- Null count, unique count and cardinality, so you can tell an identifier from a category at a glance.
- Summary statistics for numeric columns — min, max, mean, and the spread.
- Correlations between numeric columns, and grouped aggregates for any categorical field.
A CSV parser that handles real CSVs
Quoted commas, embedded newlines, escaped quotes and ragged rows are not edge cases — they are what exported data looks like. Splitting on commas produces a file that parses without error and is quietly wrong from the first quoted address onward.
This parser handles them properly, which is the difference between a profile you can act on and one you have to re-check by hand.
Questions
CSV profiler: common questions
How large a CSV can it handle?
It runs in your browser, so the practical limit is your machine’s memory rather than a server quota. Files in the low tens of megabytes profile comfortably on a normal laptop.
Is my file uploaded?
No. The file is read by the page and processed in the tab. There is no server involved, no account, and no copy of your data anywhere but your own machine.
What is the difference between this and the analytics builder?
This one describes the dataset — types, gaps, distributions, correlations. The analytics builder answers questions about it: filter rows, group by a field, aggregate a metric and chart the result.