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.
- Load your data
- Read the overview
- Review each column
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
Browse by topic
- dbt Project Visualizer and dbt Lineage Guides
- Avro Guides and Free Avro Tools
- Snowflake, BigQuery, Databricks and dbt Tools
- Export and Share Data Transformations as SQL, pandas and PySpark
- Offline and Private Data Tools
- Parquet Guides and Free Parquet Tools
- CSV Guides and Free CSV Tools
- JSON Guides and Free JSON Tools
- Excel Guides and Free Excel Tools
- Data Privacy Guides and Free Tools
- Test Data Guides and Free Generators
- Data Cleaning Guides and Free Tools
- AI Data Tools and Guides
- Extract Data from Screenshots and APIs
- Data Lineage and Audit Trail Guides
- File Format Guides and Free Tools
Who uses Data Utility
- Free Data Tools for Marketing Lists
- Free Data Tools for Finance and Accounting Exports
- Free Data Tools for Developers
- Free Data Tools for Data Analysts
- Free Data Tools for Small Business
- Data Tools for Quant Developers and Finance Teams
- Test Data Tools for QA Engineers
- Free Data Tools for Data Engineers
- Free Data Tools for Students and Educators
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
- CSV Data Quality Checker: 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: 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: 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: 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: Open a CSV file online and see its rows, column types, blanks and duplicates at a glance. Free, private, no upload.
- 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.