App Icon
Solve linear and mixed-integer optimization problems in Google Sheets with no artificial limits on problem size.
Works with:
53,132
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
Privacy policy
Terms of service
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:
Profile Picture
A User of OpenSolver
April 8, 2016
This provides a very intriguing tool for building spreadsheet LP and MILP optimization models. There are no predetermined limits on problem size, though the speed of updates in Google Sheets limits applications to relatively modest size. The current solvers provide a choice between the Glop optimization engine via Google, and COIN-OR CBC solver via the NEOS optimization cloud. (As of this writing, the Google Optimization server is currently broken, so having a second choice is important.) The sidebar UI is similar to the solver interface in Excel, but in my view has a more intuitive layout. Having tried all three LP/MILP solvers currently available in the Sheets Add-in store, in my view this provides the best interface and usability It has a ways to go before being a fully mature tool, but shows much promise.
Is this review helpful?
Yes
No
Profile Picture
James Ball
April 5, 2018
This is a linear programming and solver alternative NOT a security appliance. Why would it be? I just have to say thanks, especially for not limiting the number of inputs. Solver in Excel is an intro level product. One of the paid versions is needed if you have a large number of inputs.
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
September 11, 2017
I like this tool for its simplicity but I believe the permissions are a bit too wide. It would be five starts if this app used "View and manage spreadsheets that this application has been installed in" vs a blanket permission of full sheet access. Overall great tool for linear problems
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
December 9, 2016
Can't get it to work. Keeps putting out a Div/0! error even though I specify a constraint with objective cell values >=1.
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
October 26, 2016
Being familiar with the method of entering constraints from other spreadsheet solvers, I was able to create a model (along the same lines as Jed Henson's lol) in only a few minutes, not counting scraping the data. This is a great interface to GLPK.
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
March 2, 2017
It is fairly easy to use, but it lacks support for non-linear functions, so, for example, it's not possible to construct a spreadsheet to use k-means to cluster data. Adding support for non-linear functions would make this very very useful.
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
February 15, 2018
This works better than the Solver plugin in my limited testing. I'm excited someone is working on this since lack of Solver had been a huge limitation for sheets. The permissions are too broad, but from what I can tell that is because Google doesn't offer enough granularity in permissions.
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
June 9, 2016
Much easier to use than excel, by far! Was very effective in my spreadsheet building! I know it will improve over time and Im looking forward to it, thanks!! Excel👎
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
September 14, 2017
Great add-on but WAY too many permissions - end up adding it only when I need it... Removing again now.
Is this review helpful?
Yes
No
Profile Picture
A User of OpenSolver
March 7, 2019
Does not work. I tired using this to see if it would be able to do something my other solver cant but it does not even follow the constrants i set for it and it only inputs into the first of 5 Variables, while ignoring the constraint limiting the costs. Went back to using other solver cause it could atleast handle a basic 5 variable 3 constrant Maximization
Is this review helpful?
Yes
No
1-10 of 43
Search
Clear search
Close search
Google apps
Main menu