Google Workspace Changes

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.

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.

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.

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).

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.

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.