11. April 2025
Add Goal Seek logic to your app using the GRID API
An incredibly useful, but obscure feature of spreadsheets is Goal Seek. It lets you work backwards from the result you want, to figure out the input you need. Think:
“What interest rate gets me to my savings goal in 5 years?”
“How many units do I need to sell to break even?”
“What monthly payment hits my loan payoff target?”
With the GRID API, you can use Goal Seek programmatically as part of your backend logic — powered by a real spreadsheet engine. No math libraries or custom logic required.
Example: Savings Goal
Let’s say you want to help users figure out how much they need to save each year to hit a specific target.
The easiest way to model this is in a spreadsheet. In the example below, the spreadsheet takes annual savings and interest rate as inputs. We can then use Goal Seek to determine the amount needed to reach a specific savings goal. Now you can apply Goal Seek to the model directly from your application using the GRID API.
The code below shows a simple implementation of this model, enabling this type of calculation in your application:
For a deeper dive, check out our Goal Seek example from our Python SDK.
Turn your spreadsheet models into app logic
The GRID API makes it easy to turn powerful spreadsheet models into production-ready app features. Goal Seek is just one example — whether you’re working with pricing models, forecasts, or anything else, let the spreadsheet handle the logic behind the scenes.
🔗 Sign up
News
Updates and announcements
02.12.2024
Bringing spreadsheets into the AI-first era
Introducing GRID's new mission The current wave of AI is arguably the biggest shift in user interfaces since the advent of the GUI. Meanwhile, spreadsheets remain a cornerstone of the business world — resilient, ubiquitous, and indispensable despite repeated predictions of their demise. The fusion of AI and spreadsheets is poised to be big, but it requires a fundamental rethinking — not bringing AI to traditional spreadsheets, but reimagining spreadsheets and their workflows for the AI-first era. With a unique set of cutting-edge spreadsheet technologies, GRID is uniquely positioned — and determined — to lead this transformation. AI-First The AI-first paradigm is defined by three key characteristics: Language-oriented: We interact with computers in our language, not theirs. Task-centric: Work starts with the task at hand, not the hunt for the right software. Agentic: Computers will act on our behalf, even when we’re not there. Spreadsheets Spreadsheets are not just tools; they are foundational to modern business: Ubiquitous: Over 1 billion users worldwide rely on them. Empowering: As the original low-code solution, they enable business users to solve problems independently. The fabric of business: Spreadsheets likely hold more business logic and data than any formal IT system. Bringing them together With the world’s most advanced independent spreadsheet engine — designed for lightning-fast performance and seamless compatibility with Excel and Google Sheets — and a suite of other powerful spreadsheet technologies, GRID is uniquely positioned to redefine the future of spreadsheets in an AI-first world. We’re bridging the gap between AI and spreadsheets, delivering the reliable and verifiable calculations that AI solutions currently lack. Bringing spreadsheets to ChatGPT Today, we’re taking a major step forward by expanding the Alpha testing of our ChatGPT solution and opening registrations for early access. Sign up now to secure your spot in the Alpha and see GRID’s solution in action!
26.08.2020
GRID closes $12M in Series A funding round led by NEA
We’re thrilled to announce that we have closed a $12M Series A funding round led by New Enterprise Associates (NEA), with participation from our existing investors BlueYard Capital, Slack Fund, Acequia Capital and other strategic partners! This funding will enable us to bring GRID to market and power accelerated product development. For more information see our press release. Additional coverage: Tech Crunch: GRID raises $12M Series A to turn spreadsheets into 'visual narratives' SiliconANGLE: Iceland's Grid lands $12M to help workers make their spreadsheets more visual Tech Target: Analytics startup Grid raises $12 million in funding
27.03.2019
GRID closes $3.5M seed funding
We are thrilled to share some great news with you: We just closed $3.5M in seed funding! The investment is led by BlueYard Capital, with participation from strategic investors such as Slack Fund, Acequia Capital and angel investor Charlie Songhurst. We are happy to work with this group, as they add a lot of value to our mission other than their funding. Needless to say, they deeply believe in our mission to empower people to turn any spreadsheet into a beautiful web report, dashboard or interactive application. After our private Alpha launch a few weeks ago, we are now all heads-down again working on product, strategy, network expansion and go-to-market planning. This investment - on top of our $1M angel round in October - fuels current plans well into 2021. It gives us breathing room to focus on building the initial version of our product, take it to market and grow it from there - by delighting our users. We will be adding a few people to our team in the coming weeks and months. This is a fantastic opportunity to join an exciting startup at an inflection point. Take a look at our open positions, and keep an eye on our tweets.