Tools2 min read

Google Sheets adds Excel-compatible compact pivot-table layout

Google announced compact pivot-table layout in Sheets. What SMB teams should check before exchanging reports with Excel.

Prepared by the NADALI editorial team using AI

AI illustration: hands check a conceptual laptop table against marks on paper.
Надалі / Nadali — reused original AI-generated editorial illustration · Original AI-generated illustration created for Nadali; use subject to applicable OpenAI terms; no exclusive copyright claim; no third-party input images used. Reused from ai-spreadsheet-formula-verification. · 1440 × 960

Author: Nadali. Prepared using AI.

On October 28, Google announced compact pivot-table layout: row fields form a hierarchy. The company says this layout is now preserved when importing from Excel and exporting back.

Who benefits: small teams exchanging reports between Excel and Sheets. This is a work-tool change, not a new AI feature.

Checks before handing over a report

Our editorial recommendation: try the exchange on a copy before replacing the agreed file. A shop might check a report with nested “branch → product group” categories, for example. This is an illustrative scenario, not a measured case study.

  1. Keep the original file and record the reporting period.
  2. Compare level labels, group order and totals after import.
  3. Export a copy back and ask the recipient to check it in their working environment.
  4. Record discrepancies; do not treat a more convenient layout as proof that the numbers are correct.

Preserving layout alone is not a guarantee of complete workbook compatibility. If a report informs a purchasing decision, its owner should reconcile the figures before approval.

Access and limits

Rapid Release rollout began October 22; Scheduled Release is planned from November 6, with each stage taking up to 15 days. Google lists all Workspace plans and personal accounts.

Google’s help page separately warns that value-based filters may need updating after source-data changes. The new layout does not remove that check.

The takeaway: check the content as well as the appearance of the file your colleague actually receives. Nadali has not tested import, export or access in an individual account.

Sources read November 1, 2026 UTC. The cover is a reused conceptual AI illustration, not the Sheets interface. 

Sources and verification

  1. Google Workspace Updates — Apply compact form layout for pivot tables in Google Sheets ↗
    Source checked: 2026-11-01
  2. Google Docs Editors Help — Customize a pivot table ↗
    Source checked: 2026-11-01