Google Workspace Changes

Google Sheets now supports creating and editing scatter charts with multiple independent x‑series, preserving Excel compatibility.

Google Sheets now supports creating and editing scatter charts with multiple independent x‑axis series, allowing each data series to be mapped to its own unique horizontal axis rather than forcing all series to share a single x‑axis. The update also improves compatibility with Microsoft Excel: scatter charts that contain multiple x‑series are preserved when importing or exporting between Google Sheets and Excel, preventing the loss of extra axes that previously occurred. There are no admin controls; end users can learn more in the Help Center. The feature is rolling out gradually: Rapid Release domains see visibility up to 15 days starting July 29, 2026, and Scheduled Release domains see visibility up to 15 days starting August 14, 2026. It is available to all Google Workspace customers and personal Google account users.

Google Sheets adds new combo chart types and improves Excel import compatibility, preserving secondary axis.

Google Sheets now offers enhanced support for combo charts, providing a more seamless experience when creating multi-series visualizations. Users can create new “Combo” chart types, including Clustered Column - Line, Clustered Column - Line on Secondary Axis, and Custom Combo, enabling complex dataset visualization with different scales and metrics without manual re-plotting. Additionally, Sheets combo chart support includes improved Microsoft Excel import compatibility, ensuring that secondary axis configurations and combo chart types are preserved during file import.

Fill with Gemini and the AI function in Google Sheets are now available in 11 additional languages.

Google has expanded the availability of 'Fill with Gemini' and the AI function in Google Sheets to 11 new languages, including Mandarin, Dutch, Malay, Hebrew, Polish, Turkish, Czech, Indonesian, Swedish, Danish, and Norwegian. This AI-powered feature simplifies data preparation by allowing users to generate text, summarize information, categorize data, and analyze sentiment without needing complex formulas.

Google Sheets now supports the import of 3D bar charts.

Google Sheets now fully supports the import of 3D bar charts, including those imported from Microsoft Excel. Previously, 3D bar charts were converted to 2D bar charts upon import; this update ensures a more seamless experience by preserving the 3D format.

Gemini in Google Sheets can now diagnose and fix formula errors in one click.

Google has introduced a new Gemini capability in Sheets that allows users to troubleshoot formula errors quickly. When an error is encountered, Gemini analyzes the surrounding data structure to provide an easy-to-understand explanation of the issue and a corrected version of the formula, supporting everything from basic arithmetic to intricate calculations.

Expanded language support for building and editing spreadsheets with Gemini in 28 additional languages.

Google is expanding the language support for Gemini in Sheets, allowing users in 28 additional languages—including Spanish, Portuguese, Japanese, Korean, Italian, French, German, and Chinese Simplified—to build and edit spreadsheets using natural language prompts. This update enables global teams to leverage Gemini to create tables, pivot tables, charts, and formulas in their native languages, facilitating more efficient data management and workflow automation without language barriers.

Anomaly detection is now available in Connected Sheets for BigQuery data sets.

Google Sheets has introduced anomaly detection in Connected Sheets, allowing users to identify critical irregularities and outliers in time-series BigQuery data sets without requiring SQL knowledge or manual model training. Powered by BigQuery ML and TimesFM, the feature offers zero-shot analysis with a user-friendly configuration side panel, built-in formatting for anomaly indicators and bounds, customizable thresholds, and automated refresh capabilities.

Beta program to double cell limits to 20 million

Google is introducing a beta program that allows organizations to double their cell limit in Google Sheets, increasing it from 10 million to 20 million cells. This increased capacity applies to new, existing, and imported files for participating organizations.

Gemini in Google Sheets now enables the creation and editing of complex spreadsheets using natural language.

Google has introduced advanced Gemini capabilities in Sheets that allow users to build entire spreadsheets, including data retrieval and formatting, from a single natural language prompt. The update features 'Workspace Intelligence' to synthesize data across Workspace apps, side-by-side editing for refining existing models, and advanced task fulfillment for creating pivot tables and complex formulas. Additionally, it incorporates advanced optimization powered by Google DeepMind and Google Research OR-Tools to solve complex optimization problems without requiring manual formula configuration.

Google Sheets is updating logic and parameter support for specific functions to improve error visibility and data control.

Google Sheets is introducing enhancements to a targeted set of functions to improve error surfacing, parameter support, and calculation logic. Informational and statistical functions like HYPERLINK and T.TEST will now more accurately flag underlying errors; statistical distribution functions such as HYPGEOM.DIST now support additional parameters for better external file compatibility; and financial and array functions like CUMIPMT have been refined for more precise and predictable results.

Google Sheets introduces two new functions, =SHEET and =SHEETS, to help users manage and reference spreadsheet tabs.

Google Sheets is adding two new dynamic functions: =SHEET and =SHEETS. The =SHEET function returns the sheet number of a specified sheet name or reference, while =SHEETS returns the total number of sheets in the spreadsheet. These functions automatically recalculate when sheets are added, deleted, moved, or renamed, ensuring data analysis remains accurate as the spreadsheet structure changes.

New =SHEET and =SHEETS functions added to Google Sheets for enhanced tab management.

Google Sheets is introducing two new functions, =SHEET and =SHEETS, to enhance the management and referencing of multiple tabs within a spreadsheet. The =SHEET(value) function returns the sheet number of a specified sheet, or the current sheet if no argument is provided. The =SHEETS() function returns the total number of sheets in the spreadsheet. These dynamic functions automatically recalculate when sheets are added, deleted, moved, or renamed, ensuring data analysis accuracy.

Connected Sheets for BigQuery now allows users to generate data forecasts using BigQuery ML and the TimesFM model.

Google is introducing a new forecasting capability in Connected Sheets for BigQuery, leveraging BigQuery ML (BQML) and the TimesFM foundation model. This allows users to predict future business metrics like sales or demand without writing SQL or Python. Key features include a user-friendly configuration pane, customizable prediction horizons and confidence intervals, support for granular breakouts by data dimensions, and automatic visualization of forecasts against historical data.

Google Sheets now allows direct import of large .csv files to BigQuery for analysis.

Google Sheets has enhanced its capabilities by enabling users to directly import large .csv files into BigQuery for analysis. This new feature streamlines the workflow, allowing users to open and analyze massive datasets from Google Drive or via the Data > Data Connectors menu in Sheets. Once imported to BigQuery, users can leverage familiar Sheets features like charts, pivot tables, and formulas through Connected Sheets, significantly expediting the process from raw data to insights.

Added drill down functionality to Connected Sheets pivot tables for granular data access.

Users can now drill down into Connected Sheets pivot tables to immediately access granular data. By double-clicking a pivot table cell or using the "Show details" menu option, users can instantly create a pre-configured extract focused on the specific records contributing to the summary metric.