Google Workspace Changes

you will now be able to update the format of your people chips to one of the following: Last name, First name; Email address

In addition to the default format of display name, within the Format menu, you will now be able to update the format of your people chips to one of the following: Last name, First name; Email address

you can now use bulk chip conversion for people chips

If you have a column of data that includes a variety of emails, Sheets will show a “Convert to people chips” suggestion when you click into your data range.

Performance improvements for pasting data, setting filter conditions, and loading spreadsheets.

Google Sheets has implemented several speed enhancements for common tasks: pasting data between spreadsheets is now up to 50% faster, setting up filter conditions is up to 50% faster, and the loading of existing data in spreadsheets is up to 30% faster.

additional improvements available for everyday actions in Sheets

Pasting data is now up to 50% faster when you’re pasting from one spreadsheet to another, Filter conditions can now be set up to 50% faster than before, Spreadsheets now load existing data up to 30% faster

Gemini in Google Sheets can now generate data insights and static charts.

Google Sheets users can now leverage Gemini to visualize and analyze data more efficiently. Gemini can provide valuable insights, such as contextual trends, patterns, and correlations, and generate static charts that can be inserted into spreadsheets. This is achieved by transforming user requests into Python code, executing them, and analyzing the results to perform multi-layered analysis without requiring the user to write code.

visualize and analyze data using Gemini in Sheets

Gemini in Sheets can perform actions or answer questions to address a wide variety of scenarios. Specifically, you can ask Gemini questions about your data and Gemini can provide valuable insights, such as contextual trends, patterns, and correlations between different variables in your data.

Expanding Google AI to more of Google Workspace

Quickly create tables, such as an expense tracker, generate insights based on spreadsheet data, and more.

Users interacting with policy-protected content will now be informed about what actions are prevented by those policies.

Users who are interacting with policy-protected content, such as those with data loss prevention (DLP) rules or trust rules, will now be informed about what actions are prevented by those policies

Increased row limits for pivot tables in Connected Sheets for Looker

Google is expanding the maximum number of rows of results returned from Looker to 100,000 for pivot tables in Connected Sheets, allowing users to analyze larger datasets from Looker directly in Sheets.

Expanding row limits in Connected Sheets for Looker

Expanding this to Connected Sheets for Looker by increasing the maximum number of rows of results returned from Looker to 100,000 for pivot tables. With this update, users can analyze even more results in Sheets from the petabytes of data in Looker.

Expanding row limits in Connected Sheets for Looker

we’re expanding this to Connected Sheets for Looker by increasing the maximum number of rows of results returned from Looker to 100,000 for pivot tables.

Expanding row limits in Connected Sheets for Looker

We’re expanding this to Connected Sheets for Looker by increasing the maximum number of rows of results returned from Looker to 100,000 for pivot tables.

Table reference improvements in Google Sheets

This week, we introduced updates to table references that enhance discoverability and usability.

Google Sheets is enhancing table references with improved availability for table parts, formula suggestions, and formula corrections.

Google Sheets has introduced updates to table references to improve discoverability and usability. Users can now reference specific table components—including full columns (#ALL), headers (#HEADERS), footers (#TOTALS), and data (#DATA)—across both single and multiple columns. Additionally, the update includes formula suggestions to help users identify more robust formula options and formula corrections to automatically suggest proper table references when a formula is written incorrectly.

Discoverability and usability updates for table references in Google Sheets.

Table references, a way to refer to a table or parts of a table in a formula, are just one example of how tables reduce time spent manually formatting data. Today, we’re excited to announce updates to table references that enhance discoverability and usability.