How to Do Sensitivity Analysis and Goal Seek in Google Sheets

If you’ve ever built a financial model in Google Sheets and wished you could just run a quick sensitivity table or Goal Seek like in Excel — you’re not alone. These are two of the most missed Excel features when you switch to Sheets, and Google doesn’t have a native equivalent for either one.

I ran into this problem constantly when I moved to strategic finance and our team used Sheets for everything. So I built both of these into XLKeys. Here’s how they work.

Goal Seek

Goal Seek is pretty simple conceptually: you have a formula, you want it to hit a specific number, and you want the tool to figure out what input gets you there. In Excel this is built in. In Sheets, it doesn’t exist natively.

With XLKeys, hit Alt+A,W,G (or Option+A,W,G on Mac) and a modal pops up asking for three things: the cell with the formula, the target value you want, and the input cell you want it to solve for. XLKeys will iterate through values until it finds one that works, then you can apply it or cancel.

Some examples of when this is useful:

• What price do I need to hit a 40% margin?
• How many units do I need to sell to hit $1M in revenue?
• What conversion rate gets me to my ARR target?

Basically any time you’re manually plugging in numbers and checking if the output is right — Goal Seek does that for you.

If Goal Seek Isn’t Working

A few things to check if it’s not converging:

• Make sure the target cell actually has a formula, not a hardcoded number.
• Make sure the input cell is something the formula actually depends on.
• If the formula has IF statements, lookups, or circular references, the solver might struggle — it works best when the output changes smoothly as the input changes.

Quick test: manually change the input a few times. If the output barely moves or jumps around, Goal Seek is going to have a hard time too.

Sensitivity Tables

This is the big one — whenever I do any modeling in Excel or Google Sheets I always say "sensitize everything." This is quite hard to do when there’s no native data table feature in Sheets! (Google, please just fix this!).

In the meantime, XLKeys, a Chrome extension that is free to use, gives you Excel-like data table features built in. Just open it up, highlight your data table, run the sensitivity table shortcut, and a popup will show. It’ll ask you to select your row and column input cells, then run. It will then populate your entire data table by running every scenario. Works just like Excel does natively and is a great option until Google builds this in.