Google Sheets Compact Pivot Tables: What Changed

Google Sheets compact pivot table layout is a new option for people whose summaries have become too wide to read comfortably. Announced on 28 October 2026, the layout changes how row groups are presented. It is useful to understand the difference between changing a table’s appearance and changing the calculation behind it before using the feature in a report.

What compact layout does

Google’s compact pivot layout announcement describes placing hierarchical row groups in one column with indentation. The existing outline approach uses separate columns for row fields. The announcement also describes preserving compact layout during Excel import and export.

Rapid Release rollout began on 22 October, with Scheduled Release beginning on 6 November. Google lists availability for Workspace customers and personal accounts.

A staged rollout means that two accounts may not show the option at the same time. Check the current feature availability before assuming that an older spreadsheet or browser is the cause.

When compact layout is useful

Consider a report grouped by region, branch and product category. Separate columns can make the hierarchy clear, but they also consume horizontal space before the reader reaches the values.

A compact layout can make that report easier to fit into a narrow view or a presentation. The trade-off is that readers must understand indentation and grouping instead of following a separate column for every level.

Choose based on the audience. Someone reviewing a high-level summary may prefer a compact view, while someone extracting individual fields for another process may find the outline arrangement easier to work with.

Check the calculation before changing the display

Before switching layouts, record the grand total and a few meaningful subtotals. Check the filters, value fields and aggregation method.

That gives you a baseline for verifying the report afterwards. A layout change should not become an excuse to overlook a filter that was already excluding important data.

If a number looks wrong, investigate the source range and calculation rather than assuming the compact view created the problem. Presentation and calculation are related parts of a report, but they are different things to diagnose.

Make the hierarchy understandable

After applying the layout, inspect the group labels and indentation. A reader should be able to tell which items belong together without needing the author to explain each row.

Use clear field names and avoid relying entirely on colour. If two levels have similar names, consider whether the source labels need clarification before the summary is distributed.

Check both collapsed and expanded states if your workflow uses them. A view that looks tidy while collapsed may become difficult to scan when every subgroup is visible.

Review copies and exported reports

If the table will be copied into a document or presentation, inspect the pasted result. The hierarchy should remain clear when the surrounding spreadsheet controls are no longer visible.

For an Excel export, open the actual file in the application your recipient will use. The announced preservation feature is helpful, but checking the final deliverable is still the most reliable way to catch a practical formatting issue.

Also confirm that the exported report contains the expected filters and totals. A visually correct hierarchy is not enough if the report answers a different question from the one the recipient asked.

A small test before a large report

Try the layout on a copy of a representative table first. Include enough levels and subtotals to expose the challenges in your real report.

Ask a colleague to identify one subtotal and one nested category without instructions. Their response can tell you whether the compact form is clearer for your audience.

For AI-assisted spreadsheet work, our Fill with Gemini citation guide explains a separate update focused on tracing generated cell content. Layout helps people read a summary; checking sources helps them assess the information inside it.