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.
- Runs on your device
- No sign-up
- Works offline after a visit
0rows
0columns
0%empty cells
0duplicate rows
How to profile every column of a table
- Drop a CSV or Excel file, or paste rows from a spreadsheet.
- Open a column card to see its range, median, outliers and most common values.
- 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.
Reviews
No reviews yet. Be the first.