All Google Sheets updates
201 updates to Google Sheets tracked so far. Most recent: 2026-10-28 — Fill with Gemini in Google Sheets now provides cell-level web source citations and supports larger requests up to 3,000 cells.
-
2026-10-28Content & Collaboration
Fill with Gemini in Google Sheets now provides cell-level web source citations and supports larger requests up to 3,000 cells.
Fill with Gemini in Google Sheets now provides cell-level citations for web sources, giving users full visibility to audit, verify, and cross-reference AI-generated data directly within each individual cell. The update also delivers upgraded processing with faster response times, improved cell-over-cell consistency, and expanded capacity supporting up to 3,000 cells per request, performing up to 55 times faster than manual entry for 500-cell tasks.
Release: Both • Rapid: 2026-10-20 • Scheduled: 2026-10-20 -
2026-10-28Content & Collaboration
Google Sheets adds compact form layout for pivot tables with improved Microsoft Excel import/export compatibility.
Google Sheets now supports compact form layout for pivot tables, keeping multi-level pivot tables readable while reducing excessive horizontal scrolling. Users can choose between Outline form and Compact form directly from the pivot table editor. The update also preserves compact form pivot table structure when importing from and exporting back to Microsoft Excel.
Release: Both • Rapid: 2026-10-22 • Scheduled: 2026-11-06 -
2026-10-22Content & Collaboration
Google Sheets now natively supports box and whisker charts with enhanced Microsoft Excel import and export compatibility.
Google Sheets now natively supports box and whisker charts, a statistical chart type that shows how a dataset is distributed. Users can select a range of raw numeric values and Sheets automatically calculates the minimum, first quartile, median, third quartile, maximum, mean, and outliers with no helper formulas needed. Options include inclusive or exclusive quartile calculation and the ability to show or hide inner points, outliers, mean markers, and mean lines. The update also adds enhanced Microsoft Excel import compatibility: box and whisker charts imported from Excel are preserved with their data references, calculations, and formatting intact, and charts created in Sheets export back to Excel as editable box and whisker charts.
Release: Both • Rapid: 2026-10-22 • Scheduled: 2026-11-06 -
2026-10-19Content & Collaboration
Gemini in Google Sheets is now available on iOS devices, allowing users to ask questions, generate insights, and create charts on the go.
Gemini in Google Sheets, previously available on the web and Android, is now rolling out to iOS devices. Users can tap the Gemini spark icon to ask questions about their data, generate analytical insights, and create charts, with suggested prompts like 'Summarize this table' and 'Analyze for insights.' Admins manage access via the general Gemini for Google Workspace setting, while end users see the feature by default. The rollout began October 15, 2026 for both Rapid and Scheduled release domains, with gradual availability over up to 15 days. It is available for Business Starter, Standard, and Plus; Enterprise Starter, Standard, and Plus; Education Add-ons (Google AI Pro for Education); and Consumer plans (Google AI Plus, Pro, and Ultra).
Release: Both • Rapid: 2026-10-15 • Scheduled: 2026-10-15 -
2026-10-19Content & Collaboration
Gemini in Google Sheets now enables natural‑language analysis of BigQuery data, allowing conversational queries, insights, and dashboard creation directly within Sheets.
Starting October 19, 2026, Google Sheets users with access to BigQuery can leverage Gemini’s natural language capabilities to query, analyze, and visualize large datasets directly within Sheets. By asking questions like "What were total sales in the Northeast last quarter?" users receive answers based on the full BigQuery dataset, can follow up for deeper insights, and instruct Gemini to build refreshable dashboards with charts, pivot tables, and formulas. The feature rolls out gradually over up to 15 days for both Rapid and Scheduled Release domains, and is available for Business Standard/Plus, Enterprise Standard/Plus, Google AI Pro/Ultra consumers, and Education AI Pro add‑on.
Release: Both • Rapid: 2026-10-19 • Scheduled: 2026-10-19 -
2026-10-05Content & Collaboration
Google Sheets now supports new High-Low-Close (HLC) and Open-High-Low-Close (OHLC) stock chart types, with improved Excel import compatibility.
Google Sheets introduces High-Low-Close (HLC) and Open-High-Low-Close (OHLC) stock chart types that condense multiple price points per period into a single marker, enabling quick visualization of a security's trading range and settlement. These charts fit seamlessly into financial analysts' existing workflows for tracking equities, commodities, and building valuation models. Additionally, Sheets now preserves HLC and OHLC charts when importing Excel files, eliminating the need to rebuild them manually.
Release: Both • Rapid: 2026-10-05 • Scheduled: 2026-10-22 -
2026-09-30Content & Collaboration
Google Sheets API now supports programmatic creation, reading, and replying to comments on individual cells.
Developers can use the Google Sheets API to add, review, and reply to comments attached to specific cells, allowing integration of internal review tools and project tracking systems with spreadsheet data.
Release: Both • Rapid: 2026-09-30 • Scheduled: 2026-09-30 -
2026-09-22Content & Collaboration
Google Sheets adds manual reordering and custom sorting to pivot tables with drag‑and‑drop, multi‑item moves, hierarchical preservation, persistent states, and improved Excel interoperability.
Google Sheets now lets users manually reorder and custom sort pivot tables directly on the grid. Users can drag and drop individual row or column headers, select multiple items for simultaneous reordering, and have nested child items move with their parents to maintain hierarchy. Custom sort arrangements persist across browser sessions, data refreshes, filtering, and layout changes. The update also enhances Microsoft Excel file compatibility: imported Excel workbooks retain their custom pivot table sort order, and exported sheets preserve that order for seamless round‑trip use.
Release: Both • Rapid: 2026-09-22 • Scheduled: 2026-10-05 -
2026-09-21Content & Collaboration
New Workday for Google Sheets add-on brings AI-powered Adaptive Planning data directly into Sheets and Slides.
Workday for Google Sheets is a new add-on available in the Google Workspace Marketplace that connects Workday Adaptive Planning directly to Google Sheets and Slides. Integrated with the AI-powered “Ask Workday” feature, it enables natural language summaries, variance analysis, automated anomaly detection, smart visualizations, and dynamic ad‑hoc reporting without manual CSV downloads, allowing financial analysts to build live reports and surface insights faster.
Release: Both • Rapid: 2026-09-21 • Scheduled: 2026-09-21 -
2026-09-21Content & Collaboration
New manual calculation setting in Google Sheets lets users pause automatic recalculation and trigger updates on demand.
Google Sheets introduces a manual calculation mode that enables editors of complex or data-dense spreadsheets to suspend automatic formula recalculation, batch edits, and initiate a sheet-wide update when ready. This supports uninterrupted high-volume updates, structured scenario modeling, and stabilizing volatile simulations. The feature is off by default and can be enabled via File > Settings > Calculation Settings, with no admin controls. Rollout begins September 21, 2026 for both Rapid and Scheduled Release domains, completing within up to 15 days.
Release: Both • Rapid: 2026-09-21 • Scheduled: 2026-09-21 -
2026-09-10Content & Collaboration
Google Sheets cell limit increased to up to 20 million cells.
Google Sheets has increased its cell limit from up to 10 million cells to up to 20 million cells, applicable to new, existing, and imported spreadsheets, including those from Excel (.xlsx) or CSV files. The change is rolling out gradually over up to 15 days for Rapid Release domains starting September 10, 2026, and for Scheduled Release domains starting September 28, 2026. No admin or end-user settings are required. A future increase to the file byte size limit for imported spreadsheets is also planned.
Release: Both • Rapid: 2026-09-10 • Scheduled: 2026-09-28 -
2026-09-09Content & Collaboration
Introduces a dedicated formula editor dialog for creating and editing calculated fields in Google Sheets pivot tables.
Google Sheets now offers a dedicated formula editor dialog for creating and editing calculated fields within pivot tables, complete with field selection menus to insert column names without manual typing, real-time syntax and formula validation to catch errors before applying changes, and improved speed and accuracy over the previous inline sidebar method.
Release: Both • Rapid: 2026-09-08 • Scheduled: 2026-09-21 -
2026-09-08Content & Collaboration
Google Sheets now supports custom web fonts in charts, allowing users to select from the full Google Fonts library and improving font compatibility with Microsoft Excel.
Google Sheets adds support for the full Google Fonts web font library directly within charts. Users can select “More fonts” from any font dropdown in the chart editor sidebar to search, add, and apply custom web fonts to chart titles and subtitles, axis titles and labels, data labels, and legend text. The update also enhances import/export compatibility with Microsoft Excel, preserving custom fonts that exist in both platforms during file transfers. There is no admin control for this feature. Rollout begins September 1, 2026 for Rapid Release domains (up to 15 days) and September 21, 2026 for Scheduled Release domains (up to 15 days).
Release: Both • Rapid: 2026-09-01 • Scheduled: 2026-09-21 -
2026-08-25Content & Collaboration
Google Sheets now preserves grouped pivot table fields as reusable source fields and improves Excel interoperability.
Google Sheets now supports grouped field persistence for pivot tables. When you create custom groupings or work with grouped date, time, or numeric fields, these fields are retained directly in the pivot table editor sidebar as reusable source fields, allowing you to unassign them from your active table layout without losing their underlying configuration, making it easy to re-add or modify them at any time. Additionally, this update improves interoperability with Microsoft Excel (.xlsx) files by preserving grouped field configurations when importing/exporting spreadsheet files, eliminating the need to manually recreate groupings.
Release: Both • Rapid: 2026-08-25 • Scheduled: 2026-09-14 -
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
