Google Workspace Changes

Improved table reference availability with formula suggestions and corrections.

Users will now see: Improved table reference availability, which allows users to reference the items below across both single and multiple columns. Formula suggestions, which help you identify formulas that could be more robust. Formula corrections for table references, which show a formula correction with a proper table reference when a formula is written incorrectly.

Search for and reuse pre-defined queries from BigQuery in Connected Sheets

Users can now search for and reuse pre-defined queries directly from BigQuery Studio and notebooks to load data into Connected Sheets, removing the need to manually copy and paste queries.

Users can now search for and reuse pre-defined queries directly from BigQuery to load Connected Sheets data.

Users can now search for and reuse pre-defined queries directly from BigQuery to load Connected Sheets data.

Gemini in the side panel of Google Sheets now supports French, German, Italian, Japanese, Korean, Portuguese and Spanish.

Gemini in the side panel of Google Sheets now supports French, German, Italian, Japanese, Korean, Portuguese and Spanish.

Introducing a better filter by condition experience for tables in Google Sheets

Google Sheets tables now feature a smarter 'filter by condition' experience. The available filter options are now dynamically filtered based on the column's data type, ensuring users only see relevant options (e.g., number-based filters for number columns).

Improved comments experience in Google Sheets on Android tablets

Redesigned comments on Android tablets for viewing, navigating, and replying to comments.

Use Gemini in the side panel of Google Sheets in seven additional languages (Alpha)

You can now use Gemini in the side panel of Google Sheets in seven additional languages: German, Italian, Japanese, Korean, Portuguese, Spanish, French. The additional languages are available in alpha for Workspace customers with a Gemini Business, Gemini Enterprise, Gemini Education, and Gemini Education Premium add-on.

add smart chips that pull information from third party apps into Sheets

Users can also paste third-party chips inserted in Docs directly into a spreadsheet.

Conditional notification rules can now be directly applied to tables and will recognize table column names.

new integration between conditional notifications and tables in Sheets

Import and convert sensitive Excel files into client-side encrypted Google Sheets is now generally available.

You can now import and convert sensitive Excel files into Google Sheets with client-side encryption.

Insert hyperlinks in the Google Sheets iOS app

Google is adding the ability to insert hyperlinks into cells within the Google Sheets app for iOS devices. Users can insert a link by selecting a cell, clicking the '+' icon in the top left corner, and selecting 'Insert' then 'Link'. The app also provides options to edit or remove existing links.

Increased row limits for pivot tables and data extracts in Connected Sheets for BigQuery.

Google has increased the maximum number of rows returned from BigQuery in Connected Sheets. Pivot tables have been expanded from 30,000 to 50,000 rows, and data extracts have been expanded from 25,000 to 50,000 rows. Along with these limit increases, performance improvements have been implemented for creating pivot tables, deleting extracts, and manipulating data within pivot tables.

View and edit client-side encrypted Excel files with Google Sheets

Google Sheets is introducing a beta feature that allows users to view and edit client-side encrypted Excel (.xlsx) files while preserving the original format and confidentiality of sensitive data. The feature supports files up to 20MB and a maximum of 5 million cells, though some advanced Microsoft Office features may be preserved but not editable within Sheets.

You can now view and edit client-side encrypted Excel files with Google Sheets in beta.

Launching in beta, you can now view and edit client-side encrypted Excel files with Google Sheets. Any changes made are saved in the original Excel format. We are making it easy for you to leverage Google Workspace with the tools and formats you already use while preserving confidentiality of your sensitive data with client-side encryption.

Introduce 'Help me organize' in Google Sheets powered by Duet AI to automatically generate custom templates.

Google Sheets now features 'Help me organize' via Duet AI for Google Workspace Enterprise. Users can describe a task, such as planning a company retreat or establishing onboarding plans, and Sheets will generate a tailored template—including plans, trackers, or budgets—complete with sample text and editable smart chips to help users organize data quickly.