How to create a leaderboard using Microsoft Excel

Using Microsoft Excel to create a leaderboard is not hard at all if you follow these step-by-step instructions. Leaderboards are a great way of motivating any team, be it a classroom, gym buddies or a sales department. What’s really nice is that you can use Microsoft’s OneDrive integration to save your leaderboard in the cloud and give others access. At the same time you can limit who can edit the leaderboard.

As a bonus we’ve included a good-looking template for you to download at the end of this post.

Let’s look at how to create a leaderboard and share it using Excel.

To get started, create a new file with 3 columns: Rank, Name and Score. See screenshot below. We’ve also added some dummy data to work with.

Excel Leaderboard

Note that the rank column is empty and that our scores are not sorted.

Create an auto incrementing field in Excel

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 formula =ROW()

Excel Leaderboard

You’ll see that after pressing enter, cell A2 now contains 2. This is not what we want, because it should say 1 – but it is correct, because we are in the second row 😉. The solution is quick: we alter the formula to say =ROW()-1.

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:

Excel Leaderboard

Sort the scores

Next we want to sort the leaderboard so that the highest score is at the top. This requires 2 steps

  1. Select the data
  2. Sort it

We select the data, by clicking in the top left cell and then dragging the mouse to the bottom right cell. Our spreadsheet now looks like this:

Excel Leaderboard

Now for the sorting.

In the ribbon of the Excel interface, click the “Sort” icon. You should see the following dialog pop up.

Enter the values you see in the screenshot and click on ok.

Excel Leaderboard

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.

Share the leaderboard by uploading it to the cloud (optional)

You can upload your Excel file to share it with other people. To do this you need a OneDrive account.

Click on the green “Share” button at the top right like on the screenshot below, then click on “Upload”.

Excel Leaderboard

After this has completed, click the share button again. You now have the option to share a “view only” link.

Excel Leaderboard

That’s it! Your new leaderboard is now in the cloud and the link is in your clipboard. Share the link via email or however suits you best.

Downloadable leaderboard template

We promised you a template to download and here it is. Simply click this link to download it.

Excel Leaderboard

Wait, one more thing 👋

By the way, all of this functionality is also provided by Keepthescore.co 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. You can give it a try here (without needing to sign up or pay anything)!

Excel Leaderboard

If you want to cut-and-paste some scores from an Excel 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 👋.


Subscribe below to never miss out

.