Skip to main content

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.

Files stay on this deviceRuns entirely in your browserFree — no signup

Drop your file here or browse from your device

Accepts CSV, TSV, TXT. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.

How to Use

  1. Upload your CSV file or paste CSV data
  2. Review the summary: rows, columns, duplicates, and empty cells
  3. Inspect the per-column profile — types, counts, ranges, and samples
  4. 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.

Why does a column show a type I did not expect?

Type detection reflects every value in the column, so a single stray entry — a note in a numeric field, or an empty placeholder such as N/A — is enough to make a column read as text. That mismatch is usually the finding, not a mistake: it is exactly what will fail on import.

Is my data private when analyzing CSV files?

The file is parsed and profiled in your browser and its contents are not sent to the app server. As with any website, avoid opening highly sensitive files on a device or browser you do not trust.

Related Tools

CSV Validator & Repair

Validate malformed CSV files, review safe repairs, and prepare a new copy for import

CSV Cleaner

Clean up messy CSV data

CSV Duplicate Remover

Find and remove duplicate rows from CSV files

CSV Row Counter

Count rows, columns, and cells in a CSV file

CSV to Parquet Converter

Convert CSV files to Apache Parquet format in your browser