RICE Scoring Spreadsheet: Build It in Excel or Google Sheets

7 min read · 2026-10-10

To build a RICE scoring spreadsheet, make one row per idea and one column each for Reach, Impact, Confidence, Effort and Score. In the Score column, enter =B2*C2*D2/E2, then sort that column from largest to smallest to get your ranked backlog.

That basic version takes five minutes. The steps below turn it into a sheet your whole team can trust. Dropdowns stop people from making up their own scales. A guard formula stops errors. A ranked tab updates by itself, and a snapshot tab lets you compare each quarter with the last. If you are new to the method itself, start with our guide to RICE prioritization, then come back here to build the sheet.

The roadmap at a glance

Goal: A shared RICE scoring spreadsheet that ranks your backlog automatically and feeds your roadmap. Duration: About one week to build and fill, then a short update every quarter

1. Set Up the Tabs and Columns (Day 1)

   Give the sheet a fixed structure before anyone types a score.

   • Create three tabs: Scoring, Scales and Ranked.
   • In row 1 of the Scoring tab, add these headers from column A to J: Idea, Reach, Impact, Confidence, Effort, RICE score, Rank, Evidence, Owner, Lane.
   • Freeze the header row. In Excel: View > Freeze Panes > Freeze Top Row. In Google Sheets: View > Freeze > 1 row.
   • Write the Reach time window in the header itself, for example "Reach (users per quarter)", so nobody mixes months and quarters.
   • Do the same for Effort, for example "Effort (person-months)".

   Milestone: An empty Scoring tab with ten labeled columns and a frozen header.

2. Lock the Scales With Dropdowns (Day 1)

   Make it impossible to enter a value outside the agreed scales.

   • In the Scales tab, type the Impact values in A2 to A6: 3, 2, 1, 0.5, 0.25.
   • Type the Confidence values in B2 to B4: 1, 0.8, 0.5. Format column B as a percentage.
   • In Excel, select C2:C31 on the Scoring tab, go to Data > Data Validation, choose List and set the source to =Scales!$A$2:$A$6. Repeat for D2:D31 with =Scales!$B$2:$B$4.
   • In Google Sheets, select the same ranges, go to Data > Data validation, add a rule and choose "Dropdown (from a range)" with the same ranges.
   • For Effort (column E), add a validation rule that only accepts numbers greater than 0.
   • For Lane (column J), add a dropdown with two options: Scored and Must do.

   Milestone: Impact, Confidence, Effort and Lane only accept valid values.

3. Add the Formulas (Day 2)

   Calculate the score and rank without errors or manual work.

   • In F2, enter =IF(J2="Must do","",IF(E2>0,B2*C2*D2/E2,"")). It skips must-do work and leaves the cell blank until Effort is filled in, so you never see a divide-by-zero error.
   • In G2, enter =IF(F2="","",RANK(F2,$F$2:$F$31)). Rank 1 is the highest score.
   • Format column D as a percentage so 0.8 shows as 80%.
   • Copy F2 and G2 down to row 31 by dragging the fill handle.

   Milestone: Any complete row shows a score and a rank on its own.

4. Fill In Ideas and Data (Day 2 to Day 5)

   Enter every candidate idea with its source next to it.

   • Write each idea as one short line that names the problem it solves.
   • Enter Reach from your product analytics, as a real count in your time window.
   • Ask engineering to fill the Effort column, including design and testing time.
   • Use the Evidence column to note where Reach and Impact come from: a dashboard, support tickets, interviews.
   • Mark legal fixes, security work and blocking tech debt as "Must do" in the Lane column. They stay visible but get no score.

   Milestone: Every row has a score or a "Must do" label, and every score has a source.

5. Sort, Rank and Highlight (Day 5)

   See the order at a glance and catch weak scores.

   • In the Ranked tab, cell A2, use a formula that sorts scored rows automatically. In Google Sheets: =SORT(FILTER(Scoring!A2:J31,Scoring!F2:F31<>""),6,FALSE). In Excel 365 or Excel 2021: =SORT(FILTER(Scoring!A2:J31,Scoring!F2:F31<>""),6,-1).
   • Copy the headers from the Scoring tab into row 1 of the Ranked tab.
   • If your Excel version has no SORT function, select the Scoring table and use Data > Sort, by RICE score, Largest to Smallest.
   • Add a color scale to the RICE score column. In Excel: Home > Conditional Formatting > Color Scales. In Google Sheets: Format > Conditional formatting > Color scale.
   • Flag unsupported confidence. Add a custom formula rule on A2:J31: =AND($D2>0.5,$H2=""). Any row claiming more than 50% Confidence with an empty Evidence cell lights up.

   Milestone: A Ranked tab that reorders itself whenever someone changes a score.

6. Share It and Rescore Each Quarter (Ongoing)

   Keep the sheet useful after the first planning session.

   • Share the sheet with product, design and engineering, and give each person the columns they own.
   • At the end of each quarter, duplicate the Scoring tab and name it after the quarter, for example "Q1 scores".
   • In the copy, paste values only, so the old scores never change.
   • Add a column called "Actual impact" to the copy and fill it in for items you shipped.
   • Update Reach, Confidence and Effort in the live tab, and add new ideas.

   Milestone: One frozen snapshot per quarter and a live tab that reflects what you know today.

Common mistakes to avoid

• Typing Confidence as 80 instead of 80%. The score becomes a hundred times too big. Use the dropdown and the percentage format.
• Leaving Effort blank or at zero. Without the guard formula, you get an error that breaks sorting. Keep the IF check in column F.
• Sorting the Scoring tab by hand every week. People sort only part of the range and rows get mixed up. Let the Ranked tab sort for you.
• Scoring must-do work. A legal fix with a low score looks optional when it isn't. Keep it in the "Must do" lane.
• Overwriting last quarter's scores. You lose the chance to compare predicted and actual impact. Always snapshot before you update.
• Letting anyone edit any column. Give each column an owner and write the owner's name in the header note.

Frequently asked questions

What is the RICE formula in Excel or Google Sheets?

If Reach is in B2, Impact in C2, Confidence in D2 and Effort in E2, use =B2*C2*D2/E2. To avoid errors when Effort is empty, use =IF(E2>0,B2*C2*D2/E2,""). The formula is the same in both tools.

How do I rank RICE scores automatically?

Add a rank column with =RANK(F2,$F$2:$F$31). For a fully sorted view, use SORT with FILTER on a separate tab. Google Sheets uses FALSE for descending order, and Excel uses -1.

Should Confidence be a percentage or a decimal?

Store it as a decimal (1, 0.8, 0.5) and format the column as a percentage. The formula then works correctly and people still see 100%, 80% and 50%.

How many ideas should one RICE spreadsheet hold?

Keep the active list short enough to score in one or two sessions. The formulas in this guide cover rows 2 to 31. Extend the ranges if you need more, and move old or rejected ideas to an archive tab.

Can several people score in the same sheet?

Yes. Google Sheets and Excel for the web both let several people edit at the same time. Give each person their own columns, such as engineering for Effort and product for Reach, to avoid overwriting each other.

Generate this roadmap with AI