Compute Percentiles for Excel Files Online
Compute percentiles, median, MAD, mode, and kurtosis for numeric columns in Excel files directly in your browser. Optionally group by a category column. Results download as CSV — no upload required.
Drop your .xlsx file here
or click to browse — max 50 MB
About this tool
Compute distribution statistics for any numeric column in a Excel 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 Excel 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 Excel 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 Excel 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
Convert CSV to Excel Online
Convert CSV files to Excel format directly in your browser. No upload required — your data never leaves your device.
Convert Parquet to Excel Online
Convert Parquet files to Excel format directly in your browser. No upload required — your data never leaves your device.
Convert JSON to Excel Online
Convert JSON files to Excel format directly in your browser. No upload required — your data never leaves your device.
Convert NDJSON to Excel Online
Convert NDJSON files to Excel format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to Excel Online
Convert TSV files to Excel format directly in your browser. No upload required — your data never leaves your device.