Jigar Mehta’s WebBlog

November 29, 2006

Major Update in Google Spreadsheets

Filed under: Uncategorized — jigarme @ 6:17 pm

Google Spreadsheets continues to be surprising and miles ahead of the other half of the package, Google Docs. This is probably the biggest update since the product has been launched.
Now you can publish a spreadsheets in every imaginable format (HTML, PDF, XLS, ODS, CSV) or as a feed. What’s great is that the file is automatically updated, so you’ll be almost certain that someone gets the latest version. You can also publish all the sheets or only some of them. But the coolest thing you can do is to embed a spreadsheet into your blog or site. The spreadsheet you can see here shows the top 20 queries for this blog’s search from April 1st until yesterday.

Google Spreadsheets shows you all the revisions of a spreadsheets, so it’s easy to go back to an earlier version. And there are two new functions that use information from the web:

  • GoogleFinance(“symbol”, “attribute”) that returns information about a stock. GoogleFinance(“GOOG”, “price”) returns the current price for GOOG.
  • GoogleLookup(“entity”, “attribute”) that returns answers to simple questions like: population of Italy, Jay Leno’s date of birth, that usually appear at the top of search results in Google.com. GoogleLookup(“Italy”, “population”) will return the population of Italy.

Don’t forget to place an equal in front of the function name.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: