Google Workspace Updates
Follow
Apply compact form layout for pivot tables in Google Sheets
Google Sheets has introduced a compact form layout option for pivot tables. This feature improves the readability of multi-level pivot tables by minimizing horizontal scrolling and nesting row fields in a single column. Users can select this layout directly from the pivot table editor. The compact form displays hierarchy through indentation and inline expand/collapse buttons. This update also enhances compatibility when importing Microsoft Excel files containing compact form pivot tables. Previously, these were converted to outline form, but now their original structure is preserved. Users can switch to compact form for better organization and easier navigation within their data. No admin controls are necessary for this feature, making it accessible to all users. The rollout began on October 22, 2026, for Rapid Release domains and will start on November 6, 2026, for Scheduled Release domains. This new layout is available to all Google Workspace customers and users with personal Google accounts.