Google Sheets gets a Gemini-powered upgrade to analyze data faster and create visuals

Google is giving Sheets a Gemini-powered upgrade that is designed to help users analyze data faster and turn spreadsheets into charts using AI.

With this update, users can access Gemini’s capabilities to generate insights from their data, such as correlations, trends, outliers, and more. Users now can also generate advanced visualizations, like heatmaps, that they can insert as static images over cells in spreadsheets.

While the company announced the update last month, Google said on Friday that it’s now available to all Workspace business users.

To get started, you need 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.”

Other examples include a marketing manager asking Gemini to “Provide some insights on my top 3 performing channels by conversion rate” or a financial analyst asking Gemini to “Identify any anomalies in inventory levels for Product X.”

Gemini is able to do all this by creating and running Python code and then analyzing the results to perform multi-layered analysis, Google says. For simpler requests, Gemini might still provide answers using formulas instead of Python code.

The company notes that data should be in a consistent format with clear headers and no missing values to allow for accurate results.