About the CSV Data Profiler
Before analysing a spreadsheet, you need to know what is in it. Paste or open a CSV and every column is profiled: its type (integer, decimal, date, email, URL, boolean, category or text), how many values are filled or blank, how many are unique, the most common values, and for numbers the minimum, maximum, mean, median, standard deviation and outliers beyond 1.5 × the interquartile range.
A findings list points out blank cells, outliers, duplicate rows and columns that could serve as a unique key, and the full profile can be downloaded as JSON. Your data stays on your device.
How to use the CSV Data Profiler
- Paste a CSV with a header row.
- Read the column profile and findings.
- Download the profile as JSON if needed.
Features
- Automatic type detection
- Blank and unique counts
- Numeric statistics
- Outlier detection (IQR)
- Duplicate rows found
Supported formats
- Plain text
Frequently asked questions
How big a file can it handle?
Tens of thousands of rows work well in a modern browser; very large files may take a few seconds.
Is my text sent anywhere?
No. Everything runs in your browser, so nothing you paste is uploaded or stored.
Added · Last reviewed · Maintained by Sohail Khax · How we test tools