Metaroids

    Subscribe to the Metaroids Newsletter

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

    What's Hot

    NSFW Ban on Generative AI Platforms: What, Why, and What to Do?

    May 11, 2023

    Can Deepfake Be Considered Identity Theft?

    May 10, 2023

    Deepfake’s Bright Side: Exploring Use Cases with Beneficial Implications

    May 9, 2023
    Twitter
    Metaroids
    • Home
    • News

      Remix Culture is Coming to Movies Through Deepfake

      April 29, 2023

      NVIDIA’s Text-to-Video AI is Wild!

      April 23, 2023

      Elon Musk to Launch TruthGPT: Here’s What You Need to Know 

      April 19, 2023

      Midjourney V5 is Here: 3 Things You Need to Know

      March 16, 2023

      Elon Musk Assembles Team to Build an Open ChatGPT

      February 28, 2023
    • Learn

      Can Deepfake Be Considered Identity Theft?

      May 10, 2023

      Deepfake’s Bright Side: Exploring Use Cases with Beneficial Implications

      May 9, 2023

      The Best Way to Bypass the NSFW Filter on Character.AI

      May 9, 2023

      Fastest Way to Remove Watermark from Dall-E Images

      May 7, 2023

      AI-Generated Media: A Guide to Understanding DeepFakes

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

      NSFW Ban on Generative AI Platforms: What, Why, and What to Do?

      May 11, 2023

      Deepfakes in Movies: The Future of Filmmaking

      May 8, 2023

      The Rise of AI Video Generators: Hollywood Will Bleed

      May 6, 2023

      Web3 and AI: Separating Fact from Fiction in Two of the World’s Most Powerful Technologies

      May 3, 2023

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

      May 6, 2022

      ChatGPT Plus Review: Is It Worth $20/Month?

      February 16, 2023

      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

      How to Make Money with Midjourney

      April 8, 2023

      Adult AI Art: Tools That Can Generate NSFW AI Images

      April 8, 2023

      How to Sell AI Art on Print-on-Demand Platforms

      March 29, 2023

      Midjourney Art Styles GigaPack: FREE 200 Prompt Keywords

      March 17, 2023

      You.com: A Comprehensive Review of the Search Engine Powered by AI

      February 27, 2023

      NSFW Ban on Generative AI Platforms: What, Why, and What to Do?

      May 11, 2023

      Can Deepfake Be Considered Identity Theft?

      May 10, 2023

      Deepfake’s Bright Side: Exploring Use Cases with Beneficial Implications

      May 9, 2023

      The Best Way to Bypass the NSFW Filter on Character.AI

      May 9, 2023
    • Contact
    Twitter Discord LinkedIn
    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 the tech world
    • The chance to be part of our OG community, which will have exclusive membership perks

    Subscribe to the Metaroids 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

    NSFW Ban on Generative AI Platforms: What, Why, and What to Do?

    May 11, 2023

    The Best Way to Bypass the NSFW Filter on Character.AI

    May 9, 2023

    Bing Chat AI: Your Ultimate Guide to Using Microsoft’s Chatbot 

    May 3, 2023

    Remix Culture is Coming to Movies Through Deepfake

    April 29, 2023
    Add A Comment

    Comments are closed.

    Latest Articles
    Learn

    Can Deepfake Be Considered Identity Theft?

    By Precious Ogar
    Learn

    Deepfake’s Bright Side: Exploring Use Cases with Beneficial Implications

    By Precious Ogar
    Learn

    The Best Way to Bypass the NSFW Filter on Character.AI

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

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

    x
    x