Solve linear and mixed-integer optimization problems in Google Sheets with no artificial limits on problem size.
By:
Works with:
361K+
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
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
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
Jillian Morgan
June 4, 2023
Doesn't accept any input. Unable to do anything with it at all. Unusable.
Is this review helpful?
Yes
No
Profile Picture
Pink Eye
February 12, 2023
Can't even load in 2023. Just opens up a blank sidebar.
Is this review helpful?
Yes
No
Profile Picture
Zbigniew Popielecki
September 6, 2022
use variables ignoring their constraints, no matter what method / solver solution is used, useless add-on
Is this review helpful?
Yes
No
Profile Picture
mickias h
March 20, 2023
its not even launching for me
Is this review helpful?
Yes
No
Profile Picture
starrychloe S.
March 25, 2022
It just doesn't work sometimes. Will give wrong answers for 'target value' mode. It is faster, easier, and more accurate to just manually do a binary search to hone into the correct value for your variable cell. My target value was 2, and it stopped with a ridiculous value like 28. By updating the variable cell myself about 5 times, I was able to find the target value 2.
Is this review helpful?
Yes
No
Profile Picture
Pavel Golota
September 9, 2021
Doesn't work. The results of calculations are always 0.
Is this review helpful?
Yes
No
Profile Picture
J F
April 18, 2021
Doesn't work at all. Every time I try to add variables to be changed, it clears everything so I can't even set it up. I've uninstalled and re-installed twice but no change. Total waste of time.... I'd give it zero stars but Google won't let me submit the review without at least 1 star.
Is this review helpful?
Yes
No
Profile Picture
John Paravantis
November 19, 2021
Works well, with an interface different but simpler than the Solver of Excel.
Is this review helpful?
Yes
No
1-10 of 55
Search
Clear search
Close search
Google apps
Main menu