Google Workspace Changes

People chips in Google Sheets now available on mobile devices

People chips, which allow users to quickly view contact information, job titles, and locations of colleagues or contacts, are now available for Google Sheets on both iOS and Android devices.

Import and convert sensitive Excel files into client-side encrypted Google Sheets.

Google Sheets is introducing an open beta that allows users to import and convert sensitive .xlsx Excel files into client-side encrypted Google Sheets. The original encrypted Excel file remains unchanged during this process. The feature supports files up to 20MB and a maximum of 5 million cells, though any unsupported Excel features will be ignored during the import process.

Add emojis in Google Sheets

Users can now insert emojis into Google Sheets by either typing '@' and selecting 'Emoji' or by navigating to the 'Insert' menu and selecting 'Emoji'.

Filter by measures and value in a pivot table with Connected Sheets for Looker

Looker users can now filter by measures and values in pivot tables within Connected Sheets, enabling more targeted analysis of their data.

Extending long running queries within Connected Sheets

Google has extended the timeout for queries in Connected Sheets for BigQuery and Looker from 5 minutes to 10 minutes, allowing users to analyze larger data sets within Sheets.

Convert email addresses and links into smart chips using the tab key in Google Sheets.

Google Sheets now allows users to quickly convert pasted email addresses or links to Google Drive files, Google Maps places, or YouTube videos into smart chips by simply pressing the tab key.

Revamped First Open Experience for Sheets and Slides on Android tablets and foldables.

Google is introducing a more creation-focused experience when first opening the Sheets and Slides apps on Android foldable and tablet devices. In Sheets, users will see larger tap targets and easier access to the formula bar, tab bar, and contextual formatting toolbar. In Slides, a filmstrip will now appear on the left-hand side, and selecting an object will expose the contextual toolbar and an on-screen keyboard.

Add or remove client-side encryption from existing Google Sheets and Google Slides files.

Users can now add or remove client-side encryption for existing spreadsheets in Google Sheets and presentations in Google Slides by navigating to File > Make a copy > Add/Remove additional encryption. This update provides greater flexibility in controlling encryption as documents and projects evolve, bringing this capability to Sheets and Slides after it was previously introduced for Google Docs.

Hardware keyboard support for formulas in Google Sheets on Android

Google is enhancing the Google Sheets app on Android devices by allowing users to use a hardware keyboard to insert ranges in a formula via arrow keys and adding more formula-related keyboard shortcuts.

Introducing new keyboard shortcuts in Google Sheets

New keyboard shortcuts are being added to Google Sheets to increase productivity, including shortcuts for applying or removing bold formatting, moving to the next sheet, and displaying the Find and Replace box.

Google Sheets adds enhanced formatting, collapsed card views, and print/download support to timeline view.

Google Sheets is expanding its timeline view feature with several new capabilities to improve project tracking. These updates include enhanced formatting options such as card text truncation and undo/redo functionality, a new card collapsed view that allows users to merge cards into a single row for each card group, and the addition of print and download support.

New capabilities to expand the timeline view feature in Google Sheets.

Today, we’re adding the following capabilities to expand the timeline view feature: Enhanced formatting options, including card text truncation and the undo/redo option, A card collapsed view that enables you to merge cards into a single row for each card group, Print and download support

Export client-side encrypted spreadsheets to Excel files

Google Sheets now supports the export of client-side encrypted spreadsheets into Excel format, allowing users to convert files as needed while maintaining their encryption protection.

New smart chip data extraction in Google Sheets allows users to pull metadata from people, file, and event chips into cells.

Google Sheets has introduced smart chip data extraction, enabling users to extract metadata associated with people, file, and event chips into their own cells. This functionality allows for advanced sorting, filtering, and analysis of data derived from smart chips. Users can perform these extractions via a dedicated sidebar or by using formulas, and can keep the extracted data current using the 'Refresh & manage' section.

Autofill using a mouse is now available on the Google Sheets Android app.

Users of the Google Sheets Android app can now utilize the autofill feature using a mouse, improving data entry efficiency on Android devices.