CSV

CSV Column Profiler

Profiles each column for inferred type, completeness, distinct values and numeric range.

Loading the tool…

Processing happens locally in your browser. What you paste or load is processed by this page and is not uploaded to a server. Nothing is stored unless you use a control that says it stores something, and you can clear anything this site has kept from the privacy page.

How to use this tool

  1. Paste or open the extract.
  2. Select Profile columns.
  3. Read the distinct and empty counts first — they say the most about the data.

What csv column profiler does

Before you load an unfamiliar extract anywhere, it is worth knowing what is actually in it. This profiler reports, for every column, how many values are present, how many are empty, how many distinct values there are, and whether the values are consistently numeric, consistently boolean or free text.

The distinct count is often the most informative number on the page. A column with one distinct value carries no information; a column whose distinct count equals the row count is a candidate key; a column with a handful of distinct values across thousands of rows is a category that probably belongs in a lookup table. Type inference is deliberately strict — one non-numeric value is enough for a column to be reported as text, because that is the value that will break the load.

Frequently asked questions

Strictly. A column is reported as numeric only if every non-empty value parses as a number, because the single value that does not is the one that will break a load.

A distinct count equal to the row count suggests a candidate key. A count of one means the column carries no information. A small count over many rows means a category that probably belongs in a lookup table.

Yes. An empty field counts towards the empty column and is excluded from the distinct count and from the numeric statistics.

Further reading