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.
About this tool
Add a rank column to a CSV file using rank(), dense_rank(), row_number(), or percent_rank(). Optionally partition by a group column so rankings restart per group, and choose any column as the sort key. A common step in analytics before filtering to top performers or computing percentile bands. All processing happens locally in your browser.
Frequently Asked Questions
What ranking methods does the CSV rank tool support?
rank() assigns the same rank to tied values and skips subsequent ranks (1, 1, 3). dense_rank() assigns the same rank to ties with no gaps (1, 1, 2). row_number() assigns unique sequential numbers with ties broken arbitrarily. percent_rank() returns a fractional rank from 0.0 to 1.0.
Can I rank rows within groups in a CSV file?
Yes. Set a Partition By column and the ranking restarts from 1 for each unique group value. For example, ranking sales amounts partitioned by region gives each region its own independent 1st, 2nd, 3rd place.
Does the sort order affect rankings in a CSV file?
Yes. Set an Order By column and choose ascending or descending. Rank 1 goes to the smallest value in ascending order or the largest in descending order. Without an Order By column, rankings are based on physical row storage order, which is usually not meaningful.
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
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.
Search Text in CSV Files Online
Search for text across all string columns in CSV files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.