Excel Solver in Google Sheets: Tools, Setup, and Limits

Google Sheets does not include Microsoft Excel’s built-in Solver, so there is no native Solver button or menu to turn on. To optimize a spreadsheet in Sheets, install a Solver add-on from the Google Workspace Marketplace, then set an objective cell, the cells it may change, and any constraints; for a simple one-variable target, a Goal Seek add-on may be enough.

What Solver does

Solver is an optimization tool: it searches for values that make a chosen spreadsheet result as high, as low, or as close to a target as possible, while respecting rules you provide. Those rules are called constraints. A model might ask for the cheapest production plan that meets demand, the largest profit possible with limited labor, or a schedule that fits within available hours.

The key distinction is that Solver does not replace spreadsheet formulas. Formulas calculate the results of a model; Solver changes selected input cells and repeatedly recalculates those formulas to find a useful combination. For example, a profit formula can calculate the return from a proposed product mix, while Solver tries different quantities and checks that resource limits are not exceeded.

Excel users often search for “Excel Solver in Google Sheets” because the two programs have similar spreadsheet grids and formulas. However, Excel Solver is an Excel add-in, while Google Sheets needs a separate add-on or another optimization service. An Excel workbook’s Solver settings do not automatically become a working Solver tool when the workbook is opened in Sheets.

How to add a Solver tool to Sheets

In a desktop browser, open the spreadsheet and choose Extensions > Add-ons > Get add-ons. Search the Google Workspace Marketplace for a Solver add-on, review its publisher and permissions, and install the one that fits your needs. Solver for Google Sheets from Frontline Systems is one option readers may encounter; availability, features, and terms can change, so confirm the current listing before installing it.

Organize the model in the sheet: put the decision variables in identifiable cells, calculate the outcome with formulas, and keep limits or requirements visible.
Install the add-on from the Marketplace and grant only the permissions you are comfortable with.
Return to the spreadsheet and open the add-on from Extensions. The add-on’s name and launch command can vary; follow its current instructions.
Choose the objective cell, specify whether to maximize, minimize, or reach a target, and identify the variable cells Solver may change.
Add constraints, choose a solving method if the add-on offers one, and run the model.
Review the proposed values and the resulting calculations before keeping them. Save or record a copy of the original inputs if you may need to compare scenarios.

Marketplace add-ons are separate products, not Google Sheets features. Their screens, supported model sizes, limits, and pricing may differ. If you cannot find an add-on or its menu, check that installation completed, that you are signed into the correct Google account, and that your organization has not restricted Marketplace apps.

A small example: choosing a product mix

Imagine a workshop making two products. Product A earns $30 per unit and uses two labor hours and three units of material. Product B earns $50 per unit and uses four labor hours and two units of material. The workshop has 100 labor hours and 90 units of material. The goal is to maximize profit, with production quantities of zero or more.

Set up the sheet with product names in A1:B1, proposed quantities in A2:B2, profit per unit in A3:B3, labor per unit in A4:B4, and material per unit in A5:B5. Put the totals in column C. With quantities in A2:B2 and profit values in A3:B3, enter this in C3 to calculate total profit:

=SUMPRODUCT(A2:B2,A3:B3)

With quantities in A2:B2 and labor requirements in A4:B4, enter this in C4 to calculate labor used:

=SUMPRODUCT(A2:B2,A4:B4)

With quantities in A2:B2 and material requirements in A5:B5, enter this in C5 to calculate material used:

=SUMPRODUCT(A2:B2,A5:B5)

In the Solver add-on, set C3 as the objective to maximize and A2:B2 as the changing cells. Add constraints C4 less than or equal to 100, C5 less than or equal to 90, and A2:B2 greater than or equal to zero. If the add-on supports integer constraints and products must be whole units, also require A2:B2 to be integers.

The best mix for these numbers is 20 units of A and 15 of B. It earns 20 × $30 + 15 × $50 = $1,350, uses 20 × 2 + 15 × 4 = 100 labor hours, and uses 20 × 3 + 15 × 2 = 90 units of material. Both resource limits are fully used. This is a small linear model, and the example’s answer can be checked by hand; larger models are where an optimizer becomes more valuable.

Build a model Solver can interpret

A reliable model separates inputs, decision variables, calculations, and limits. Use labels and units so a reviewer can tell whether a cell represents dollars, hours, items, or a percentage. Avoid hard-coding a resource limit inside several formulas when you can put it in a clearly labeled cell; visible assumptions are easier to audit and adjust.

Before running Solver, check that the objective formula actually depends on the changing cells. If the objective is disconnected from those cells, changing them cannot improve the result. Also make sure constraints describe the real requirement. “At least 50” means greater than or equal to 50; “no more than 50” means less than or equal to 50. A reversed inequality can produce a mathematically valid answer that is useless for the actual problem.

Think about whether variables may be fractional, negative, or restricted to whole numbers. A model that allows 4.7 employees or −3 products may return an optimum that makes no practical sense. Nonnegative, integer, binary, and other restrictions are meaningful only if the selected add-on supports them and they are configured correctly. Verify a solution in the sheet rather than relying only on a success message from the add-on.

Solver add-ons, Goal Seek, and Excel

Solver and Goal Seek answer related but different questions. Solver typically adjusts multiple decision cells to optimize an objective under constraints. Goal Seek works backward from a target result by changing one input cell. If a loan payment formula is already built and you want to find the interest rate that produces a particular payment, Goal Seek may be appropriate. If you need to choose quantities for several products under labor and material limits, Solver is the more natural type of tool.

Excel’s Solver is available through Excel’s add-in system, and its setup and interface are not carried over as a Sheets add-on. In Microsoft 365 for Windows, Solver is commonly accessed from the Data tab after the Solver Add-in is enabled; exact availability can depend on the Excel installation. Sheets users should not follow Excel’s ribbon instructions expecting the same controls. The spreadsheet formulas may transfer in many cases, but add-on settings, compatibility, and model-solving behavior need to be checked separately.

For a small model, a Google Sheets add-on may be convenient because the data and calculations remain in the sheet. For a complex or business-critical model, compare the add-on’s documented solver methods, variable and constraint limits, collaboration behavior, support, and export options with a dedicated optimization product. A tool that handles a basic continuous model may not support the integer, nonlinear, or large-scale problem you have.

Common problems and how to troubleshoot

No feasible solution: The constraints may conflict. For example, requiring at least 100 units while limiting production capacity to 80 makes the model impossible. Temporarily inspect or relax one requirement at a time to find the conflict, then restore the true business rules.
Unexpected values: Check whether variables need nonnegative, integer, or binary restrictions. Also confirm that the objective is set to maximize or minimize as intended, and that the changing-cell range contains only decision variables.
The result does not change: Confirm that the objective formula references the decision cells and that calculations update when you edit those cells manually. A fixed value pasted over a formula will not respond to Solver.
Solver reports difficulty: Large or nonlinear models can be harder to solve than small linear ones. Check the add-on’s documentation for supported methods, limits, and guidance on scaling or formulating the model.
Results look too precise: A continuous model can return fractional quantities. Apply realistic integer restrictions where appropriate, then rerun and validate the answer; the integer version can have a different optimum.

Do not treat a solver’s “success” status as proof that the model represents reality. It only indicates a result under the formulas, data, constraints, and method supplied. Check units, stale or missing data, formula references, and assumptions, especially when a decision affects operations or finances.

Cost, permissions, and data considerations

Marketplace add-ons may be free, paid, limited by a trial, or priced for particular capabilities. Do not assume a Solver add-on is free simply because it can be installed. Read the listing and the vendor’s current terms for usage limits, subscriptions, support, and whether the tool processes data outside the spreadsheet.

Review permissions before authorizing an add-on. A spreadsheet can contain commercially sensitive, personal, or confidential information, and an add-on may request access to files or account data to perform its function. Follow your organization’s approval process for work accounts. If you are evaluating an unfamiliar tool, test it with a copy containing sample data rather than sensitive records, and remove access or uninstall it if you no longer need it.

Alternatives when an add-on is not suitable

For a single input and a target output, look for a Goal Seek add-on or calculate a small set of scenarios manually. For a basic model with only a few possible combinations, a table of candidate values may be easier to explain and audit than a more elaborate optimizer. Google Sheets formulas can calculate each scenario, but formulas alone do not generally perform Solver’s constrained search automatically.

If the model is large, has specialized requirements, or needs a documented and repeatable optimization process, consider a dedicated optimization platform or a programming approach that can call an appropriate optimization library. That introduces setup, maintenance, and review work, so it is not automatically better for a small worksheet. Choose the lightest tool that supports the model’s actual constraints and that the people responsible for the result can inspect.

Frequently Asked Questions

Does Google Sheets have Solver built in?

No. Google Sheets does not provide Excel’s built-in Solver feature. You can add optimization functionality through a third-party Google Workspace Marketplace add-on, but its interface and capabilities depend on the product.

Can I use Excel Solver in a Google Sheets file?

Not directly. Excel Solver is an Excel add-in, and its Solver interface and settings do not become a native Sheets feature when a workbook is converted or opened in Google Sheets. You can recreate the model in Sheets and use a compatible add-on.

Is Goal Seek the same as Solver?

No. Goal Seek changes one input to reach a specified result. Solver can optimize an objective by changing one or more cells while obeying constraints. Use the simpler tool when the problem only involves one adjustable input and a target value.

Can Google Sheets Solver handle integer or nonlinear problems?

That depends on the add-on and its selected solving methods. Check its current documentation for integer, binary, nonlinear, and model-size support; do not assume every product offers the same capabilities as Excel Solver or a dedicated optimization system.

Why does Solver say there is no solution?

Often, one or more constraints contradict each other, or the formulas and changing cells do not describe the intended model. Check the inequalities, units, ranges, and minimum or maximum requirements, then test the model with a simple set of values that should satisfy the rules.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.