Skip to content
Convertto

CSV Analyser

Profile a CSV: column types, missing values, ranges, distinct counts and outliers.

A CSV analyser profiles each column: its inferred type, how many values are missing, how many are distinct, the range or spread, and example values. It also flags data quality problems — ragged rows, constant columns, columns that are mostly empty, and exact duplicate rows.

Runs in your browser
Privacy
Runs entirely in your browser — nothing is uploaded
Cost
Free, unlimited, no sign-up

Frequently asked questions

What does a ragged row mean?

A row with a different number of fields from the header, which almost always means an unquoted delimiter inside a value. A field containing "Smith, John" must be quoted or the comma splits it into two columns.

Why does my CSV open wrongly in Excel?

Excel picks its delimiter from your regional settings, so a comma-separated file opens as one column in locales that expect semicolons. Exporting as TSV avoids the problem entirely.

How to use the csv analyser

  1. 1Enter or paste your csv.
  2. 2Choose the delimiter.
  3. 3Turn "First row is a header" on or off as needed.
  4. 4The result appears immediately — copy or download it.

Embed this tool

Put the working csv analyser on your own site. It runs in your visitors' browsers exactly as it does here — free, no account, nothing uploaded.

Share this tool

Related tools

CSV Column ExtractorPull selected columns out of a CSV by name or position, and reorder them.CSV Duplicate RemoverRemove duplicate rows from a CSV, matching on every column or just a key you choose.CSV Merger & JoinerJoin two CSV files on a shared key, or stack them, with inner, left and outer joins.CSV SplitterSplit a CSV into chunks of N rows, or into separate files grouped by a column value.CSV to Markdown TableTurn CSV, TSV or pasted spreadsheet data into a Markdown, HTML or reStructuredText table.CSV Viewer & Table ConverterView CSV data as a sortable table and export it as JSON or a Markdown table.

Last updated

More data & format tools