Twitter users are buzzing with excitement over the latest thread from Stealth Energy founder Mehran Jalali, who recently shared the capabilities of his next-level AI spreadsheet assistant. Surprisingly, it can do a handful of things, such as autofill entire sheets based on context, generate formulas, filter rows using text commands, and even directly integrate GPT-3 into your tool.
Whether using Google Sheets or Microsoft Excel, the AI-powered spreadsheet can make every work easier and more efficient.
Curious enough to see what it can offer? Come and let’s explore each feature.
Smart Autofill
The Smart Autofill feature allows spreadsheets to perform complex tasks easily by typing situations or instructions in the cell. In return, users will receive results based on the given context and the formula.
One of Jalali’s examples of using smart autofill is determining how much tax a person will have if the income is $150,000. He typed it into the cell and got results in just a few seconds.
The tool can also be helpful for bookkeeping, projecting revenues, and other applications. However, it’s still currently in beta mode.
Factual Autofill
Factual autofill works similarly to smart autofill but has an additional function: getting correct information on the sample data. However, users should provide sufficient details, as it’ll be the basis of the tool’s output.
Jalali, in his example, typed the company names he wished to extract data from under Column A. He added details in Row 1 (e.g., headquarters location, year founded, etc.). Once done, he clicked the Factual Autofill button.
The tool filled the necessary information in the table all at once, saving time from manually looking them up on the internet. Excel also has the same feature.
Generate Formulas
Each user has a different skill level when using Google Sheets or Microsoft Excel; some are advanced, while others are just starting to learn. It can be daunting for a beginner to navigate the tool, especially with formulas.
However, that’s not a problem anymore with the AI spreadsheet assistant’s Generate Formula feature. According to Jalali, users can describe the formula, and the tool will generate it.
It covers almost anything, from simple to advanced and regular expressions to unfamiliar functions.
Filter
Jalali developed the filter feature to simplify keeping and removing rows using natural language prompts.
Through this, users don’t have to manually find the functions on their spreadsheet or memorize shortcuts to organize their data.
Populate
The Populate feature saves time, as it automatically fills a column based on the context provided on the header. One of its applications is to generate lists, which is handy when shopping on special occasions and the like.
Incorporate GPT-3 and GPT-4
Jalali even takes the AI spreadsheet assistant to a more advanced level by incorporating GPT-3 prompts. He even teases an upcoming upgrade involving GPT-4. But what exactly does it do?
This feature has two applicable formulas: =AI() and =infer(). =AI() allows users to input prompts, while =infer() is for teaching the program on what to do.
It best extracts the exact answer from long texts, summarizes information, categorizes customer feedback, and formats phone numbers.
Although the AI-powered spreadsheet assistant shows promising potential, users must contain its excitement, as it’s not yet in the market. However, Jalali announces that he’ll be launching it real soon. Until then, the only thing left is to be hopeful about it.
Building More Functions for AI Spreadsheet
Jalali is not the only builder to develop an AI spreadsheet; he’s only one of the few. There are other AI enthusiasts that built before him; Shubhro Saha, a writer and software engineer, created the =GPT3().
It allows users to run GPT-3 prompts within Google Sheets, making previously difficult or impossible tasks easier. Some of its applications revolve around data sanitization, summarization, feedback categorization, and even writing cards.
Another Twitter user, NoCodeDevs, also shared his interesting way of creating a comma-separated values (CSV) file. Basically, it helps in organizing extensive data when imported into a spreadsheet.
Don’t worry; it doesn’t require deep coding knowledge and experience, as ChatGPT can do the hard work. As NoCodeDevs stated, users only have to ask ChatGPT to generate a list (e.g., U.S. cities), command the bot to convert it into JSON, and transform the file into CSV.
Although these AI-powered spreadsheets are not entirely perfect yet, builders never stop improving them. For this reason, it’s likely that we’ll see many more new features and capabilities added in the coming years.
Join our newsletter as we build a community of AI and web3 pioneers.
The next 3-5 years is when new industry titans will emerge, and we want you to be one of them.
Benefits include:
- Receive updates on the most significant trends
- Receive crucial insights that will help you stay ahead in the tech world
- The chance to be part of our OG community, which will have exclusive membership perks
