Data Profiler
Upload or paste a CSV file and get an instant per-column profile: an inferred data type (number, boolean, date-like, or string), how many values are null or empty, how many unique values exist, min/max/mean for numeric columns, and the five most frequent values for everything else. It's the first thing worth doing before importing unfamiliar data into a database or analysis tool.
Reviewed by Vincenzo Manto, Founder & Lead Developer · Last updated September 27, 2026
How it works
- 1
Paste your CSV text or upload a .csv file (first row must be the header).
- 2
Each column is analyzed instantly and shown as one row in the profile table.
- 3
Check the inferred type, null/unique counts, and numeric stats where applicable.
- 4
Review the top 5 most frequent values for categorical or text columns.
The first step before trusting any dataset
Before you build a chart, run a query, or import data into a system that expects clean types, it helps to know what you're actually working with. A column-by-column profile catches surprises early, like a numeric column secretly full of text, a date field with inconsistent formats, or an ID column that isn't actually unique.
Understand categorical columns at a glance
For non-numeric columns, the five most common values are often more useful than any single statistic. They tell you right away whether a column is a small clean set of categories, a messy free-text field, or something in between.
Frequently asked questions
How does the tool infer a column's data type?
It checks every non-empty value in a column: if all of them parse as numbers it's typed as number, if all match true/false it's boolean, if all match a common date pattern (like YYYY-MM-DD, optionally with a time) it's date, and otherwise it's treated as string.
What counts as a null or empty value?
Any field that is empty or contains only whitespace after trimming is counted as null/empty for that column, and excluded from numeric min/max/mean calculations.
Why do I only see min/max/mean for some columns?
Those statistics only make sense for columns inferred as numeric, so that's the only place they appear. Text, boolean, and date columns show their most frequent values instead.
How many top values are shown per column?
Up to five, ranked by how often each exact value appears in that column, most frequent first.
Is my CSV data sent to a server for profiling?
No. All parsing and profiling logic runs locally in your browser with JavaScript - your file never leaves your device.