Solve linear and mixed-integer optimization problems in Google Sheets with no artificial limits on problem size.
By:
Works with:
442K+
Overview
The OpenSolver Add-on for Google Sheets lets you solve complex optimization problems from within your Google Sheet. Made by the developers of the popular OpenSolver addin for Microsoft Excel, this add-on brings the same Open Source optimization engine to the cloud!

OpenSolver for Google Sheets uses the excellent, Open Source, SCIP and Glop optimization engines to quickly solve large Linear and Integer problems.  SCIP is one of the fastest non-commercial solvers for mixed integer programs, and Glop is an Open Source Linear Programming solver by the Operations Research team at Google.  We also support using the Open Source COIN-OR Cbc solver via the NEOS optimization cloud, and the Open Source GLPK solver running locally in your browser via GLPK.js.

There are no artificial limits on the size of problem you can solve with OpenSolver.

OpenSolver is free, Open Source software developed and maintained by Andrew Mason and students at the Engineering Science department, University of Auckland, New Zealand.

For more information, see www.opensolver.org
Additional information
PricingNot available
Developer
Trader status unspecified
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
OpenSolver will ask for the permissions shown below. Learn more
OpenSolver will need access to your Google account
This will allow OpenSolver to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Lucy Reed
October 4, 2024
this gives completely incorrect answers. I tried to use it for forecasting and it just puts variables at 0 even when i put they must be greater than 0. Useless, don't waste your time.
Is this review helpful?
Yes
No
Profile Picture
Cade TheKing
July 19, 2024
Nothing like a solver that sets all variables to zero to minimize the objective without even trying negative variables out lol. Trash. Uninstalling immediately
Is this review helpful?
Yes
No
Profile Picture
Brian P
February 23, 2024
Yeah. Straight up doesn't work. Using for a rental property model and wanted the monthly payment to be equal to $400 by changing the cell that contained the mortgage rate. Not even close to right answer Uninstalling
Is this review helpful?
Yes
No
Profile Picture
George Augustine Koromia
August 17, 2024
Doesn't work. Aug 2024.
Is this review helpful?
Yes
No
Profile Picture
TONI PIOLO MOTA
May 7, 2024
buggy and sometimes doesn't work even with equal number of constraints. I recommend using it with guidance of a professional.
Is this review helpful?
Yes
No
Profile Picture
Elena Baron
November 4, 2023
Does not work. Erases previously setup data as you set up your next parameter. Set objective, move to variables, it will erase objective. basically it refereshes with only most recent value set EVERY TIME. what a waste of time!
Is this review helpful?
Yes
No
Profile Picture
Matthew Tam
July 31, 2024
Needed a basic solver for a class I'm taking, and this did the trick.
Is this review helpful?
Yes
No
Profile Picture
Dayton Thorpe
April 1, 2024
Broken. Doesn't obey constraints and throws an error.
Is this review helpful?
Yes
No
Profile Picture
Matthew Royal
September 20, 2023
Broken -- will not load its own sidebar: has an infinite "Working" spinner icon. No way to see what went wrong for bug reporting.
Is this review helpful?
Yes
No
Profile Picture
Nick Coleman
May 18, 2023
Does not work. Reports that the objective is 0 no matter what, and returns an infeasible solution.
Is this review helpful?
Yes
No
1-10 of 65
Search
Clear search
Close search
Google apps
Main menu