Tech Desk 
Mar 01, 2025
Google has introduced a significdant upgrade to the Sheets app by introducing a Gemini-powered capabilities that is designed to help users analyse data faster and turn spreadsheets into charts using artificial intelligence (AI).
With this upgrade, users can access Gemini’s capabilities to generate insights from their data, such as correlations, trends, outliers, and more.
The company said that users now can also generate advanced visualisations, like heatmaps, that they can insert as static images over cells in spreadsheets.
To get started, you are required to click the Gemini icon on the top right-hand side of your spreadsheet. From there, you can ask things like “Predict my net income for the next quarter based on historical data” or “Create a simple heatmap of support cases by category and device.”
Google stated that Gemini can do all this by creating and running Python code and then analysing the results to perform multi-layered analysis. For simpler requests, Gemini might still give answers using formulas instead of Python code.
The company noted that data should be in a consistent format with clear headers and no missing values to allow for accurate results.
