Compute Percentiles for CSV Files Online
Compute percentiles, median, MAD, mode, and kurtosis for numeric columns in CSV files directly in your browser. Optionally group by a category column. Results download as CSV — no upload required.
About this tool
Compute distribution statistics for any numeric column in a CSV file: median (p50), p25, p75, p90, p95, p99, MAD (Median Absolute Deviation), mode, kurtosis, and any custom percentile you specify. Optionally group by a category column to get per-group statistics. The output is a compact summary table ready to download as CSV. This goes beyond the basic sum/avg/min/max of the Aggregate tool — use it when you need to understand the full distribution of a column, spot skew, or calculate SLO targets. Runs locally in your browser.
Frequently Asked Questions
What is the difference between quantile_cont and median in a CSV file?
median() is exactly equivalent to quantile_cont(col, 0.5) — the 50th percentile using linear interpolation. quantile_cont always interpolates between real values if the exact percentile falls between two data points. quantile_disc (discrete) always returns an actual value from the dataset.
What is MAD and when should I use it for CSV data?
MAD stands for Median Absolute Deviation — it measures the spread of the data around the median. It is more robust than standard deviation because it is not affected by extreme outliers. Use it when your data has heavy tails or outliers that would inflate the standard deviation.
Can I compute percentiles per group in a CSV file?
Yes. Set the Group By column and all selected statistics are computed independently within each group. The output has one row per group with all the requested statistics as columns.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Rank Rows in CSV Files Online
Add a rank column to CSV files based on any column's values. Choose RANK, DENSE RANK, or ROW NUMBER, with optional partitioning — runs entirely in your browser.
Add Cumulative Sum to CSV Files Online
Add a running total column to CSV files for any numeric column. Optionally order by a date or sequence column and restart totals per group — no upload required.
Detect Outliers in CSV Files Online
Detect statistical outliers in CSV files directly in your browser. Flag or remove rows where numeric values exceed a chosen number of standard deviations from the mean — no upload required.
Validate Email Addresses in CSV Files Online
Validate email addresses in CSV files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Add Moving Average to CSV Files Online
Add a moving average, rolling sum, rolling min, or rolling max column to CSV files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.