Google Sheets: Apply compact form layout for pivot tables

What’s changed?

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:

  • Outline form: each row field is displayed in its own column
  • Compact form: all row fields are nested in a single column, with indentation and inline expand/collapse buttons showing the hierarchy

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.

Resources

More information