Google Docs is great for collaboratively building documents, but the feature set in its spreadsheet has lagged a long way behind desktop alternatives such as Excel. The introduction of pivot tables, which allow large amounts of data to be quickly summarised, is a major step forward for the platform.
While experienced Excel jockeys will welcome the new pivot table ability, it doesn't yet match the range of options available in Excel. Right now, it also isn't possible to import existing Excel pivot tables, a function we hope gets added in a future update.
Summarize your data with pivot tables [Google Docs blog]