Hey—we've moved. Visit
The Keyword
for all the latest news and stories from Google
Official Blog
Insights from Googlers into our products, technology, and the Google culture
Opening Google Docs to users and developers via Gadgets and Visualization API
March 19, 2008
Posted by Jonathan Rochelle & Nir Bar-Lev, Product Managers
Whenever we're asked "how do people use Google spreadsheets?", we always struggle with where to start. It's not that we can't think of examples, it's just that the examples are all so different, so unique. Sure, there are definitely favorite themes -- sports, finance and, yes,
knitting
-- but then the examples become so particular to the people and groups who are using them: The
beer taster's results
. The nursery school class schedule. The
biker's riding log
. The family reunion plan. The ski-trip sign-up form. Endless examples, all of which, to spreadsheet junkies like us, are interesting.
But while we've always wanted to give people more options to view and use their information in Google Docs, we knew that trying to build all of these one at a time would simply serve too few people, given all the different ways people use and share spreadsheets.
So today we're starting a new path to better enable developers to customize and build on top of Google Docs with two new tools we are releasing today: Gadgets-in-Docs and the
Visualization API
.
Instead of delivering just one or two new types of reports, or a new visual map mashup (can you ever get enough of those?), we decided to deliver a platform on which anyone, not just Google, could build the next best thing. We even invited a few developers to try this with us, and they join us in this launch by featuring just a few of their creations, like Panorama's pivot table, or Viewpath's Gantt Chart, or InfoSoft's Funnel Charts -- all great tools for the student and enterprise user alike. We also built a few early gadgets ourselves which you might find useful.
We borrowed the Gadgets-in-Docs concept from the iGoogle team, so it's only fitting that you can also publish your spreadsheet gadgets to iGoogle, where you can see your data-based-Gadget right next to all that other stuff that's important to you (even if it is just a picture of your dog).
To try it out, go into
Google Docs
and open up a spreadsheet. Click on the chart icon, and click 'Gadget...'. Pick your gadget, customize it to fit your data, and then publish it out to iGoogle or to any webpage.
If you're a developer and want to reach millions of people with your latest creation, check out the
Google Visualization API
, courtesy of our visualization team engineers. The Visualization API provides a platform that can be used to create, share and reuse visualizations written by the developer community. It provides a common way (an API) to access structured data sources, the first being Google spreadsheets.
Labels
accessibility
41
acquisition
26
ads
131
Africa
19
Android
58
apps
419
April 1
4
Asia
39
books + book search
48
commerce
12
computing history
7
crisis response
33
culture
12
developers
120
diversity
35
doodles
68
education and research
144
entrepreneurs at Google
14
Europe
46
faster web
16
free expression
61
google.org
73
googleplus
50
googlers and culture
202
green
102
Latin America
18
maps and earth
194
mobile
124
online safety
19
open source
19
photos
39
policy and issues
139
politics
71
privacy
66
recruiting and hiring
32
scholarships
31
search
505
search quality
24
search trends
118
security
36
small business
31
user experience and usability
41
youtube and video
140
Archive
2016
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2015
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2014
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2013
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2012
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2011
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2010
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2009
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2008
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2007
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2006
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2005
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2004
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Feed
Google
on
Follow @google
Follow
Give us feedback in our
Product Forums
.
Follow
