Data Profiler
Profile a CSV for column stats, missing values, duplicates, and distributions.
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
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?
Does it find duplicate rows?
Is my data uploaded?
What delimiter does it support?
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 YouTubeFinding 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.