AI Analyst✨ 3.2
New capabilities
The AI Analyst can now build tables to answer complex questions, like finding goals, modeling scenarios, and doing multi-variate analysis.
Goal Seek: Solve reverse calculations, and find the numbers you need to reach a target. Example:
How many orders do I need to hit $100k, $500k $1M in revenue?
How many cookies should I sell to make $1M?
What-If Analysis: See what happens when a key metric changes. Example:
How does my revenue change if my margin increases by 5%?
What if I raise prices by 10%?
Now, the Analyst can create new tables where each cell is a formula, value, or text to solve problems like these. It’s great for building models, calculators, and plans, simply by asking.
AI Analyst✨ 3.1
New capabilities
This release comes with 3 new features and 1 big improvement in the Analyst’s accuracy:
Clear Chat: Easily reset the conversation with the Analyst by clearing the current chat and starting fresh.
Sample Dataset: Dive right into the Analyst's capabilities by loading a sample dataset from an empty table —perfect for quick exploration.
Chart Aggregation: The Analyst can now create charts with aggregated values (e.g., sum, count, average, median) for data points that share the same x-axis values, for more insightful visualizations.
Smart Retry: When the Analyst encounters an issue responding to a prompt, it automatically assesses the error and tries to self-correct it.
AI Analyst✨ 3.0
New capabilities
We just released the biggest AI update in the last 15 months.
It's a completely new Analyst rebuilt from the ground up to be a smarter, faster and a more versatile data analyst for your spreadsheets.
You can now ask AI to perform several new actions, including:
Get answers: Get direct answers to your business questions.
Add Tables: Extracts trends, generate pivot tables, and slice the data.
Create Charts: Turn numbers into visual stories just by asking.
Add columns: Insert new calculated columns to expand your data.
Enrich data: Add new datapoints to your tables with rich data columns.
Format cells: Apply formats & styles that clean up your datasets.
AI Analyst✨ 2.0
New capabilities
You can now ask AI to generate tables and charts’ subtitles, including the key insights and eye-popping stats from the data. Select the Add subtitle option in a Chart or Table and press Enter. AI does the rest.
AI Analyst✨ 1.4
New capabilities
The AI Analyst✨ 1.4 release comes with two new improvements to help you answer the data questions that are on your mind:
Suggested questions: The Analyst suggests a list of contextual questions to ask from the dataset, to give your a few ideas to get started.
Smarter replies: We upgraded the analyst ability to answer questions. It has a broader awareness of the dataset, including data types, formats, and key variables in each column. This means you can expect it to answer more questions correctly.
AI Analyst✨ 1.3
New capabilities
With the AI Analyst 1.3 release the AI Analyst✨ can now answer growth and forecast questions in time series. Including:
Growth Trends: This feature allows users to explore and understand historical growth patterns in key metrics. For example, examine the compounded growth rate of specific metrics, such as impressions, over a selected period (e.g., the last ten days).
Forecasts: The Analyst can now forecast future performance indicators (using linear regression). Users can ask questions like estimating the expected number of clicks or other relevant metrics for the upcoming week, enabling more informed planning and strategy development.
AI Analyst✨ 1.2
Support for vertical tables
The Analyst can now analyze tables with vertical headers such as quarterly financial reports, P&L statements and other tables where the first row represents a date or time.
Start anywhere on the table
The Analyst can now be used to analyze tables located anywhere on the grid. The Analyst will now look for the first cell with data and assume that as the starting location of the dataset.
AI Analyst✨ 1.1
Add Quick insights to the table description
You can now add the AI insights directly to the description of the table. A new, simpler way to communicate all that AI wisdom.
Improved formatting for Deep dives
The results of Deep dives now inherit the cell format from the source table.Currencies are formatted as currencies, percentages as percentages, numbers as numbers.
AI Analyst✨ 1.0
Introducing the AI Analyst ✨
The AI Analyst is like a number-crunching sidekick. It summarizes the main take-aways from any dataset, runs in-depth analysis, and answers any questions you might have about your data. It is available in every Table of a spreadsheet. To access it, click the ✨ on the top-right corner of the Table, next to the Table settings.
When you open the AI Analyst✨ you’ll see three separate sections, which correspond to its three core features.
Quick insights
These are top level insights about your table. The AI Analyst scans your dataset, understands the key variables and provides you with a summary in 3-5 sentences with relevant KPIs about those variables, calculating averages, medians, minimum, max values and more.
Deep dives
This is the second level of AI analysis. The AI Analyst extracts trends, generates pivot tables, and identifies patterns in the data. You can add any of these deep dives as tables to your spreadsheet, and use it to add Charts or Embed the results somewhere else.
Custom questions
Finally, you can use the AI Analyst to ask question about the dataset. The Analyst can answer your queries, making it much simpler to find specific trends, create pivot tables and extract specific information about the dataset
🎥 Watch the demo video and get started with these datasets