CSV Analyzer — Column Types & Statistics
Profile CSV files: column types, empty cells, unique counts, and min/max stats
Analyze a CSV file before you import, clean, or trust it. Upload the file and get an instant profile: the detected data type of every column (integer, number, date, email, URL, boolean, or text), how many cells are filled or empty, how many values are unique, and the min/max range for numeric and date columns.
It is the fastest way to answer questions like "does this export have blank IDs?", "are all the dates in range?", or "which columns are actually numeric?" — without opening a spreadsheet. Analysis runs entirely in your browser and you can download the column report as CSV for documentation.
Drop your file here or click to upload
Supports CSV, TSV, TXT files up to 100MB
How to Use
- Upload your CSV file or paste CSV data
- Review the summary: rows, columns, duplicates, and empty cells
- Inspect the per-column profile — types, counts, ranges, and samples
- Download the column report as CSV if you need a record
Features
- Automatic column type detection (integer, number, date, email, URL, boolean, text)
- Filled, empty, and unique value counts per column
- Min/max for numeric and date columns, value lengths for text
- Duplicate row detection
- Sample values for every column
- Downloadable column report CSV
- Private by design — your file stays in your browser
Use Cases
- Sanity-check an export before importing it into a database or CRM
- Find columns with missing values or mixed types before analysis
- Document the structure of a dataset for teammates
- Verify an ETL job produced the expected ranges and row counts
Frequently Asked Questions
How does the analyzer detect column types?
Every value in a column is tested against strict patterns; a column is typed integer, number, date, email, URL, or boolean only when all of its non-empty values match. Anything mixed falls back to text — so the type you see is a guarantee, not a guess.
What statistics are shown for each column?
The detected type, filled and empty cell counts, the number of unique values, min and max (numeric range for numbers, earliest/latest for dates, shortest/longest length for text), and up to three sample values.
Can I save the analysis?
Yes — download the per-column report as a CSV file for documentation or comparison after a data fix.
Is CSV Analyzer free to use?
Yes, completely free with no limits. No signup or download required.
Is my data private when analyzing CSV files?
Absolutely. All processing happens in your browser. Your data never leaves your device.