Solve linear and mixed-integer optimization problems in Google Sheets with no artificial limits on problem size.
By:
Works with:
414K+
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
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
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
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
Profile Picture
Pierre Valentin, CFA
December 4, 2023
Does not even load. To be deleted asap.
Is this review helpful?
Yes
No
Profile Picture
Carolina Martins
February 23, 2024
Doesn`t load results
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
Pink Eye
February 12, 2023
Can't even load in 2023. Just opens up a blank sidebar.
Is this review helpful?
Yes
No
1-10 of 60
Search
Clear search
Close search
Google apps
Main menu