How to Make a Standings Table in Google Sheets

Build a ranking table in Google Sheets from your match results, with a points column, the SORT and RANK functions, and formatting that shows position.

3 min read1 viewsHow to Make a Standings Table in Google Sheets
— · 0 votes
Contents
  1. Set up the points column
  2. Sort rows into rank order
  3. Number the places and add color
  4. Questions about Google Sheets standings
  5. How do I make a ranking table in Google Sheets?
  6. Should I use SORT or RANK for the standings?
  7. How do I handle tied points in a standings table?
  8. Can I pull results from another spreadsheet into the table?

A standings table in Google Sheets turns a list of match results into a ranked table of teams or players. You enter the results, let formulas total each player's points and sort the rows, so the table updates itself when a new score is added. The same sheet can rank a small tournament of friends or a season of games, and it keeps the order clear for everyone reading it.

Set up the points column

Start with one row per player and a points column that adds up what each match result earns. Write the scoring rule in a separate small area of the sheet, such as a win worth a set number of points, so the point value sits in one cell and every formula refers to it. A SUM formula over the result columns fills the points column, and changing a result changes the total. Keep the player name column frozen so it stays visible when the table grows sideways.

Sort rows into rank order

The SORT function builds a ranked copy of your data without disturbing the raw result sheet. Point it at the player and points columns and sort by points in descending order, then add a second sort column such as goal difference for ties. If results live in another spreadsheet, IMPORTRANGE pulls those cells into the standings sheet before sorting. The QUERY function is the other option when you want to select, filter and order the data in one formula.

Number the places and add color

The RANK function returns each player's place from a set of points, so the position number survives a re-sort of the rows. Place RANK beside the sorted names and feed it the player's points and the whole points range. Conditional formatting can then shade the top places or highlight a row whose points changed, which makes movement in the table visible at a glance. Check that formatting rules refer to the right range after rows move.

Questions about Google Sheets standings

How do I make a ranking table in Google Sheets?

A ranking table needs a points column, a sort and a place number. Enter each player's results, total them with a formula, then use SORT on the points or RANK to assign positions. Add a heading row and format the numbers so readers can scan the order quickly.

Should I use SORT or RANK for the standings?

SORT and RANK do different jobs, and a standings table can use both. SORT arranges the rows by points, while RANK gives each player a fixed place number that stays correct when the table is rearranged. Use SORT for the visible order and RANK when you need a place column.

How do I handle tied points in a standings table?

Ties need a tiebreaker column that you add to the sort, such as goal difference or head-to-head results. Give the SORT function that second column and tied players fall into a defined order. RANK still reports the same place for equal points unless you rank on a combined score.

Can I pull results from another spreadsheet into the table?

IMPORTRANGE can bring cells from a separate results spreadsheet into your standings sheet. You grant access once, then wrap the imported range in SORT or QUERY to rank it. Keep the import in its own tab so the raw data and the standings stay separate.

Latest articles