Data Profiler

Profile a dataset for free: column types, missing values, duplicates, distributions and outliers, with a shareable HTML report. Nothing is uploaded.

Quick answer: Get a quick health check of any dataset.

Related: CSV Data Quality Checker · Check a CSV for Duplicates and Blanks · CSV Data Profiler · Open a Large CSV File Online · Data Cleaning Guides and Free Tools

How to use the Data Profiler

Get a quick health check of any dataset.

The Data Profiler gives you a quick health check of a file. It shows the type of each column, missing values, duplicates, outliers and basic statistics such as minimum, maximum, mean and the most common values, with flags for likely problems. Analysts use it before cleaning or loading data, to decide what needs fixing. The report can be downloaded with an optional password.

  1. Load your data
  2. Read the overview
  3. Review each column

Tips

Example

Input: id,name,age 1,Ada,36 2,Alan,41

Output: age: integer, 0% missing, mean 38.5, min 36, max 41

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

What counts as a duplicate row?

A row identical to an earlier one in every column.

What does the Data Profiler show?

Column types, missing values, duplicates, outliers and basic statistics, so you can judge the quality of a file at a glance. You can download the report, with an optional password.

Related pages

Topic guides

Guides