Judges Score Sheet Template in Excel: How to Set One Up for Your Contest

The quick answer: a workable judges score sheet in Excel needs five things: a list of the criteria being judged, a maximum score for each criterion, a column or row for each contestant's score on each criterion, a field identifying which judge filled it in, and a total that Excel calculates for you. You can download a ready-made contest scoresheet template and adapt it, or build one from a blank workbook in a short session using the layout and formulas below. Either way, the template is only as good as the rubric you put into it. The criteria, point values and weighting are your event's decisions, or your governing body's if one applies, and no template supplies them.

This guide covers judged contests, where people score a performance, entry or presentation against criteria. Examples include talent shows, cook-offs, art and science fairs, costume contests, dance or cheer showcases, and pitch competitions. It does not cover recording match results such as wins, losses or game scores, which belong on a separate sheet (explained below). This guide doesn't set official judging standards. If your contest runs under a league, association or sanctioning body, use its rubric and score sheet requirements in place of the example values here.

What to include on the score sheet

Event details: event name, date, category or division, and round, if you have more than one.
Judge identifier: a judge name, number or code, so every score can be traced to who gave it.
Contestant identifier: an entry number, plus the name if your event allows it. Some events judge by number only to reduce bias. That is an organizer choice.
Criteria: each thing being judged, written as a short label with a one-line description judges can refer to.
Maximum points per criterion: shown on the sheet so judges know the scale.
Weight per criterion (optional): only if some criteria count more than others.
Score entry cells: one per contestant per criterion.
Total: calculated by formula, never typed by hand.
Comments (optional): a notes column for tiebreak discussions or feedback to contestants.
Sign-off: a line or cell for the judge to confirm the sheet is final.

A simple layout that works

The most common approach is one worksheet per judge, with contestants down the rows and criteria across the columns. The example below uses placeholder criteria and point values to show the structure. Replace them with your own rubric.

Row/Col | A | B | C | D | E | F | G

3 | Weight | | 1 | 1 | 1 | 1 |

4 | Max points | | 10 | 10 | 10 | 10 |

6 | 101 | (name) | | | | | (formula)

7 | 102 | (name) | | | | | (formula)

Keeping weights and maximums in their own rows (rows 3 and 4 above) means you can change the rubric in one place and every formula updates. Put contestants in the same order on every judge's sheet so totals line up when you combine them.

Building it in Excel step by step

1. Set up one sheet with the header, criteria, weights, maximums and contestant list. Finish and check this master version first.
2. Add the total formula to the first contestant row and fill it down.
3. Restrict score cells to valid values: select the score cells, open Data > Data Validation, choose Whole number or Decimal, and set the range from 0 to the criterion maximum.
4. Add a completeness check so a blank score can't slip through unnoticed.
5. Lock everything except the score and comment cells: unlock the entry cells under Format Cells > Protection, then use Review > Protect Sheet.
6. Duplicate the finished sheet once per judge and change only the Judge ID on each copy.
7. Add a Summary sheet that pulls each judge's totals together and produces rankings.
8. Run a test: fill every judge sheet with made-up scores, and check the summary by hand before event day.

Formulas you can copy

These assume the layout above, with scores in columns C to F, weights in row 3, and the first contestant in row 6. Adjust the cell ranges to match your sheet.

Unweighted total (G6):
=SUM(C6:F6)

Weighted total (G6):
=SUMPRODUCT(C6:F6,$C$3:$F$3)

Completeness flag (H6) - shows a warning if any criterion is blank:
=IF(COUNT(C6:F6)<COLUMNS(C6:F6),"INCOMPLETE","")

Over-maximum check (I6) - catches a value over the max if validation was bypassed:
=IF(SUMPRODUCT(--(C6:F6>$C$4:$F$4))>0,"CHECK","")

Combining scores from several judges

On the Summary sheet, give each judge a column that references that judge's total for each contestant, then calculate a final score. How you combine judges' scores is a rule your event decides in advance, or one your governing body sets. Pick a method, tell judges and contestants what it is, and don't change it after scoring starts. The common options are below.

Method | What it does | Example formula (judge totals in B6:F6)

Sum | Adds every judge's total | =SUM(B6:F6)

Average | Mean of judge totals; still works if a judge misses an entry | =AVERAGE(B6:F6)

Drop high and low | Removes the single highest and lowest totals, then averages the rest; needs at least 3 judges | =(SUM(B6:F6)-MAX(B6:F6)-MIN(B6:F6))/(COUNT(B6:F6)-2)

If your judge sheets are named consistently and laid out identically, you can also average one cell across all of them with a 3D reference. For example, =AVERAGE('Judge 1:Judge 5'!G6) averages cell G6 on every sheet from Judge 1 through Judge 5. To rank contestants, add a column with =RANK.EQ(G6,$G$6:$G$30,0), where 0 ranks the highest score first. Decide your tiebreak rule ahead of time too, such as highest score on a named criterion or a judges' discussion. RANK.EQ gives tied contestants the same rank, so it won't break ties for you.

Keep judging separate from match results

If your event mixes judged rounds with head-to-head matches, keep the judged assessment and the match results on separate sheets, or in separate workbooks. A judge score sheet records opinions measured against criteria. A results sheet records outcomes like wins, losses or points scored in play. Mixing them makes errors harder to spot and makes it unclear which numbers judges were responsible for. If the two feed into a combined standing, link them only on a final summary sheet, with the combination rule written next to the formula.

Downloading a free template vs. building your own

Searching for a free judges score sheet template turns up a mix of contest scoresheet template sites, printable score sheet collections and image boards with sheet ideas. A downloaded template can save layout time. This guide can't confirm what any specific template includes, whether it is still free, or whether it works with your version of Excel. Before relying on one, open it and check that the totals are formulas rather than typed numbers, that the formulas cover every row and criterion, and that the criteria and point values can be edited to match your rubric. Many printable templates are built for handwriting rather than calculation. If you want automatic totals, check for that specifically, or build your own with the steps above.

Pre-event checklist

Criteria, maximums and weights match the rubric your event or governing body has approved.
Every total cell contains a formula, and the formula covers every criterion column.
Weighted totals produce the result you expect when tested with simple numbers (for example, all maximum scores).
The drop-high-and-low or averaging method matches what was announced to contestants.
Every judge sheet has the same contestant order and a unique Judge ID.
Data validation and sheet protection are on.
A printed backup copy of each judge sheet is available in case a device fails.
A second volunteer checks the final summary before results are announced.

What this guide doesn't cover

No official judging standards, criteria, point scales or weighting are given here. The example values are placeholders. Requirements set by a sanctioning body, school, league or venue, such as mandated forms, judge qualifications or record-keeping rules, aren't covered and should be confirmed directly with the organization involved. The details of Excel menus can differ slightly between versions and between the desktop and web apps.