Blog > 13 December, 2021 (last modified: 17 March, 2023)
Step-by-step instructions for creating a leaderboard using Google Sheets, including screenshots. It's actually much easier than you think.
Creating an online leaderboard in Google Sheets is a great way to keep score and motivate any team or group. You can use the sharing function of Google Sheets to "broadcast" your leaderboard to as many people as you want. At the same time you can ensure that only selected individuals can update the information.
Let's look at how to setup a leaderboard and share it using Google Sheets.
To get started, create a new Google Sheet with 3 columns: Rank, Name and Score. See screenshot below.
Note that the rank column is empty and that our scores are not sorted.
The first thing we will do is add a formular to the Rank column to ensure that it always displays a series of numbers
beginning at 1 and then counting up. We'll do this using the
row function. Go to the cell
A2 and enter the following
You'll see that after pressing enter, cell
A2 now contains
2. This is not what we want, because it should say
but it is correct, because we are in the second row 😉. The solution is quick: we alter the formula to say
We now need to copy the formula to all the rows below. Click on the cell you edited and hover your mouse over the square caret, click and drag downwards. It should now look like this:
Next we want to sort the leaderboard so that the highest score is at the top. This requires 2 steps
To freeze, click the "view" entry in the menu, then click on "freeze", then click on "1 row" as shown below:
You should now see a thick grey line under the first row of your table. Now for the sorting.
Go to the header of the column that contains your scores (in our case
C) and click the small triangle. In the resulting
menu select "Sort sheet A-Z". See below:
That's it! Your new leaderboard is now correctly sorted. If you add new players or change players' scores, you'll need to sort again using the step above. Note that you only need to freeze once!
The final step is sharing the leaderboard. You probably want to share the read-only view of the leaderboard, so here are steps for doing that:
You can now copy the link and share it. Here's the link to the leaderboard used in this article.
You can also give editing rights to certain users.
By the way, all of this functionality is also provided by Keepthescore.com but in a much better-looking and easier-to-use package. It allows you to add themes, share your scoreboard online, edit it on mobile, and much else besides.
If you want to cut-and-paste some scores from a Google sheet and create an instant online leaderboard, then you can do that too! Just click here.
Please let us know if you have feedback in the comments below. Bye 👋.