See your Google Spreadsheet data in more ways than one
May 16th, 2007 | Published in Google Code
Having an easy way to collaboratively collect, create and share data is just the tip of the value iceberg of Google Docs & Spreadsheets. Publishing that data embedded in a web page or blog post or sharing the data as an RSS feed starts to reveal the next level of value of this collaborative product - with the spreadsheets data API giving developers real power to innovate. Well, we are quickly seeing that power being put into action. While we introduced charting with spreadsheets just last month, there’s a few companies integrating Google spreadsheets into their charting and visualization tools to give Google spreadsheet users new ways to visualize their data. Here’s two examples of this integration – one with a real business focus in the area of business intelligence dashbaords - using the official API, and one focused on a web-based community of people hoping to "liberate the world's data".
Kearen offers a product which allows business users to create “dashboards” – visual representations of data from practically any source – and then publish or distribute them as interactive flash applications. It’s cool, especially since you can now select ranges of spreadsheets to use as inputs to the interactive charts. There's a quick demo video and two examples:
Personal Budget:
This example shows personal income and expense. It provides the ability to do expense analysis and “what if” modeling for personal savings.
Stock Portfolio:
This example shows investor account information. It provides the ability to view multiple accounts and transaction history for each asset/stock. It includes “what if” analysis for specific holdings.
Swivel offers a web destination to upload and explore data - a cross between a social network, data sharing site and a data visualization service. They provide a lightweight integration with Google Spreadsheets through a bookmarklet (a link added to your browser bookmarks which recognizes the Google Spreadsheet you are viewing when clicked) to allow people to submit data based in a Google Spreadsheet to get automatically generated charts to share with the Swivel community. You can check out their "how to" videos and look at a sample chart of the "Glutamate content in foods", whose data source is a Google spreadsheet.
If you've got a unique way to look at data, there's probably data on Google Spreadsheets just waiting to be discovered...
Jonathan Rochelle - The Google Docs and Spreadsheets Team
Kearen offers a product which allows business users to create “dashboards” – visual representations of data from practically any source – and then publish or distribute them as interactive flash applications. It’s cool, especially since you can now select ranges of spreadsheets to use as inputs to the interactive charts. There's a quick demo video and two examples:
Personal Budget:
This example shows personal income and expense. It provides the ability to do expense analysis and “what if” modeling for personal savings.
Stock Portfolio:
This example shows investor account information. It provides the ability to view multiple accounts and transaction history for each asset/stock. It includes “what if” analysis for specific holdings.
Swivel offers a web destination to upload and explore data - a cross between a social network, data sharing site and a data visualization service. They provide a lightweight integration with Google Spreadsheets through a bookmarklet (a link added to your browser bookmarks which recognizes the Google Spreadsheet you are viewing when clicked) to allow people to submit data based in a Google Spreadsheet to get automatically generated charts to share with the Swivel community. You can check out their "how to" videos and look at a sample chart of the "Glutamate content in foods", whose data source is a Google spreadsheet.
If you've got a unique way to look at data, there's probably data on Google Spreadsheets just waiting to be discovered...
Jonathan Rochelle - The Google Docs and Spreadsheets Team