CSV Profiler - Understand a File Before You Trust It
Someone hands you a CSV and the first question is always 'what is actually in here?' The profiler answers it in one paste.
How to use the CSV Profiler
- Paste your CSV with its header row.
- Click Profile this CSV.
- Read the per-column table: type, empties, uniques, min/max, top values.
- Use it to spot dirty data - mixed types, unexpected blanks, near-duplicate categories - before importing.
How it works
Types are guessed by scanning every value with the same rules as our CSV to SQL converter: integers, decimals, booleans and ISO dates are recognized, and a mixed column falls back to text - which is itself a useful warning. Unique counts and top values expose category problems instantly (a city column with 900 uniques for 1,000 rows is not a category). Numeric min/max only appears for numeric columns; a text column shows its top values instead.
Frequently Asked Questions
Is this tool free?
Yes - completely free, no sign-up.
How accurate is the type guessing?
It is a scan of the actual values, so it reflects your data - a column of '001' codes guesses integer, which is why the top-values column is shown alongside for a sanity check.
What counts as empty?
A cell with nothing in it (or nothing after the CSV parser reads it). Spaces alone count as a value - trim first with the Dedupe & Cleaner if that matters.
Is my data uploaded?
No. Profiling runs 100% in your browser.
Related Developer Tools
CSV to JSON Converter
Convert CSV to a JSON array of objects - a real parser that handles quoted commas and escaped quotes.
CSV Viewer & Editor
Load CSV into an editable table grid - edit cells, sort columns, add rows and download.
CSV Dedupe & Cleaner
Remove duplicate CSV rows by whole row or key columns, with before/after counts.