Google Sheets pivot tables now have compact form. What it moves before you switch

Can Google Sheets show a pivot table in compact form now?

Yes. Google announced it on its Workspace Updates blog on 28 October 2026. You choose the layout in the pivot table editor, the same panel where you add rows, columns and values. Outline form stays as it was, with each row field in its own column. Compact form nests all the row fields in one column, uses indents to show which level is which, and puts expand and collapse buttons inline.

The rollout is gradual. Rapid Release domains started getting it on 22 October 2026, and Scheduled Release domains start on 6 November 2026, and Google says either one can take up to 15 days to show up. It is for every Google Workspace customer and for personal Google accounts, and there is no admin setting to turn it off.

The post does not give the exact name or spot of the setting inside the editor, and Google’s help page Customize a pivot table did not mention layouts yet when I read it on 30 October. I have not seen the option on my own account yet. If your editor does not show it, the rollout simply has not reached you.

What is the difference between compact form and outline form?

The two layouts hold the same numbers. What changes is where the labels sit. I will use one small example the whole way through: a sales sheet with a Region column, a Product column and a Sales column, made into a pivot table with Region and then Product in rows.

In outline form, every row of the result is a full record. Row two says North, Chairs, 1,200, and you could hand that row to someone with no context and they would understand it. In compact form, the region sits on its own line with its subtotal, and the products sit under it, pushed in a little. To know that 1,200 belongs to North, you have to look up the column to the last region heading above it.

That is easy for a person reading on screen and hard for anything else. Excel has worked this way for years. Microsoft’s page Design the layout and format of a PivotTable says compact form is the default in Excel because it saves space and reads better. The same page says that if you want to copy the cells to another worksheet easily, you should use tabular form, which gives every field its own column.

Will switching to compact form break my formulas?

It can, and this is the part I would check before I switched anything. Look at the example again. In outline form, column B holds product names and column C holds sales. In compact form, product names move into column A under each region, and column B holds sales. Nothing tells you this happened. The pivot looks better, and every formula that pointed at column B quietly starts reading numbers where it used to read names.

These are the usual things that read a pivot table, and what the switch does to each one.

The last row is the one I care about most, because a script does not look at the sheet. If you have something like the setup in automating a weekly report that picks up a pivot by its columns, it will keep running and keep sending, and the numbers in the email will be wrong. The safer habit is to point scripts at the source data, not at the pivot at all.

How do I pull numbers from a pivot table without caring about the layout?

Use GETPIVOTDATA. It is an old function, and almost nobody uses it, but this update makes it worth learning. Instead of saying “give me the cell in column C, row 3”, it says “give me Sales for North and Chairs”. It finds the number by the field names and the item names, so it does not matter which column the number sits in.

Google’s help page for GETPIVOTDATA gives the shape as GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]). The first part is the name of the value, the second is any cell inside the pivot table, and then you give pairs of a source column name and the item you want from it.

1. 01
   Point it at the top corner of the pivot

   Google says any pivot cell works but recommends the top corner. If the cell you point at disappears when the pivot shrinks, the formula returns an error, and the top corner never disappears.
2. 02
   Name the value exactly as the pivot shows it

   If the value column is headed SUM of Sales, use that. If you renamed the heading in the editor, Google says the function only works with your custom heading, not the source column name.
3. 03
   Add one pair per level

   For North chairs, type =GETPIVOTDATA("SUM of Sales", A1, "Region", "North", "Product", "Chairs"), with A1 being the top corner of the pivot. Field names are case sensitive, the item text is not.
4. 04
   Wrap it if the item might be missing

   Google says the value has to appear in the pivot to be returned. If a filter can hide a region, wrap the formula in IFERROR so the cell shows 0 or a dash instead of an error.

Because it reads names and not positions, switching the layout should not change what it returns. I would still test that once on your own sheet, the same way I check any number I did not work out myself, as I describe in how to check the numbers an AI put in your spreadsheet. Put one GETPIVOTDATA next to one plain cell reference, switch the copy to compact form, and see which one still gives the right number.

What happens to compact pivot tables from Excel now?

This is the second half of the same update, and it affects people who never touch the new setting. Compact form is Excel’s default. Until now, Google says, an Excel file with a compact pivot table was turned into outline form when you opened it in Sheets. From this rollout, the compact layout is kept on import, and it stays compact when you export the file back to Excel.

That is good news for anyone passing files back and forth, because the pivot looks the same in both programs. It is the same kind of round trip fix Google made a week earlier for the new box and whisker chart. But it means the shape of an imported file changes. If you built a sheet that reads from an Excel pivot after import, and you built it around the outline columns Sheets used to give you, the next import of that same Excel file can arrive one column narrower.

The check is quick. Open the next Excel file a client sends you, find the pivot table, and look at column B. If it now holds numbers where it used to hold names, the import changed, and anything downstream needs a look. If your sheet is set to manual recalculation, press recalculate first, as I explain in Google Sheets manual calculation, or you will be checking old numbers.

Should I use compact form or outline form?

I decide by asking one question: who reads this pivot, a person or a thing? A person scrolling a summary on a laptop or a phone is better off with compact form, especially with three levels of grouping. A formula, a chart, a script, or anyone who will copy the numbers out is better off with outline form.

The last row is what I usually do. Two pivot tables on the same source data cost nothing, and it stops one person’s tidy view from breaking another person’s report. Name the tabs so nobody switches the wrong one, something like Summary and Feed. And whichever layout you use, a pivot is proof that sits under a plain sentence, not the message itself, which is the idea behind turning a table of data into a story people follow.