Data Profiler

Profile a CSV for column stats, missing values, duplicates, and distributions.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

About this tool

Paste or drop a CSV and get a profile of every column: detected type, missing values, unique count, most frequent values, and for numbers the min, max, mean, median, standard deviation and a histogram. It also counts exact duplicate rows. The file stays on your device.

How to use

1
Step 1
Paste CSV text or drop a.csv file.
2
Step 2
Press Process.
3
Step 3
Read the JSON profile or open the data in Data Lab for charts.

How it works

Types are inferred from the values (string, integer, number and so on). For each column the profile reports non-missing count, missing count and percentage, and unique values. Numeric columns add min, max, mean, median and sample standard deviation (n − 1) plus a histogram. Exact duplicate rows are counted across all columns. Datasets above 100,000 rows are profiled on the first 100,000 and flagged as sampled.

Worked example

A small sales table

Input
region,product,units,revenue North,Widget,10,100 North,Gadget,5,80 South,Widget,7,70 South,Gadget,12,190 East,Widget,3,30 East,Gadget,,45 North,Widget,10,100
Output
rowCount 7, columnCount 4 units: integer, 1 missing (14.29%), min 3, max 12, mean 7.83, median 8.5, std 3.43 revenue: integer, 0 missing, mean 87.86, median 80 region: 3 unique, top North (3) duplicateExactRowCount: 1 (row index 6)
Walkthrough
The empty units cell on row 6 counts as missing. The last row repeats the first exactly, so it is reported as the duplicate (index 6, counting from 0).

Limitations

  • Over 100,000 rows only the first 100,000 are profiled (the result says sampled).
  • Type detection is by value pattern, so ID codes like 00123 may be read as numbers.
  • The result is JSON text, and the tool does not draw charts itself.

Questions

How do I profile a CSV file?
Drop the file or paste the text and press Process. You get type, missing, unique and statistics for each column.
Does it find duplicate rows?
Yes. Rows identical in every column are counted and their zero-based indexes listed.
Is my data uploaded?
No. The profile is computed in your browser.
What delimiter does it support?
The delimiter (comma, semicolon, tab) is detected automatically.

Features

  • Types, missing, unique
  • Numeric summary and histogram
  • Duplicate row count
  • Runs in your browser

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • SQL Tutorial - Full Database Course

    freeCodeCamp.org

    SQL and tabular data sit next to CSV/JSON data tools.

    Watch on YouTube
  • Finding mean, median, and mode

    Khan Academy

    Descriptive stats for quick data summaries.

    Watch on YouTube
  • Data Index

    Math is Fun

    Stats explainers when summarizing columns.

  • RFC 4180 — CSV

    IETF

    Common CSV conventions for parse and convert tools.