All Google Sheets updates
187 updates to Google Sheets tracked so far. Most recent: 2026-08-13 — Sheets canvas, a Gemini-powered feature, lets users create interactive, read-write visualizations in Google Sheets using natural language prompts.
-
2026-08-13Content & Collaboration
Sheets canvas, a Gemini-powered feature, lets users create interactive, read-write visualizations in Google Sheets using natural language prompts.
Google Sheets canvas transforms spreadsheets into custom, interactive mini-apps via natural language prompts, enabling end-to-end creation, real-time read-write sync, flexible adjustments, and familiar sharing tools. It supports use cases like Kanban boards, dashboards, and whiteboards, and is rolling out to Rapid and Scheduled release domains starting August 10 and August 31, 2026 respectively.
Release: Both • Rapid: 2026-08-10 • Scheduled: 2026-08-31 -
2026-08-11Content & Collaboration
Users can create aliases for BigQuery column names directly within Connected Sheets for clearer presentation.
Connected Sheets now lets users assign friendly aliases to BigQuery column names, improving readability without altering the underlying database reference. Aliases can be used interchangeably with original column names in formulas and inputs, making reports easier to understand for broader audiences.
Release: Both • Rapid: 2026-08-11 • Scheduled: 2026-08-11 -
2026-08-11Content & Collaboration
Users can reference multiple values in a single list parameter by selecting a grid range in Google Sheets, enabling flexible querying with BigQuery data.
When writing a query in Connected Sheets, users can now select a grid range in a sheet to define a list parameter, where each cell acts as a distinct value. This allows data admins and power users to set up input sheets with drop‑downs or direct cell selections for end‑users to filter data without editing the underlying query, broadening self‑service analytics.
Release: Both • Rapid: 2026-08-11 • Scheduled: 2026-08-11 -
2026-08-11Content & Collaboration
Excel pivot tables backed by table ranges now import as linked pivot tables in Google Sheets.
Sheets now fully supports importing Excel pivot tables that are backed by table ranges, preserving their link to the source data so they remain dynamic rather than being converted to static grids.
Release: Both • Rapid: 2026-08-11 • Scheduled: 2026-08-11 -
2026-08-11Content & Collaboration
Excel tables now import as Google Sheets tables, preserving formatting and structure.
When converting Excel files to Google Sheets, Excel tables are now imported as native Sheets tables, maintaining their formatting, structured references, and table-specific features, eliminating the need for manual reconstruction.
Release: Both • Rapid: 2026-08-11 • Scheduled: 2026-08-11 -
2026-07-29Content & Collaboration
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.
Release: Both • Rapid: 2026-07-29 • Scheduled: 2026-08-14 -
2026-07-20Content & Collaboration
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.
Release: Both • Rapid: 2026-07-20 • Scheduled: 2026-08-04 -
2026-07-07Content & Collaboration
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.
Release: Both • Rapid: 2026-07-07 • Scheduled: 2026-07-07 -
2026-07-01Content & Collaboration
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.
Release: Both • Rapid: 2026-07-01 • Scheduled: 2026-07-13 -
2026-06-22Content & Collaboration
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.
Release: Both • Rapid: 2026-06-22 • Scheduled: 2026-06-22 -
2026-06-18Content & Collaboration
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.
Release: Both • Rapid: 2026-06-18 • Scheduled: 2026-06-18 -
2026-05-27Content & Collaboration
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.
Release: Both • Rapid: 2026-05-27 • Scheduled: 2026-05-27 -
2026-04-22Content & Collaboration
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.
Release: Both • Rapid: 2026-04-22 • Scheduled: 2026-04-22 -
2026-04-22Content & Collaboration
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.
Release: Both • Rapid: 2026-04-22 • Scheduled: 2026-05-06 -
2026-04-07Content & Collaboration
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.
Release: Both • Rapid: 2026-04-07 • Scheduled: 2026-04-07