Google Sheets just got a lot smarter for anyone who lives in pivot tables. Starting this week, the spreadsheet app now keeps your grouped fields alive even after you remove them from a pivot layout, and it preserves those groupings when you move files between Sheets and Excel.

If you have ever built a pivot table in Google Sheets, you know the drill. You drag in a date field, group it by month or quarter, maybe create a custom numeric range for revenue buckets, and spend a few minutes tuning the view until it finally tells the story you want. Then you decide to try a different angle, unassign that grouped field, and poof: the grouping is gone. Next time you need it, you rebuild it from scratch.

That is the exact pain point Google is addressing with its latest Sheets update, announced on its Workspace Updates blog on August 24, 2026. The feature is called grouped field persistence for pivot tables, and while the name sounds technical, the benefit is simple: your custom groupings now stick around as reusable source fields in the pivot editor sidebar, even if you temporarily remove them from the table.

In practice, that means you can drag a grouped date field into Rows, test a layout, then pull it out without losing the underlying configuration. When you want that same grouping again, you just re-add it with a click instead of recreating the logic. For teams that iterate on reports weekly or monthly, that is a meaningful quality-of-life upgrade.

Better Excel interoperability, too

The second half of this update matters just as much for people who work across Google Sheets and Microsoft Excel. Historically, when you imported an Excel file with pivot tables that used grouped fields, Sheets would drop those groupings from the field list. You would end up with the raw data and a broken pivot setup, forcing you to manually rebuild the groups.

With this change, grouped field configurations are now accurately preserved when importing and exporting spreadsheet files between the two platforms. That makes Sheets a safer destination for workbooks you did not build yourself, and it reduces friction for organizations that standardize on Excel but occasionally collaborate in Google Workspace.

This follows a broader push from Google to improve Excel compatibility in Sheets. Earlier in August, the company rolled out better support for importing Excel tables and linked pivot tables backed by table ranges, so formatting and data connections survive the transition more reliably. Grouped field persistence is the next logical step in that interoperability story.

It is easy to treat pivot tables as a legacy feature in an era of AI-powered dashboards and no-code analytics tools. But for many analysts, marketers, and small-business operators, pivot tables remain the fastest way to turn a messy dataset into a clear summary. They are built into Sheets, require no extra subscriptions, and update automatically when the source data changes.

What has held some power users back is the fragility of advanced setups. Custom groupings by date, time, or numeric ranges are incredibly useful, but if the tool does not remember them, people stop investing time in building them. By making those groupings persistent and portable, Google is effectively encouraging more sophisticated use of Sheets without adding new complexity to the interface.

Who gets this and when

According to Google’s rollout notes, grouped field persistence for pivot tables is available to all Google Workspace customers and users with personal Google accounts. The feature began rolling out on August 25, 2026, for Rapid Release domains, with visibility spreading over up to 15 days. Scheduled Release domains will start seeing it from September 14, 2026, again with a gradual rollout window.

If you are not sure which release track your organization uses, the easiest way to check is to open a spreadsheet, create or edit a pivot table, and look at the source field list in the sidebar. Grouped fields should now appear as reusable entries rather than existing only inside the current layout.

How to use it in your workflow

You do not need to learn any new commands to take advantage of this. The workflow looks like this:

• Create a pivot table as usual via Insert > Pivot table.
• Add a date, time, or numeric field and apply your desired grouping (by month, quarter, custom ranges, etc.).
• Notice that the grouped field now shows up in the sidebar’s source field list as its own reusable item.
• Feel free to remove it from Rows or Columns to test other views. The grouping configuration remains saved.
• When you want that same grouping again, drag it back in instead of rebuilding it.

For Excel users, the benefit is even simpler: import your .xlsx file with grouped pivot fields, and Sheets will keep those groupings intact. Export back to Excel, and they remain preserved on that side as well.

This is not a flashy AI feature or a headline-grabbing redesign. It is the kind of under-the-hood improvement that regular Sheets users will notice only when they realize they no longer have to redo the same work. Over weeks and months, that adds up to less frustration, more consistent reporting, and fewer “who broke the pivot?” moments in shared workbooks.

For a platform that hundreds of millions rely on for everything from monthly sales reports to classroom gradebooks, these small reliability gains matter. And for anyone who has ever sighed while re-creating a grouped date field for the third time this quarter, it is a welcome sign that Google is still investing in the core spreadsheet experience, not just the AI-powered extras.