Help & Support
Send Feedback
OpenSolver
Solve linear and mixed-integer optimization problems in Google Sheets with no artificial limits on problem size.
344 users
Works with
Install
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
Reviews
A User of OpenSolver
March 23, 2019
Can't get it started. I can install it, but can't select any page on the dropdown menu, then all fields stays gray and inactive. I can't find help anywhere. Neither the official website, or the internet, offers a troubleshoot page. Nowhere can I find any assistance.
Submit reply
Cancel
A user of OpenSolver
April 17, 2019
I am dealing with the same situation, I contacted them on their help page, i will respond here with their answer if they ever reply to me. For now we should just look for alternatives.
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
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
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.
Submit reply
Cancel
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
Submit reply
Cancel
A User of OpenSolver
July 20, 2017
Loved it! Very intuitive interface: I had a linear maximization problem involving ~50 variables. I managed to define the problem and had it solved within 5 minutes after installation.
Submit reply
Cancel
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.
Submit reply
Cancel
A User of OpenSolver
January 24, 2017
Taking a Data Analytics class, watched my professor input the same variables, objective, and constraints into excel solver that I input to this one, used the same data exactly, triple checked inputs. Yet somehow the excel solver executed without issue and this solver keeps claiming the equation is non-linear. I get that the excel solver is most likely more powerful, but we were just optimizing the fraction to invest in two stocks in a portfolio to minimize the variance given return greater than 4%. It's not a difficult problem and this solver really should have been able to execute.
Submit reply
Cancel
A user of OpenSolver
February 12, 2017
Minimizing the variance is indeed a non-linear function
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.
Submit reply
Cancel
A user of OpenSolver
December 13, 2016
Your model is probably nonlinear so we cannot solve it
1-10 of 19
Additional information
Search
Clear search
Close search
Google apps
Main menu