How to Make a Leaderboard (Online, Free, In Under 5 Minutes)
A practical guide to making a live online leaderboard that actually drives engagement. Five steps, six worked examples, common mistakes, and a free tool you can use right now.
A leaderboard is the simplest tool there is for driving motivation: pick a number, rank people or teams by it, show everyone where they stand. Done well, it turns abstract performance into a daily competition. Done badly, it demotivates the middle of the pack and rewards the rep who was already going to win.
This guide walks through how to make a leaderboard that actually works — five steps, six worked examples, the mistakes that kill momentum, and a free tool (MakeTheBoard) you can use to ship one in under five minutes.
What is a leaderboard, really?
A leaderboard is a ranked list of people, teams, or entries ordered by a score. That's it. The score can be revenue, points, books read, dollars raised, demos booked, calls made, miles run — anything you can put a number on.
The thing that makes a leaderboard useful (rather than just a chart) is two characteristics:
- Visibility. Everyone who cares can see where they stand at a glance, without having to ask, log in, or dig through a dashboard.
- Liveness. Scores update as new data comes in. Rankings re-sort. Yesterday's standings are irrelevant — what matters is right now.
A static printed sheet on the wall is technically a leaderboard. So is a Google Sheet. Both will work for a week, then drift out of date and stop driving behavior. The leaderboards that move the needle are live, shareable, and visible all the time.
Why a live leaderboard beats a spreadsheet
This part is worth a paragraph because most people start with a spreadsheet and only later realize why it's not working.
A spreadsheet is a tracking tool — it's where the numbers live. A live leaderboard is a broadcast tool — it's how the numbers get into people's heads. A spreadsheet that updates daily but only the manager looks at can drive behavior for the manager. It can't drive behavior for the team.
| Spreadsheet | Live leaderboard |
|---|---|
| Someone has to share the file | Anyone with the link can view |
| Goes stale between updates | Auto-refreshes as scores change |
| Hard to read at a distance | TV-ready display |
| Manual sorting | Auto-sorts on every update |
| Hidden from view by default | Visible everywhere — Slack, TVs, embeds |
If your existing tracking is in a spreadsheet, that's fine. Keep it for the math. Use a live leaderboard for the display.
How to make a leaderboard in 5 steps
Here's the short version. Each step has a worked example below.
- Pick one metric. One number that determines the ranking.
- Decide who's on the board. People, teams, classrooms, departments, donors.
- Decide how often it updates. Daily, hourly, or live.
- Build the board. Add the entries and their starting scores.
- Share it where people will see it. Link, embed, or cast to a TV.
Step 1 — Pick one metric
The single most important decision in building a leaderboard is choosing the metric. The metric is what gets optimized. Pick the wrong one and you get the wrong behavior.
Good metrics share three properties:
- Objective. No one can dispute the number. "Calls made" beats "best attitude."
- Trackable. You can capture it without manual heroics. If you have to chase reps for status reports, you'll stop updating the board within a week.
- Aligned with the outcome you actually want. "Demos booked" is great for SDRs, but if your real bottleneck is closing, demos booked won't help.
For sales teams: revenue closed, deals won, calls made, demos booked, or quota attainment percentage. For classrooms: points earned, books read, behavior markers, or quiz scores. For fundraisers: dollars raised, donor count, or team totals. For competitions: points scored, time elapsed, or judge ratings.
Tip: If you can't pick one, run two boards. One for activity (leading indicator), one for outcomes (lagging indicator). Just don't try to cram both onto a single board — readers will tune out.
Step 2 — Decide who's on the board
The participants are the second-biggest factor in whether a leaderboard works.
A leaderboard of 50 people produces 1 winner and 49 people staring at a long list. A leaderboard of 4 teams produces a clear competition every team can engage with. Smaller groups produce more competition per person. When in doubt, group people into teams.
Common groupings:
- Individuals — best when the group is 10 or fewer and everyone is at similar tenure or quota.
- Teams or pods — best for larger orgs. Reps push each other because individual effort lifts the whole team.
- Departments or offices — best for company-wide initiatives like fundraising drives or giving campaigns.
- Classrooms or grades — best for school-wide reading challenges and house point systems.
Step 3 — Decide how often it updates
This is the difference between a leaderboard and a report.
- Real-time: Scores update the moment anyone changes them. Every viewer's screen re-sorts in seconds. This is the default for MakeTheBoard and what every other approach is trying to approximate.
- Daily: Manager updates the board at end of day. Reps wake up to fresh rankings every morning.
- Weekly: OK for long-cycle metrics like revenue. Almost always too slow for activity metrics.
If the board updates less often than the underlying behavior, it stops driving behavior. Daily calls? Daily updates minimum. Real-time deals? Real-time updates.
Step 4 — Build the board
This is the part most guides skip because it's annoying in a spreadsheet. In a live tool it takes a minute.
In MakeTheBoard:
- Click Create.
- Pick the board type — Leaderboard (auto-sorts by score) or Scoreboard (manual order, head-to-head).
- Give the board a title — "Q3 Revenue Race," "5th Grade Reading Challenge," "Walk-a-Thon 2026."
- Add entries — people, teams, classrooms, whatever you decided in Step 2.
- Enter starting scores (or zero them out).
You're done. The board is live the moment you save. Anyone with the link sees the live rankings.
For boards where participants will be updating their own scores (fitness challenges, peer-to-peer fundraisers, classroom self-reporting), turn on the signup link option. Share one link and participants add themselves.
Step 5 — Share it where people will see it
A leaderboard hidden on a dashboard tab is a leaderboard that doesn't work. The whole point is visibility, so be deliberate about where it lives.
The high-impact placements:
- A TV on the wall. Sales floors, classrooms, event venues. Open the link in any browser on a smart TV, Chromecast, Apple TV, or projector. The display scales to any screen.
- Pinned in Slack or Teams. Drop the link in your team channel and pin it. Anyone can pop it open in two clicks.
- Embedded on your site. Every board generates an embed code. Paste it on a campaign page, intranet, course site, or event page. The embed updates in real time the same as the public link.
- A QR code on the wall. Print the board's QR code on a poster at an event. Attendees scan and pull up the live rankings on their phones.
The one placement to avoid: emailed-as-a-screenshot. The moment you start broadcasting yesterday's standings as an image, you're back in spreadsheet territory.
6 worked examples
Sales contest leaderboard
Metric: Revenue closed. Participants: All quota-carrying reps on the team. Update frequency: Real-time (each deal triggers a score update from the SDR manager's phone). Display: 55" TV mounted in the bullpen.
The reps see their ranking every time they walk past. The board re-sorts the moment anyone closes. Best practice: keep a parallel activity board (calls or demos) so newer reps can compete on effort, not just outcome.
→ Full setup: Sales Leaderboard Software
Classroom points tracker
Metric: Behavior or participation points awarded by the teacher. Participants: Students individually, or house teams. Update frequency: Live, awarded throughout the day from the teacher's phone. Display: Classroom smartboard or projector.
Students see their points appear in real time, which is significantly more motivating than a Friday recap. Resetting weekly keeps the competition fresh and prevents demoralization.
→ Full setup: Classroom Leaderboard for Teachers
Fundraising thermometer + donor leaderboard
Metric: Two boards — total raised (thermometer), and individual donor amounts (leaderboard). Participants: Donors named publicly, or anonymized as "Donor #1, Donor #2" if preferred. Update frequency: Live during events, batch updated for campaigns. Display: Big screen at galas, embedded on the campaign donation page.
Top donors love seeing their name on the screen. The thermometer drives last-push urgency. Use both together.
→ Full setup: Fundraising Thermometer and Fundraising Leaderboard
Tournament or trivia night
Metric: Cumulative round-by-round scores. Participants: Team names (let teams self-register at the door with a QR code). Update frequency: Between each round. Display: Projector at the venue.
The drama of teams jumping ranks between rounds is the entire experience. A static printed sheet kills it; a live leaderboard makes it.
→ Full setup: Competition Leaderboard
Goal tracker for a team OKR
Metric: Progress toward a target (e.g., "120 new signups this quarter"). Participants: The whole team — one bar, not individual rankings. Update frequency: Daily. Display: Embedded on the team's internal dashboard or pinned in Slack.
When the goal is collective, a goal tracker beats a leaderboard. Use a progress bar instead.
Fitness or step challenge
Metric: Miles run, workouts logged, or steps tracked. Participants: Self-registered participants with self-reported scores. Update frequency: Daily, self-reported. Display: Shared link in the company Slack or club WhatsApp.
Self-reporting is fine for low-stakes challenges. For higher-stakes contests (cash prizes), have a single admin verify submissions.
Mistakes that kill leaderboards
These are the failure patterns we see most often. Avoid them.
- Too many people on one board. A leaderboard of 50 names is a phone book. Cap individual boards at ~15. Use teams above that.
- Stale updates. A leaderboard last updated "yesterday at 4pm" produces zero urgency. Either make it live or run it manually with a strict daily rhythm.
- One metric that favors one rep. If the same person always wins, others stop trying. Either change the metric (use % to quota) or reset frequently.
- No visible placement. A leaderboard nobody sees is a leaderboard nobody acts on. Put it on a TV, in Slack, on an event page — anywhere but a hidden dashboard tab.
- Vague rules. If reps have to ask "how am I being scored?", the contest is broken. Write the rules in one sentence on the board itself.
- Running it forever. Indefinite leaderboards lose energy by week 3. Run short, focused cycles (1 week, 1 month, 1 quarter). Reset and refresh.
How to make a leaderboard for free
If you have an hour, you can build one in Google Sheets with SORT() formulas. It will work for a few days, then drift out of date and stop being checked.
If you have five minutes, use a tool built for the job. MakeTheBoard is free for up to 2 boards with 10 entries each, no credit card required. That's enough for most teams, classrooms, and event organizers to validate whether a live leaderboard moves the needle for them before paying for anything.
The free plan covers:
- Real-time live updates
- Public shareable links
- TV / projector display mode
- Embed code for any website
- Mobile editing (update from your phone)
Upgrade options (Pro $24/mo, Premium $52/mo) add higher limits, custom branding, CSV export, multi-admin collaboration, and self-registration links — but the free tier is genuinely free, not a free trial.
FAQ
Can I make a leaderboard without coding? Yes. MakeTheBoard, like most modern leaderboard tools, is no-code. You sign in, click Create, and add entries.
How do I make a leaderboard in Google Sheets?
Use =SORT(range, sort_column, FALSE) to rank entries by descending score. Works fine for static rankings. The downside is that you have to manually share or re-share the sheet every time it updates, and it won't auto-display on a TV. For anything beyond a one-off, a dedicated tool is faster.
How do I make a leaderboard for a website? Build the board in a leaderboard tool, copy the embed code, paste it into your website's HTML. The embed updates in real time when scores change. MakeTheBoard's embed works on WordPress, Wix, Webflow, Squarespace, raw HTML, and any platform that accepts iframe embeds.
How do I display a leaderboard on a TV? Open the board's shareable link in any browser on the TV (smart TV, Chromecast, Apple TV, Fire Stick all work). Full-screen the browser. The layout scales automatically to TV display sizes.
Can participants update their own scores? Yes, if you enable a signup link. Share one link with participants and they add themselves and submit their own scores. Useful for fitness challenges, peer-to-peer fundraisers, and classroom self-reporting. For high-stakes competitions, keep score editing admin-only.
How long should a leaderboard run? Short cycles produce more energy than long ones. A 1-week activity sprint beats a 6-month revenue race in terms of week-to-week motivation. Run multiple short cycles instead of one long one, and reset cleanly between cycles so every participant starts at zero.
Ready to make one? Create a free leaderboard — it takes about a minute, no credit card required.
Ready to create your board?
Sign up free and build a leaderboard, scoreboard, or goal tracker in under a minute.
Create Your Board