Rank Rows in Excel Files Online
Add a rank column to Excel files based on any column's values. Choose RANK, DENSE RANK, or ROW NUMBER, with optional partitioning — runs entirely in your browser.
How to rank Rows in Excel files
- Drop your file onto the upload area. It is loaded into the in-browser engine and the first 200 rows are shown.
- Choose the Sort by column and a direction: Highest first (the default) or Lowest first.
- Optionally pick a Partition by column so ranking restarts at 1 in each group, and change the output column name from rank if you like.
- Pick a rank method: RANK (gaps after ties: 1, 1, 3), DENSE RANK (no gaps: 1, 1, 2) or ROW NUMBER (always unique: 1, 2, 3). Click Add Rank Column.
- The rank column is added as the first column. Check the preview, then download in the same format you uploaded.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A warehouse tracks how many orders each picker completed on the early and late shifts. The supervisor wants a leaderboard for each shift, and two early-shift pickers finished level.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| picker | shift | orders_picked |
|---|---|---|
| Maya | Early | 14 |
| Tom | Early | 9 |
| Ines | Early | 14 |
| Kofi | Late | 11 |
| Lena | Late | 7 |
| Raj | Late | 12 |
Settings
- Sort by column: orders_picked
- Direction: Highest first
- Partition by: shift
- Rank method: RANK
- Output column name: rank
Result
| rank | picker | shift | orders_picked |
|---|---|---|---|
| 1 | Maya | Early | 14 |
| 1 | Ines | Early | 14 |
| 3 | Tom | Early | 9 |
| 1 | Raj | Late | 12 |
| 2 | Kofi | Late | 11 |
| 3 | Lena | Late | 7 |
Ranking restarts for each shift. Maya and Ines both picked 14, so both are ranked 1, and RANK skips 2, so Tom is 3. With DENSE RANK Tom would be 2. With ROW NUMBER one of the tied pair would get 2, and which one is not fixed. Here the rows came back grouped by shift, but output row order is not guaranteed. Sort afterwards if order matters.
Working with Excel files
The first sheet is read as the text Excel displays, and this can create ties that are not in the underlying data. A cell holding 14.4 with a 0-decimal number format is read as 14, the same as a cell holding 14.2. Both then share a rank. Set the sort column to General format, or show enough decimals, before uploading if small differences should count.
Columns formatted as currency or with thousands separators are read as text and rank alphabetically, which is rarely what you want. Real date cells load as dates whatever their display style, so they rank in date order. Dates typed as text are different: a column like 1-Jun-26 stays text and ranks as a string. The downloaded workbook has the rank as column A of Sheet1, and every original column moves one place to the right. Excel formulas that pointed at specific columns in the original file will not line up with the new layout.
Frequently Asked Questions
Why do Excel values that look different get the same rank?
Cells are read at their displayed precision. If the number format hides decimals, values like 14.2 and 14.4 both arrive as 14 and tie. Show more decimals or use General format, then upload again.
Is this the same as Excel's RANK.EQ function?
RANK here matches RANK.EQ: ties share a rank and the next rank is skipped. DENSE RANK has no direct Excel equivalent, and this tool can also restart ranks per group.
What is the difference between RANK, DENSE RANK and ROW NUMBER?
RANK gives ties the same number and skips the next ones (1, 1, 3). DENSE RANK gives ties the same number with no gap (1, 1, 2). ROW NUMBER gives every row a unique number (1, 2, 3), and the order between tied rows is not fixed.
Can I rank by more than one column, for example to break ties?
No. The tool ranks by one Sort by column, optionally within one Partition by column. For multi-column ordering, use the SQL Query tool with RANK() OVER (ORDER BY a DESC, b ASC).
How do I keep only the top 3 in each group?
Rank with a partition, then use Filter to keep rows where the rank is 3 or less. Top N per Group does both steps in one go.
Related Tools
Get Top N Rows from Excel Files Online
Extract the top N rows per group from Excel files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Filter Excel Files Online
Filter rows in Excel files by column value, directly in your browser. Your data stays on your device.
Sort Excel Files Online
Sort Excel files by any column, ascending or descending, directly in your browser.
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.
Rank Rows in Parquet Files Online
Add a rank column to Parquet files based on any column's values. Choose RANK, DENSE RANK, or ROW NUMBER, with optional partitioning — runs entirely in your browser.
Rank Rows in JSON Files Online
Add a rank column to JSON files based on any column's values. Choose RANK, DENSE RANK, or ROW NUMBER, with optional partitioning — runs entirely in your browser.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.