Apply compact form layout for pivot tables in Google Sheets
Google Workspace Updates ·
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:
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.