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
- Admins: There is no admin control for this feature.
- End users: Visit the Help Center to learn more about customizing pivot tables in Google Sheets.
Rollout pace
- Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 25, 2026
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 14, 2026
Availability
- Available to all Google Workspace customers and users with personal Google accounts
Resources
- Google Docs Editors Help: Create & use pivot tables
- Google Docs Editors Help: Customize pivot tables