mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

Pivot table comparison: Excel v. Google v. Web-based

EducationPivot tables are great tools for spotting hidden details and trends in a sea of data. One pivot table lets you quickly examine nearly any aspect of your data. Also, unlike static reports, the user determines what parts of the data to analyze.

The big question with pivot tables is this: Which pivot table option is best for my company? Right now, there are three main pivot table options: Google Docs, MS Excel, and database-driven web pivot tables. How do they compare? We’ve put together a handy one-page guide which explains the differences between each pivot table option. I hope you find it useful.

2 thoughts on “Pivot table comparison: Excel v. Google v. Web-based”

  1. One aspect of Excel that wasn’t pointed out is that a MS Excel picot table doesn not “Have” to access data in a Excel spreadsheet. A MS Excel Pivot table can be built using a ODBC, SQLNET or other database connectivity interface to a Access, MySQL, Oracle or SQL Server database server that has millions of rows.. In this scenario, Excel is acting as a pivot table client to a database server..

  2. Thxtnx for the analisys! Its simple one, but good for users like me. I’d prefer web pivot tables, do you know some to try?

Comments are closed.