Data Profiler & Health Check

Instantly profile your CSV or Excel data: types, blanks, uniques, stats and a quality score.

100% private. Everything runs in your browser. Your data never leaves your device.

Data Profiler

What does this tool do?

This tool profiles your CSV or Excel data and produces an instant data health check: for every column it reports the detected type, number of blanks, unique values, most common value, and for numbers the min, max, and average. It also flags duplicate rows and gives an overall completeness score, all in your browser.

How to use Data Profiler & Health Check - Free Online Tool

  1. Upload a CSV or Excel file, or paste data (or click "Try with sample data").
  2. The profiler analyzes every column instantly.
  3. Review per-column type, blanks, uniques, and statistics.
  4. Use the findings to clean your data with the related tools.

Example

Profiling a small table:

Before

Age City
30 Delhi
Delhi
45 Pune

After

Column Insight
Age number, 1 blank, min 30 max 45
City text, 2 unique, top: Delhi

Each column is summarized with type and stats.

Excel formula alternative

Prefer a formula? You can achieve a similar result with manual analysis:

COUNTBLANK, COUNTA, MIN, MAX, AVERAGE per column

Profiling manually means many formulas per column. This tool does the whole health check in one click.

When should I use this tool?

Auditing a dataset before analysis
Spotting blanks and data quality issues
Understanding an unfamiliar file
Checking column types before import
Finding duplicates and outliers
Documenting a data source

Frequently Asked Questions

Per column: detected type, count of blanks, unique values, most common value, and for numeric columns the min, max, and average. Plus duplicate rows and an overall completeness score.

No. Profiling runs entirely in your browser, so even sensitive data stays on your device.

CSV and Excel files, or pasted CSV/tab-separated data.

Typical business files are handled comfortably; very large files depend on your device memory.

Yes, completely free with no signup.

It is the percentage of non-blank cells across the whole dataset, giving a quick sense of data quality.

Related tools

Count Unique Values
Find Duplicates
Remove Duplicates
CSV Viewer
Remove Blank Rows/Columns

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator