Loading video...
Video Failed to Load
I spent the last 2 weeks building the ultimate AI assistant for spreadsheets. It can: - Autofill entire sheets just based off context - Generate formulas and filter rows using text commands - Directly integrate GPT-3 into your sheets And more… Here are a few examples: (1/8)
1,143,209 views • 3 years ago •via X (Twitter)
11 Comments

2/ SMART AUTOFILL Automatically fill out tables with relevant formulas and text to perform complex tasks, just based off of context. Examples: - Calculating tax owed given marginal tax brackets - Doing some bookkeeping - Projecting revenue from a prompt (In beta for now)

3/ FACTUAL AUTOFILL Fill out tables with factual information based on the header rows and columns. Examples: - Getting information about target companies - Detecting the components of an address - Autofilling information about an address

4/ GENERATE FORMULAS You can describe a formula and it will generate it for you. From simple stuff that’s easier to describe than type out, to harder things incorporating regex, formulas based on contextual info, and sometimes stuff using functions you didn’t even know existed.

5/ FILTERING Selectively keep/remove rows using natural language prompts. Remove duplicates, only keep submissions with proper email addresses, remove blank rows, etc. Here’s an example of cleaning up form submissions and then filtering the results:

6/ =AI() and =INFER() Directly incorporate GPT-3 (and soon GPT-4!) prompts into your spreadsheets using =AI(), or teach it what to do using =infer(). Examples: - Extracting information from text - Summarizing text - Formatting phone numbers - Categorizing customer feedback

7/ POPULATE Fill in a column just based on the header. Save time filling out the header column, pulling data, writing out lists, etc. A few examples:

I’ll be launching the assistant soon for both Google Sheets and Excel. If you wanna try it out, sign up here:

Check out

GPT 3 data fills are very bad past superficial, popular data. It loves to invent new seemingly realistic data, even with prompts that explicitly say otherwise (dangerous!) Eg: It made up a list of hotels in attached image

Man this feels pretty dope! Do you have a landing page where I can get to know more about it?

Just this thread for now. Sign up to check it out soon!
