Data & CSV
CSV rank and percentile
Rank rows with clear tie rules and retain the original record order.
A clear answer. Here’s how.
Computes competition, dense or average-position ranks from finite numeric cells. Also appends numeric-value percentile rank using average tie positions: 100 × (average zero-based ascending position)/(N−1), with singleton 100. Percentile is independent of chosen ranking direction. Blank values are errors. Original record order is retained and two unique output columns are required.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Your CSV
ID,Name,Team,Amount,Date 001,Ada,Design,120,2026-01-05 002,Sam,Writing,80,2026-01-06 003,Jo,Design,150,2026-01-07
- Column separator
- Comma
- Value column
- Amount
- Tie ranking
- Competition: 1, 1, 3
- Rank direction
- Largest value ranks first
- New rank heading
- Rank
Example result
| ID | Name | Team | Amount | Date | Rank | Percentile rank (%) |
|---|---|---|---|---|---|---|
| 001 | Ada | Design | 120 | 2026-01-05 | 2 | 50 |
| 002 | Sam | Writing | 80 | 2026-01-06 | 3 | 0 |
| 003 | Jo | Design | 150 | 2026-01-07 | 1 | 100 |
Original row order retained. Percentile rank always measures numeric value from low to high using average tie position; singleton = 100.