# 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.

**URL:** https://convertto.tech/t/csv-analyser
**Category:** Data & Format Tools (https://convertto.tech/c/data-tools)
**Privacy:** Runs entirely in the browser; no upload
**Cost:** Free, no sign-up
**Last updated:** 2026-08-01

## Key facts

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

## How to use

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

## FAQ

### 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.

## Related tools

- [CSV Column Extractor](https://convertto.tech/t/csv-column-extractor): Pull selected columns out of a CSV by name or position, and reorder them.
- [CSV Duplicate Remover](https://convertto.tech/t/csv-deduplicator): Remove duplicate rows from a CSV, matching on every column or just a key you choose.
- [CSV Merger & Joiner](https://convertto.tech/t/csv-merger): Join two CSV files on a shared key, or stack them, with inner, left and outer joins.
- [CSV Splitter](https://convertto.tech/t/csv-splitter): Split a CSV into chunks of N rows, or into separate files grouped by a column value.
- [CSV to Markdown Table](https://convertto.tech/t/table-to-markdown): Turn CSV, TSV or pasted spreadsheet data into a Markdown, HTML or reStructuredText table.
- [CSV Viewer & Table Converter](https://convertto.tech/t/csv-viewer): View CSV data as a sortable table and export it as JSON or a Markdown table.
- [Data Format Converter](https://convertto.tech/t/data-format-converter): Convert between JSON, YAML, XML, CSV, TSV and TOML in any direction, locally in your browser.
- [Excel to CSV Converter](https://convertto.tech/t/excel-to-csv): Export Excel sheets to properly quoted CSV.
- [Random Person Generator](https://convertto.tech/t/sample-person-generator): Generate complete fake personas — name, email, address, phone, job, company, bio and avatar.