Metaroids

    Subscribe to the Metaverse Newsletter

    Join me as we build a network of metaverse and web3 pioneers.

    What's Hot

    ChatGPT Flexes Intelligence By Taking Wharton MBA Examination

    January 24, 2023

    Making History: AI Lawyer to Defend in Upcoming Case

    January 23, 2023

    The Chilling Potential of ChatGPT for Criminal Activities

    January 22, 2023
    Twitter
    Metaroids
    • Home
    • News

      ChatGPT Flexes Intelligence By Taking Wharton MBA Examination

      January 24, 2023

      Making History: AI Lawyer to Defend in Upcoming Case

      January 23, 2023

      The Chilling Potential of ChatGPT for Criminal Activities

      January 22, 2023

      Professor Initiates Integration of ChatGPT in Classroom

      January 19, 2023

      Google Sets the Record Straight on AI Content

      January 15, 2023
    • Learn

      Midjourney Mastery: A Guide to Using Image Prompts

      January 22, 2023

      Design UI Like a Pro: 5 Advanced Midjourney Tricks

      January 13, 2023

      Reddit Moons: An Ultimate Guide

      January 12, 2023

      The ChatGPT Era: How Creatives Can Ensure Longevity & Thrive

      January 7, 2023

      Google Translate vs ChatGPT vs DeepL: Translator Ultimate Showdown

      January 6, 2023
    • Others
      1. Feature
      2. Press Release
      3. Opinion
      4. Lists
      5. View All

      ChatGPT + Wolfram Alpha: A Super Powerful Assistant

      January 22, 2023

      AI-Powered Sexbots and the Risks They Could Trigger in the Future

      January 21, 2023

      AI and Art: Opening Doors to New Realms of Creativity

      January 17, 2023

      Supercharge Your ChatGPT Game w/ 10 Advanced Prompts

      January 12, 2023

      Hyped NFT Trippin’ Ape Tribe to Launch on Solana in Mid-Late May

      May 6, 2022

      Microsoft’s VALL-E May Trigger an Avalanche of Cyber Crimes

      January 18, 2023

      Why Web3 Gaming is Failing & How to Turn the Tide

      December 23, 2022

      Can the Metaverse Work Without Blockchain?

      August 17, 2022

      NFTs are 100% Sustainable: Here’s Why Critics are Wrong

      August 8, 2022

      Best Solana Wallets for NFTs, DeFi, & Security

      October 27, 2022

      Top Move-to-Earn Crypto Apps That Pay You to Exercise

      August 31, 2022

      Top 13 Blockchains for NFTs (Choose Wisely)

      August 16, 2022

      Top Selling NFT Collections of August 2022

      August 9, 2022

      ChatGPT Flexes Intelligence By Taking Wharton MBA Examination

      January 24, 2023

      Making History: AI Lawyer to Defend in Upcoming Case

      January 23, 2023

      The Chilling Potential of ChatGPT for Criminal Activities

      January 22, 2023

      ChatGPT + Wolfram Alpha: A Super Powerful Assistant

      January 22, 2023
    • Contact
    • Privacy Policy
    Twitter Discord
    Metaroids
    Home » Boost Your Data Game with the Next-Level AI Spreadsheet
    Boost Your Data Game with the Next-Level AI Spreadsheet
    News

    Boost Your Data Game with the Next-Level AI Spreadsheet

    By StarkJanuary 4, 2023Updated:January 7, 2023No Comments4 Mins Read
    Share
    Facebook Twitter LinkedIn Email Reddit Telegram

    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.  

    Smart Autofill Sample Application

    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.  

    Using Factual Autofill

    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. 

    Generating Formula Using Context

    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.

    Unfiltered (left) vs Filtered (right) Tables

    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.

    Populate-Function
    Populate Function

    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. 

    GPT-3-Prompt-Sample
    GPT-3 Prompt Sample

    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.   

    Thank You Card

    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. 

    I just used ChatGPT to:

    1. build a list of US cities
    2. convert the list to JSON
    3. output a CSV file pic.twitter.com/Y2sR86ampw

    — NoCodeDevs (@nocodedevs) December 24, 2022

    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 web3
    • Access whitelist spots of the most hyped NFT drops
    • The chance to be part of our OG community, which will have exclusive membership perks

    Subscribe to the Metaverse Newsletter

    * indicates required


    By signing up, you agree to our Privacy Policy agreement.
    AI AI spreadsheets
    Share. Facebook Twitter LinkedIn Email Reddit Telegram
    Stark
    • Twitter

    Stark is a crypto and NFT writer, hobbyist photographer, and dedicated web3 learner. She is currently on a mission to help Metaroids rise. When she isn't, she's either sleeping or sipping coffee. What else would an introvert do besides enjoying "me" time?

    Related Posts

    ChatGPT Flexes Intelligence By Taking Wharton MBA Examination

    January 24, 2023

    Making History: AI Lawyer to Defend in Upcoming Case

    January 23, 2023

    The Chilling Potential of ChatGPT for Criminal Activities

    January 22, 2023

    AI-Powered Sexbots and the Risks They Could Trigger in the Future

    January 21, 2023
    Add A Comment

    Comments are closed.

    Latest Articles
    News

    ChatGPT Flexes Intelligence By Taking Wharton MBA Examination

    By Damocles
    News

    Making History: AI Lawyer to Defend in Upcoming Case

    By Stark
    News

    The Chilling Potential of ChatGPT for Criminal Activities

    By Damocles
    Metaroids
    Twitter
    • Home
    • About
    • Contact
    • Our Authors
    • Privacy Policy
    Privacy Policy and Terms of Services
    Copyright © 2023 - All Rights Reserved.

    Type above and press Enter to search. Press Esc to cancel.