Summarize your data with pivot tables
Starting today, we're rolling out pivot tables in Google spreadsheets. Pivot tables make it easy to process and summarize large data sets in seconds. Check out the video below for a look at how pivot tables work in Google spreadsheets:
Context & Ripple Effects
Google Spreadsheets has spent five years narrowing the gap with desktop spreadsheets: back in July 2006, observers were still speculating whether charts would arrive at all, and they did. Pivot tables — long a signature Excel capability for summarizing large datasets — were the next obvious missing piece.
The rollout also lands in a naming-collision moment: Microsoft had just spent late 2009 promoting its own experimental data visualization tool called Pivot, though that project and the classic pivot-table spreadsheet function Google is now shipping are different things. For Google, the move is less novelty than parity — bringing a table-stakes analyst feature into the browser.
First-order effects
- Google Docs users can now process and summarize large datasets directly in Google spreadsheets without exporting to desktop software, removing one of the most common reasons to leave the browser for Excel.
Second-order effects
- Microsoft faces pressure to keep matching free, browser-based parity on core spreadsheet functions, since every gap Google closes erodes a switching cost that keeps Office installations sticky.
Third-order effects
- If the pattern holds, browser-based suites will keep absorbing desktop-only analyst features until the definition of a 'lightweight' web spreadsheet converges with what was once considered full desktop functionality — shifting competition from feature presence to collaboration and scale.
The trend: Web-based office suites are systematically replicating desktop spreadsheet features, turning once-premium analyst capabilities like pivot tables into expected baseline functionality.