# Profile every column of a CSV or Excel file

> Drop a CSV or Excel file and see each column’s type, range, median, most common values and outliers.

Stats for each column of a CSV or Excel file: type, empty cells, median, outliers, top values, date range and duplicate rows. Runs in your browser.

- Tool: [CSV column profiler](https://fixmint.cc/csv-column-profiler)
- Category: [Spreadsheets & data](https://fixmint.cc/spreadsheets)
- Fixes: Need stats for every column
- Runs in the browser: files and text stay on the device, no sign-up, free.

## How to profile every column of a table

1. Drop a CSV or Excel file, or paste rows from a spreadsheet.
2. Open a column card to see its range, median, outliers and most common values.
3. Download the whole profile as JSON or CSV.

## Questions

### How many rows are profiled?

The first 250,000 rows. A bigger file is profiled from those rows, and the page says so. Everything else is read but not counted.

### How are outliers found?

A number is an outlier when it lies below the first quartile minus 1.5 times the interquartile range, or above the third quartile plus that amount. This is the usual box-plot rule.

### How is a column’s type decided?

The same way as the data type checker: the type that most of the first 5,000 rows share. Cells that do not fit that type are left out of the number statistics and counted.

### Does it upload my file?

No. The file is read and profiled in a background worker in your browser, and nothing is sent anywhere.

## Related tools

- [Data type checker](https://fixmint.cc/data-type-checker): Column has mixed formats
- [CSV cleaner](https://fixmint.cc/csv-cleaner): Messy CSV with blanks and copies
- [Pivot table maker](https://fixmint.cc/pivot-table-maker): Totals by group, no Excel
- [Compare spreadsheets](https://fixmint.cc/compare-spreadsheets): Spot what changed between files