Loading
Loading
  • Home

  • Productivity

  • Productivity tips

Productivity tips

2 min read

The Decision Matrix: Make Better Decisions With This Spreadsheet Template

By Melanie Pinola · February 18, 2019
decision-matrix-template primary img

Your days are filled with decisions you have to make, from small ones like deciding what to eat for dinner to life-changing ones like deciding where to live. Even something as seemingly simple as choosing which laptop model to buy can feel like torture when you're faced with a lot of good options.

The cool, level-headed way to make the best decision is, of course, to use a spreadsheet. The Decision-Making Google Sheet template we're sharing is here to help. Based on the Decision Matrix method, the tool helps you objectively compare your options and choose the best one based on what you value most. It goes beyond the simple pros and cons list to take into account many different factors.

This Google Sheet template is adapted from an Excel version provided by Idea Sandbox. If you use Excel instead of Google Sheets, go grab that tool for your decision-making needs.

How to Use The Decision Matrix Template

It's pretty straightforward. Once you've filled out all the columns and rows, the spreadsheet will give you a score for all the options you're considering. Here's how the decision matrix works.

Protip: Go to the "Example" worksheet in the file to see what the tool looks like when it's filled out.

Step 1: Copy the spreadsheet template

Open and then make a copy of this Google Sheet (there will be a prompt to do so).

Step 2: Describe the decision you're considering

Google Sheets decision tool

This is just for your reference. It could be something like "Which house to buy" or "Which candidate to hire."

Step 3: Enter the factors or values that are important to your decision

Google Sheets decision tool factors

For example, when deciding on a house to buy, factors might include safety of the neighborhood, price, number of bedrooms, number of bathrooms, and move-in readiness.

Step 4: Rank those factors

Google Sheets decision tool rank of factors

Rank the factors above from 0 to 3, where 0 is somewhat important and 3 is most important or must have. In the example above, price under $300k might be a must have, so you would rank that 3, whereas if you're more flexible on move-in readiness, you could rank that a 0 or 1.

Step 5: List the options you're considering

Google Sheets decision tool choices

This row would be where you list your choices, such as the houses you're considering or any of the options you're deciding on.

Step 6: Score each option based on each factor

Google Sheets decision tool score

Now's the fun part. For each option, go down the list of factors that are important to your decision and score them from 0 to 3, where 0 means it doesn't fulfill that need and 3 means it is ideal.

Once you've filled those cells out, the spreadsheet will calculate a score for each option. The one with the highest number is the winner. Decision made!


Making an important life choice might not be as simple as that, but the spreadsheet could help you make an impartial, fact-based decision. Pair this with your intuition or gut feeling to decide on anything with confidence. For more help on this front, check out our other related posts:

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'