How to use this office tool
- Choose a spreadsheet, worksheet, and header row.
- Build the percentile table for all detected numeric columns.
- Review sample counts and download the XLSX summary.
#242 · Table Analysis & Summaries Tool
Spreadsheet Percentile Table
Calculate a practical percentile table for numeric spreadsheet columns, including minimum, quartiles, median, selected percentiles, and maximum.
Office File Tool
One spreadsheetrow
rows
Ad space
What this tool does
The analyzer finds numeric columns in the selected worksheet and generates a new XLSX summary using an inclusive, linearly interpolated percentile method.
Numeric column values → sorted samples → interpolated percentile table
Blank cells, nonnumeric text, and formulas without stored numeric results are excluded from percentile calculations.
Supported formats
Files are processed locally. XLSX and XLS workbooks are read with SheetJS; CSV and TSV files are parsed with delimiter-aware handling. Advanced Excel features may not be preserved in generated files.
| Format | Support |
|---|---|
| XLSX / XLS | Read workbook values and formulas |
| CSV / TSV | Read delimited rows |
| Output | New downloadable file or report |
Tips for better results
- Work from a backup when the source workbook is important.
- Keep identifiers such as ZIP codes and account codes stored as text.
- Review the bounded preview and downloaded result before replacing any business workflow.
FAQ
Which percentile method is used?
The table uses an inclusive linear interpolation method over sorted numeric values.
Are blank and text cells included?
No. Only finite numeric values and stored numeric formula results contribute to the calculations.
Can I calculate percentiles for several columns?
Yes. Every column with at least one numeric value receives its own summary row.
Why might Excel show a slightly different percentile?
Different applications may use inclusive, exclusive, or nearest-rank definitions, especially with small samples.
Which statistics are included?
The output includes count, minimum, 5th, 10th, 25th, 50th, 75th, 90th, 95th percentiles, and maximum.
Related office tools
Processing details
| Stage | Action |
|---|---|
| Input | One spreadsheet |
| Privacy | Local browser processing |
| Result | New downloadable output |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all