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

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. Deeply integrated with the AI-powered “Ask Workday” feature in Adaptive Planning, this add-on eliminates the need for manual CSV downloads. Financial analysts and business leaders can build dynamic reports, perform ad-hoc variance analysis, and maintain complete data integrity without leaving Google Sheets. Shorten planning cycles and surface strategic insights faster with key AI-driven features including:

  • Natural language summaries and variance analysis: Ask questions or use suggested prompts to get instant summaries, compare plan versions against actuals, and break down performance drivers across time periods and custom dimensions.
  • Automated anomaly detection: Automatically identify unexpected data points, outliers, and trend shifts across account hierarchies to quickly focus attention on critical variances.
  • Smart visualizations: View AI-generated charts and tables based on custom queries, switch visualization formats on the fly, copy findings into new spreadsheet tabs for further ad-hoc work, or export directly into Google Slides.
  • Dynamic ad-hoc reporting: Pull live Adaptive Planning accounts, dimensions, and time periods into Google Sheets, with the flexibility to rearrange elements and refresh reports at any time to reflect the latest model updates.


    Workday for Google Sheets: Dynamic Ad-hoc Reporting


Ask Workday: Summarize this report


Ask Workday: Detect anomalies

Getting started

Rollout pace

Availability

  • Available to all Google Workspace customers, Workspace Individual subscribers, and users with personal Google accounts (Workday Adaptive Planning license required)

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

Earlier this year, we announced Fill with Gemini in Google Sheets, a new AI-powered feature designed to make data preparation and manual entry even easier. Leveraging the capabilities of the AI function in Google Sheets, Fill with Gemini eliminates the need for complex formulas, helping you easily generate text, summarize information, categorize data, or analyze sentiment at scale with generated content appearing directly in the cells you choose.

Previously available in English, Spanish, Portuguese, Japanese, Korean, French, Italian, and German, both Fill with Gemini and the AI function are now expanding to users in Mandarin, Dutch, Malay, Hebrew, Polish, Turkish, Czech, Indonesian, Swedish, Danish, and Norwegian.


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
  • AI Add-ons: AI Expanded Access*

*Starting July 15, 2026, users with AI Expanded Access licenses will have higher limits on usage of Fill with Gemini and the AI function in Sheets. 

Resources

Read More

Google Sheets now fully supports the import of 3D bar charts. Previously, when users imported files containing 3D bar charts into Sheets, they would be displayed as 2D bar charts. With this update, importing these types of files, including from Microsoft Excel, will yield a more seamless experience.


3D bar chart imported into Google Sheets

Getting started

Rollout pace

Availability

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

Resources

Read More

We’re excited to introduce a new Gemini in Sheets capability that enables you to diagnose and fix formula errors in one click. When you encounter a formula error, Gemini can analyze the surrounding data structure to help provide an easy-to-understand explanation of the core issue alongside a corrected version of the formula. The functionality seamlessly supports everything from basic arithmetic to highly intricate calculations, simplifying what is traditionally a frustrating and time-consuming debugging process.

Since Gemini is built directly in Sheets, it removes the barrier to writing complex formulas for advanced analysis right where you work. This ensures that both novice users and seasoned data analysts can maintain momentum without having to manually parse error messages or search external forums for solutions.


GIF showing formula fixing functionality


Getting started


Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for the improved Gemini in Sheets experience, allowing users to experiment with this feature.. Per-user usage limits will apply after July 15; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.

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*
*After July 15, 2026, users with AI Expanded Access licenses will have higher limits on usage of this feature.

Resources

Read More

Earlier this year, we introduced new Gemini in Sheets capabilities that allow you to build and edit entire spreadsheets using simple natural language. We’re now expanding support for these features to 28 additional languages, enabling users who speak Spanish, Portuguese, Japanese, Korean, Italian, French, German, Chinese Simplified, Dutch, Hebrew, Polish, Turkish, Czech, Indonesian, Malay, Swedish, Danish, Norwegian, Arabic, Finnish, Vietnamese, Ukrainian, Greek, Thai, Romanian, Russian, Catalan, and Hungarian to collaborate natively with Gemini in their preferred language.

With this update, users can leverage the full functionality of Gemini to build and edit spreadsheets by issuing prompts in their native language. Whether users are updating budgets, building complex financial models, or conducting data analysis, Gemini leverages Sheets tools—such as tables, pivot tables, charts, and formulas—to execute tasks. This enables global teams to manage data more efficiently, automate workflow execution, and extract valuable cross-document insights without confronting language barriers.


Gemini in Sheets UX in Spanish language

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
Note: Through July 15, 2026, Workspace customers get promotional access to higher limits for the improved Gemini in Sheets experience. Per-user usage limits will apply after July 15; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.

Resources

Read More

You can now easily identify critical irregularities and outliers in your time-series data when using Connected Sheets to analyze BigQuery data sets from Google Sheets. Anomaly detection in Connected Sheets allows users to distinguish between expected trends and true outliers without requiring manual model training or complex SQL knowledge.

Powered by BigQuery ML and TimesFM, this capability delivers "zero-shot" analysis, meaning you can uncover actionable AI insights immediately—no need to configure or wait for a model to be trained on your data. Anomaly detection also builds upon our recently introduced forecasting feature to provide a more comprehensive suite of predictive tools right where you already work.

Key features include:

  • Easy, SQL-free configuration: A user-friendly side panel guides you through configuring your anomaly detection analysis without writing a single line of SQL.
  • Clear, built-in formatting: Results are cleanly rendered with new columns for is_anomaly (a boolean indicator) and lower_bound/upper_bound intervals to help you quickly sort, filter, and interpret the findings. 
  • Customizable thresholds: Take control of your analysis by setting a specific time period, anomaly probability threshold (defaulting to 0.95), and filtering input data
  • Automated refresh ability: Just like other Connected Sheets objects, your anomaly detection extracts can be scheduled to refresh automatically, ensuring your insights are always current.

Getting started

  • Admins: There is no admin control for this feature.
  • End users: Access to anomaly detection in Connected Sheets requires permissions to a BigQuery project with billing enabled.

Rollout pace

Availability

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

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’re announcing significant performance improvements across the entire Sheets experience, especially for larger data sets, making it faster than ever to import, analyze, and manage your data.

Some of the key Sheets journeys we’ve optimized to help you work with larger datasets more efficiently include:

  • Get started faster: You can now open and start working in large spreadsheets (1M+ cells) up to 30% faster. 
  • Rapid data analysis: You can now filter large spreadsheets (1M+ cells) up to 60% faster.
  • Easier formatting: You can now apply conditional formatting to large spreadsheets (1M+ cells) up to 60% faster.
These enhancements are part of our broader effort to ensure a smooth experience even as your spreadsheets grow in complexity.

Beta now available: Sheets capacity doubled to 20 million cells

Alongside faster analysis, we’re opening a new beta program to give users early access to doubled cell limits in Google Sheets—from 10 million cells to 20 million cells. This limit applies to new, existing, and imported files. Fill out the form to register your organization for the beta program and double Sheets limits.

Getting started

Rollout pace

Availability

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

Resources

Read More

We're introducing Fill with Gemini in Google Sheets, a new AI-powered feature designed to make data preparation and manual entry even easier. Fill with Gemini infers your intent, allowing you to populate data 9x faster than manual entry for 100-cell tasks.*

Whether you need to extract information from the web or categorize existing data, Fill with Gemini handles the heavy lifting, eliminating the need for complex formulas. For example, a marketing team can use it to automatically generate suggested responses based on customer feedback messages, or a small business owner could use it to quickly fill out product details just by describing what they need.

Fill with Gemini offers two ways to enrich your data, saving you time and effort:

  • Drag-and-drop: If your column has at least one completed cell, you can use a new drag entry point to fill the column based on the context of the table.
  • Prompt-based filling: For empty multi-cell selections, you can use a one-click entry point to "Fill" the range. You can either automatically fill cells when a column has at least one completed cell or write a custom prompt to fit your specific needs.


*Data based on a 95-participant study comparing manual entry against Fill with Gemini on a 100-cell task.

Getting started

Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for AI function in Google Sheets, allowing users to experiment with these features. Per-user usage limits will apply after that date; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.

Rollout pace

Availability

  • Business: Business Standard and Plus
  • Enterprise: Enterprise Standard and Plus
  • AI Add-ons: AI Expanded Access*; AI Ultra Access*; Google AI Pro for Education
  • Consumer: Google AI Pro and Ultra
*Once promotional limits are no longer in effect, users with AI Expanded Access and AI Ultra Access add-on licenses will have higher limits on usage of AI function in Google Sheets.

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.