# Data Profiler

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

Page: https://datautility.in/data-profiler
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

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

## How to use the Data Profiler

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

## What it does

- Health score out of 100
- Column types and missing values
- Duplicates and outliers
- Switch between bar, donut, heatmap, curve and box plot
- Flags likely problems

## Tips

- Missing means empty or blank. Distinct means different values.
- A big gap between mean and median usually means outliers.
- Tick “Only columns with warnings” to find problems fast.

## Example

Input:

```
id,name,age
1,Ada,36
2,Alan,41
```

Output:

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

## 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.

### Is my data uploaded?
No. Everything runs in your browser and nothing is stored.

## Related pages

- [CSV Data Quality Checker](https://datautility.in/check-csv-data-quality): Check a CSV for missing values, duplicates, outliers and wrong types in seconds, and share a report. Free, in your browser.
- [Check a CSV for Duplicates and Blanks](https://datautility.in/check-csv-for-duplicates-and-blanks): Find duplicate rows, empty cells and odd values in a CSV before you use it. See a report per column. Free, in your browser.
- [CSV Data Profiler](https://datautility.in/csv-data-profiler): Profile a CSV in seconds: column types, missing values, duplicates, outliers and distributions, with a shareable report. Free, in your browser.
- [Open a Large CSV File Online](https://datautility.in/open-large-csv-file-online): Open and explore a CSV too big for Excel: see rows and columns, filter with SQL and export. Works for 500 MB and more, in your browser.
- [CSV Viewer Online](https://datautility.in/csv-viewer-online): Open a CSV file online and see its rows, column types, blanks and duplicates at a glance. Free, private, no upload.
- [Data Profiler Online](https://datautility.in/data-profiler-online): Profile a CSV, Excel, JSON or Parquet file online: rows, types, missing values, duplicates and statistics per column. Free, private, large files too.

## Topic guides

- [Data Cleaning Guides and Free Tools](https://datautility.in/guides/data-cleaning)

## Guides

- [Data Profiler: Check Data Quality Before You Use It](https://datautility.in/blog/data-profiler-check-data-quality)
- [Password-Protected Data Reports: Share a Locked HTML File](https://datautility.in/blog/password-protected-data-profiler-reports)
- [Data Quality Checks Before You Run a Backtest](https://datautility.in/blog/data-quality-checks-before-backtest)
- [Clean Your Dataset Before Training a Machine Learning Model](https://datautility.in/blog/clean-data-before-training-ml-model)

Open the tool: https://datautility.in/data-profiler
