Google Workspace Changes

Group by view aggregation is now available for tables in Google Sheets.

When using tables in Google Sheets, you’ll have access to our new type of view, group by, where you can aggregate your data into groups based on a selected column. This week, we’re excited to introduce the ability to apply column-level aggregations when in a group by view.

Introduce the ability to apply column-level aggregations when in a group by view in Google Sheets.

Introduce the ability to apply column-level aggregations when in a group by view.

Easily add multiple people chips in a Google Sheets cell

Following up on our recent announcement of easily converting data to people chips in Google Sheets, we’re excited to announce that users can now seamlessly convert cells with multiple emails to people chips.

Users can now seamlessly convert cells with multiple emails to people chips in Google Sheets.

Users can now seamlessly convert cells with multiple emails to people chips.

Gemini in the side panel of Google Sheets now supports Greek, Catalan, Indonesian, and Malay.

Gemini in the side panel of Google Sheets can be used in four additional languages: Greek, Catalan, Indonesian, and Malay.

Advanced formatting options for tables in Google Sheets.

Google Sheets has introduced advanced formatting for tables via a new table formatting sub menu. Users can now toggle gridlines, alternating colors, condense view, and include a table footer.

Advanced formatting for tables in Google Sheets

Now, users have access to a new table formatting sub menu that allows them to toggle on and off gridlines, alternating colors, condense view, and include a table footer.

Gemini in the side panel of Google Sheets now supports Arabic, Chinese, Czech, Danish, Dutch, Finnish, Hebrew, Hungarian, Norwegian, Polish, Romanian, Russian, Swedish, Thai, Turkish, Ukrainian, and Vietnamese.

Gemini in the side panel of Google Sheets can be used in seventeen additional languages: Arabic, Chinese, Czech, Danish, Dutch, Finnish, Hebrew, Hungarian, Norwegian, Polish, Romanian, Russian, Swedish, Thai, Turkish, Ukrainian, and Vietnamese.

New formatting options for people chips in Google Sheets.

Users can now customize the display format of people chips in Google Sheets. In addition to the default display name, options for 'Last name, First name' and 'Email address' are now available via the Format > Smart chips menu.

Bulk conversion of email data to people chips via suggestions in Google Sheets.

Google Sheets now provides a 'Convert to people chips' suggestion when users click into a data range containing email addresses, allowing them to preview and convert the data into people chips in bulk with a single click.

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.