This official feed from the Google Workspace team provides essential information about new features and improvements for Google Workspace customers.
rss_feed

Google Sheets now supports compact form layout for pivot tables, which keeps multi-level pivot tables readable while reducing excessive horizontal scrolling. You can choose a layout directly from the pivot table editor:

  • Outline form: each row field is displayed in its own column
  • Compact form: all row fields are nested in a single column, with indentation and inline expand/collapse buttons showing the hierarchy

Compact form support also comes with enhanced Microsoft Excel import compatibility. Previously, importing Excel files containing compact form pivot tables into Sheets would convert them to outline form, changing the structure of the pivot table. Now, the source layout is preserved on import and maintained if the file is exported back to Excel.



Switching a pivot table to compact form layout in Google Sheets

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

We are making it easier to verify your AI-generated data and scale your workflows in Google Sheets. When you use the AI function to generate cell values, Gemini will now provide the exact web sources referenced directly within each individual cell. This cell-level source attribution gives you full visibility to audit, verify, and cross-reference outputs for greater trust and accuracy. Sources are attributed to each individual cell and are available in Google Sheets on the web.

In addition, upgraded processing delivers faster response times and improved cell-over-cell consistency, performing up to 55 times faster than manual entry for 500 cell tasks*. Combined with expanded capacity supporting up to 3,000 cells per request, you can summarize, categorize, and process more data in a single request.

*Data based on a 95-participant internal study comparing manual entry against Fill with Gemini on a 500-cell task using English prompts for English language users.


Easily audit and verify your Gemini-generated data in Google Sheets using the new cell-level web source citations.

Getting started

Rollout pace

Availability

  • Business: Business Standard and Plus
  • Enterprise: Enterprise Standard and Plus
  • Consumer: Google AI Pro and Ultra
  • Education Add-ons: Google AI Pro for Education
  • Other Add-ons: AI Expanded Access

Resources

Read More

Google Sheets now natively supports box and whisker charts, a statistical chart type that shows how a dataset is distributed. Select a range of raw numeric values and Sheets calculates the minimum, first quartile, median, third quartile, maximum, mean, and outliers for you, with no helper formulas needed. You can choose inclusive or exclusive quartile calculation and show or hide inner points, outliers, mean markers, and mean lines.

Box and whisker support also comes with enhanced Microsoft Excel import compatibility. Previously, importing Excel files containing box and whisker charts into Sheets would drop the chart entirely. Now, these charts are preserved on import with their data references, calculations, and formatting intact, and charts created in Sheets export back to Excel as editable box and whisker charts.



User creating a box and whisker chart in Google Sheets

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

We’re introducing a new way to analyze BigQuery data in Google Sheets. After connecting to BigQuery data with Connected Sheets, you can use Gemini to interact and analyze that data conversationally, right in Google Sheets. Gemini queries run against the full dataset in BigQuery, not just what’s visible in your spreadsheet. This means users can now ask questions on, analyze, and create views over super large data sets. Key use cases include:

  • Ask questions in natural language: Ask something like “What were total sales in the Northeast last quarter?” and get an answer based on your complete BigQuery data.
  • Dig deeper with follow-ups: Keep the conversation going with questions like “How does that compare to the same quarter last year?” or “Which products drove the increase?”

Ask Gemini to analyze and pull insights from your largest datasets in BigQuery
  • Go from analysis to dashboard: Describe what you need, such as “Build a quarterly sales review with revenue by region, a monthly trend, and our top 10 products.” Gemini will share its plan for you to review, then build a new spreadsheet tab with native, connected, refreshable objects like database formulas, pivot tables, and charts.

Gemini can create connected charts, pivot tables, and dashboards that are always up to date with scheduled refreshes

For business users, Gemini handles the legwork of completing their end to end analysis, from querying the data to garnering complex and nuanced insights from the data, to laying out the final dashboard for review, allowing them to get their work done faster without ever leaving Google Sheets. For data teams, this means a shorter backlog of one-off requests for reports and data pulls from BigQuery.

Getting started

  • Admins: This feature will be ON by default. There is no admin control for this feature.
  • End users: This feature will be available by default in spreadsheets connected to BigQuery, for users with permission to query the connected data. To get started, open the Gemini side panel in a connected spreadsheet. Visit the Help Center to learn more.

Rollout pace

Availability

  • Business: Business Standard and Plus
  • Enterprise: Enterprise Standard and Plus
  • Consumer: Google AI Pro and Ultra
  • Education Add-ons: Google AI Pro for Education
  • Other Add-ons: AI Expanded Access

Resources


Read More

Building upon the power of Gemini in Sheets on the web and our recent launch on Android devices, we’re excited to announce that you can now use Gemini in Google Sheets on your iOS device to quickly analyze and understand your data while on the go.

Simply tap on the Gemini spark icon, and you can ask questions about your data, generate analytical insights, and create charts. To help you get started, we've included suggested prompts such as “Summarize this table,” and “Analyze for insights.”

Finance Tracker:

Employee Tracker:

Getting started

  • Admins: There is no specific admin control for this mobile feature beyond the general Gemini for Google Workspace enablement at the domain/OU level. Visit the Help Center to learn more about managing Gemini access.
  • End users: This feature will be available by default for eligible users. To access it, open a compatible spreadsheet on your iOS device and tap the Ask Gemini icon. Visit the Help Center to learn more about using Gemini in Google Sheets.

Rollout pace

Availability

  • Business: Business Starter, Standard, and Plus
  • Enterprise: Enterprise Starter, Standard, and Plus
  • Education Add-ons: Google AI Pro for Education
  • Consumer: Google AI Plus, Pro, and Ultra

Resources



Read More

Google Sheets now supports new types of stock charts, making it easier to visualize price movement over time. Stock charts condense several price points for each time period into a single marker, so you can read a security's full trading range at a glance rather than interpreting separate line series. Users can create and customize the following stock chart types:

  • High-Low-Close (HLC): plots the highest price, lowest price, and closing price for each period, showing both the trading range and where the period settled
  • Open-High-Low-Close (OHLC): adds the opening price, so you can see the full session in one marker and immediately tell whether the period closed up or down

Both types are built for the workflows financial analysts already run in Sheets, from tracking equities and commodities to building valuation models on historical price data.

Sheets stock chart support also comes with enhanced Microsoft Excel import compatibility. Previously, importing Excel files containing stock charts into Sheets would result in these charts being dropped entirely, forcing analysts to rebuild them manually. Now, HLC and OHLC stock charts are accurately preserved when moving files between Excel and Sheets.



User creating a stock chart in Google Sheets

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

Developers can now programmatically create, read, and manage comments across Google Docs, Sheets, and Slides using their respective developer APIs. In Google Docs, this update also introduces API support for suggested edits, allowing automated tools and third-party systems to propose document revisions for user review rather than altering content directly.

These additions allow organizations and developers to connect internal review tools, automated content pipelines, and project tracking systems directly to Google Workspace editors. Key capabilities include:

  • Docs API: Programmatically add, review, and reply to comments, and submit proposed text changes as suggestions.
  • Sheets API: Programmatically add, review, and reply to comments on specific cells.
  • Slides API: Programmatically add, review, and reply to comments associated with individual slides and specific presentation elements.

Programmatic comment support within the Docs, Sheets, and Slides Model Context Protocol (MCP) servers remains in developer preview in accordance with the preview status of the MCP servers.

Rollout pace

Getting started

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

Google Sheets now supports custom sorting and manual reordering in pivot tables. Users can now drag and drop rows and columns on a pivot table to match specific presentation needs and custom business hierarchies, rather than being restricted to standard ascending or descending alphanumeric order. This launch includes the following capabilities:

  • On-grid drag-and-drop: Directly grab and move individual row or column headers with clear drop-zone indicators
  • Multi-item reordering: Select and reposition multiple rows or columns simultaneously
  • Hierarchical preservation: Automatically move nested child items alongside parent fields, maintaining structure across expand and collapse actions
  • Persistent sort states: Preserve custom arrangements across browser sessions, data refreshes, filtering, and layout adjustments

This update also delivers significant improvements for Microsoft Excel file interoperability. Previously, when importing Microsoft Excel workbooks containing pivot tables with manual or custom sort orders, Google Sheets defaulted back to ascending or descending order. Now, imported spreadsheets retain their pivot tables with the exact custom sort order preserved. Furthermore, exporting workbooks back to Microsoft Excel retains these sorted orders for seamless roundtrip compatibility.



User dragging and dropping row labels to manually reorder a pivot table in Google Sheets

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

We’re introducing a new manual calculation setting in Google Sheets to give you precise control over when formulas and other references update. The new manual calculation setting allows editors of complex or data-dense spreadsheets to pause automatic recalculation, batch their edits, and trigger a sheet-wide update at the exact moment they are ready to review the results.

Manual calculation offers users of especially complex Sheets a more streamlined, uninterrupted workspace for advanced analytical workflows. This feature is particularly useful for things like:

  • Uninterrupted high-volume updates: When pasting or modifying large blocks of data in spreadsheets  containing extensive formula networks (such as multi-sheet lookups and aggregations), you can enter all updates smoothly without intermediate recalculations running after every action.
  • Structured scenario modeling: When adjusting multiple assumption drivers in financial or forecasting models, you can input your variables sequentially and recalculate once. This ensures you only view the complete, final state of the scenario rather than partial, intermediate calculations.
  • Stabilizing volatile simulations: For spreadsheets utilizing volatile functions (such as random generators or live timestamps), manual calculation lets you freeze the data state so your numbers remain stable while you analyze results or present insights to key stakeholders.

Enabling Manual Calculation Mode


Controlling when Sheets calculates

Getting started

  • Admins:  There is no admin control for this feature.
  • End users: This feature will be OFF by default and can be enabled by the user by navigating to File > Settings > Calculation Settings in their Sheet. Visit the Help Center to learn more.

Rollout pace

Availability

  • Available to all Google Workspace customers and Workspace Individual subscribers

Resources

Read More

Update (October 13, 2026): We have updated this post to reflect changes in the naming of and functionality available within the Workday for Google Sheets add-on. Availability and setup remain unchanged.

Workday for Google Sheets is a new add-on available in the Google Workspace Marketplace that connects Adaptive from Workday (formerly known as Workday Adaptive Planning) directly to Google Sheets. This integration eliminates the need for manual CSV downloads and static spreadsheet exports, allowing financial analysts, business leaders, and cross-functional contributors to build dynamic reports, perform ad-hoc variance analysis, and submit plan updates while maintaining complete data integrity–all without leaving Google Sheets. Shorten planning cycles and surface strategic insights faster with key features including:

  • Dynamic ad-hoc reporting: Pull live Adaptive accounts, dimensions, levels, versions, and time periods into Google Sheets, with the flexibility to rearrange elements across rows, columns, and filters and refresh reports at any time to reflect the latest model updates.
  • Reusable report templates and rolling dates: Configure relative time periods and report dates so monthly and quarterly reporting packs roll forward automatically, or use Duplicate Report in Report Actions to copy an existing report’s layout, filters, and expand/collapse states into a new tab in the same workbook.
  • Interactive hierarchy exploration and cell drill-down: Expand and collapse account, level, and dimension hierarchies directly on the sheet, focus your view with Keep Only and Remove Only member filters, and use Explore Cell to trace numbers back to underlying Adaptive details.
  • Governed two-way data writeback: Make budget edits, driver uploads, and "what-if" forecast adjustments directly at valid leaf-level intersections using standard Google Sheets formulas, then submit changes back to Adaptive. Editable cells are clearly marked, existing Adaptive access rules and writeback permissions are enforced, and every submitted change is logged in the Audit Trail.

Workday for Google Sheets: Dynamic Ad-hoc Reporting

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers, Workspace Individual subscribers, and users with personal Google accounts (Adaptive from Workday license required; included at no additional cost for Adaptive from Workday customers)

Resources

Read More

Building upon the power of Gemini in Sheets on the web, we’re excited to announce that you can now use Gemini in Google Sheets on your Android device to quickly analyze and understand your data while on the go.

Simply tap on the Gemini spark icon, and you can ask questions about your data, generate analytical insights, and create charts. To help you get started, we've included suggested prompts such as “Summarize this table,” and “Analyze for insights.”




(Please note: Mobile capabilities are currently focused on data analysis and insights. To perform complex edits, formatting actions, or generate formulas, please use Gemini in Google Sheets on the web).

Getting started

  • Admins: There is no specific admin control for this mobile feature beyond the general Gemini for Google Workspace enablement at the domain/OU level. Visit the Help Center to learn more about managing Gemini access.
  • End users: This feature will be available by default for eligible users. To access it, open a compatible spreadsheet on your Android device and tap the Ask Gemini icon. Visit the Help Center to learn more about using Gemini in Google Sheets.

Rollout pace

Availability

  • Business: Business Standard and Plus
  • Enterprise: Enterprise Standard and Plus
  • Education: Google AI Pro for Education
  • Consumer: Google AI Pro and Ultra

Resources

Read More

We’re committed to continuously improving Sheets to ensure it is a powerful, responsive, and scalable spreadsheet tool for your needs. To that end, we’ve increased the cell limit in Google Sheets from up to 10 million cells to up to 20 million cells. This limit applies to new, existing, and imported files.

Whether you are building a new spreadsheet from scratch, expanding an existing workbook, or importing large datasets from Microsoft Excel (.xlsx) or CSV files, Google Sheets now supports up to 20 million cells per spreadsheet.

Coming soon, we also plan to increase the file byte size limit for imported spreadsheets, making it easier to bring extensive datasets from other spreadsheet formats directly into Google Sheets.

Getting started

  • Admins: There is no admin control for this feature.
  • End users: There is no end-user setting for this feature. The expanded limit will apply automatically when creating, expanding, or importing spreadsheets.

Rollout pace

Availability

  • Available to all Google Workspace customers, Workspace Individual subscribers, and users with personal Google accounts

Resources

Read More

We are introducing a new, dedicated formula editor dialog for creating and editing calculated fields within pivot tables in Google Sheets. This update streamlines how you build custom formulas and derived metrics, making data analysis faster and more accurate.

Specifically, this new update introduces:

  • A dedicated formula editor dialog for creating and modifying custom calculations
  • Field selection menus to insert column names without manual typing
  • Real-time syntax and formula validation to catch errors before applying changes 

Previously, creating calculated fields in Google Sheets required entering formulas into inline sidebar cards, which involved manual typing of exact field names and lacked live error checking. With this update, calculated fields can be created and managed with greater speed and accuracy, ensuring formulas remain consistent and easy to maintain across spreadsheets.

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

Google Sheets now supports the full Google Fonts web font library directly within charts. Users can now select “More fonts” from any font dropdown inside the chart editor sidebar to search, add, and apply custom web fonts across key chart text elements. This expanded font support is available for:

  • Chart titles and subtitles
  • Horizontal and vertical axis titles and labels
  • Data labels
  • Legend text

Additionally, this launch enhances import and export compatibility with Microsoft Excel to preserve a wider range of fonts across both platforms. Previously, importing Excel files containing charts with custom fonts would result in missing or fallback font substitutions. Now, custom fonts present in both platforms are seamlessly preserved during file import and export, ensuring visual consistency and brand fidelity when moving spreadsheets between Google Sheets and Microsoft Excel.



User selecting a custom web font in the Google Sheets chart editor

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources



Read More

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 now retained directly in the pivot table editor sidebar as reusable source fields. This allows you to unassign grouped fields 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. Previously, when importing Microsoft Excel files containing pivot tables with grouped fields into Google Sheets, those custom groupings were dropped from the field list, requiring manual recreation. With this update, grouped field configurations are accurately preserved when importing/exporting spreadsheet files.



Grouped fields retained as reusable source fields in the Google Sheets pivot table editor sidebar

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

We’re excited to launch Sheets canvas, a new Gemini-powered capability that transforms your spreadsheets into custom, interactive, read-write applications using simple natural language prompts. It acts as a dynamic visualization layered directly on top of your spreadsheet data, allowing you and your team to work in layouts that best fit your workflows. 

Whether you need to coordinate cross-functional deliverables or present core insights from dense data to an executive team, Sheets canvas can deliver the visual tool for the job. Key capabilities include: 

  • End-to-end creation: Build an advanced visualization with a single natural language prompt without requiring coding, formulas, or third-party tools. 
  • Fully read-write: Changes made in the canvas, such as dragging task cards or adding new entries, instantly update your source sheet. Likewise, any updates to the source sheet reflect in your canvas in real time. 
  • Flexible adjustments: Continue to polish and refine your Sheets canvas by prompting Gemini to make edits to layout, design, functionality, and more. 
  • Familiar sharing tools: Because Sheets canvas is built directly inside Google Sheets, it inherits the same sharing settings as your spreadsheet, making it effortless to collaborate in real time. 
For example, if you’re a financial analyst working out of a budget spreadsheet, you can ask Gemini to “Build an interactive dashboard that helps me analyze how different cost drivers impact a quarterly budget.” If you’re an operations lead overseeing logistics, you can simply prompt Gemini to “Create a custom tracker to visualize regional field assignments.” 

Users can build a wide variety of applications with Sheets canvas. Here are just a few examples:


Kanban board: Group tasks by workflow stage, and drag and drop cards to update progress in real time 


Dashboard: Create a financial forecasting model with dynamic scenario planning


Whiteboard: Conduct a virtual brainstorming session with sticky notes 

Note: This feature is currently only available on the web to accounts with language set to English.

Getting started 

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on August 10, 2026 
  • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 31, 2026 

Availability 

  • Business: Business Standard and Plus 
  • Enterprise: Enterprise Standard and Plus 
  • Consumer: Google AI Pro and Ultra Education 
  • Add-ons: Google AI Pro for Education AI Add-ons: AI Expanded Access 
Note: Creating and editing Sheets canvases is subject to per-user usage limits. See the Help Center for more information. 

Resources 


Read More

Google Workspace is introducing two usability enhancements to Connected Sheets to improve data presentation and give more flexibility when analyzing BigQuery data. 

List parameters: When writing a query, users can reference multiple values in a single list parameter by selecting a grid range in a sheet. Each cell will function as a unique value in the list. This enables more flexible or robust querying based on values already in the sheet. For example, this feature allows data admins and power users to configure input sheets that allow collaborators or end users to easily select options via drop-down or in the sheet for advanced filtering without needing to modify the underlying query. As a result, more users can independently self-serve insights and interact with Connected Sheets. 

Column aliasing: Users can create aliases for BigQuery column names directly within the Connected Sheet. Database column names can sometimes be unwieldy or lack contextual information for broader audience readability. Aliasing provides a way to substitute presentation-ready labels in the Connected Sheets interface without altering the underlying database reference. Users can continue to refer to columns by either the new alias or the original name in formulas and inputs.





Getting started 

Rollout pace 

Availability 

  • Available to all Google Workspace customers and users with personal Google accounts 

Resources 

Read More

We’re introducing two key improvements in Google Sheets that preserve formatting and linked data when converting files from Microsoft Excel. First, Excel tables will now seamlessly import as Sheets tables. Second, Sheets now fully supports importing Excel pivot tables that are backed by table ranges.

Previously, when converting Excel files, Excel tables did not import as Sheets tables, causing users to miss out on the structural and formatting benefits of tables, and pivot tables linked to tables were replaced with static grids. These updates ensure your data structures remain intact and beautifully formatted upon import. Most importantly, your imported spreadsheets will be ready to use right away, no manual reconstruction needed.



Table with linked pivot table imported into Google Sheets

Getting started

Rollout pace

Table imports

Linked pivot table imports

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

Google Sheets now supports creating and editing scatter charts with multiple independent x-series. This update allows users to map separate data series to their own unique x-axis, rather than forcing all series in a single chart to share the same horizontal axis domain.

Additionally, this feature improves import and export compatibility with Microsoft Excel. Previously, importing Excel files with multiple x-series scatter charts into Google Sheets would drop the extra axes and revert to a single x-axis. Now, these configurations are accurately preserved when moving spreadsheets between platforms.



User creating a scatter chart with multiple x-series in Google Sheets

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

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, enabling complex dataset visualization with different scales and metrics without requiring manual re-plotting. These include:

  • Clustered Column - Line
  • Clustered Column - Line on Secondary Axis
  • Custom Combo
Sheets combo chart support also comes with enhanced Microsoft Excel import compatibility. Previously, importing external files that contained combo charts with a secondary axis would result in the secondary axis being dropped. This update ensures that secondary axis configurations and combo chart types are preserved during file import.


User creating a combo chart in Google Sheets

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers and users with personal Google accounts

Resources

Read More

Useful Links

Join the official community for Google Workspace administrators

In the Google Cloud Community, discuss the latest features with Googlers and other Google Workspace admins like you. Learn tips and tricks that will make your work and life easier. Be the first to know what's happening with Google Workspace.

Learn about more Google Workspace launches

On the “What’s new in Google Workspace?” Help Center page, learn about new products and features launching in Google Workspace, including smaller changes that haven’t been announced on the Google Workspace Updates blog.

Learn about our customers

Discover how a diverse range of organizations, from small businesses and nimble startups to globally recognized Fortune 500 corporations, leverage the collaborative power of Google Workspace. Explore examples of how teams of are streamlining workflows and driving productivity by utilizing Google-Workspace.