Now *this* is Office 2.0

It’s now possible to dynamically link web data into Google spreadsheets. For example, stock information can be pulled in via the simple formula GoogleFinance(ticker, attribute), where attribute can be any number of metrics from market capitalization to P/E ratio. Not much to choose from yet—at this point, there’s only GoogleFinance and GoogleLookup, which seems more novelty than useful, and I’d love to see more than just the obvious metrics available for GoogleFinance, things like cash per share, revenue growth over the past m years, number of insider purchases over the past n months, etc. However, it’s a great start, and it’s pretty easy to see where they’re going with this—after all, most spreadsheets are inherently linked to external data sources, though I’d wager a majority of them are “linked” via copy and paste. I look forward to the day when you can pull in all manner of structured information into a spreadsheet via similar formulas.

To me, this is the real value of “Office 2.0″. To compete, the office challengers have to go beyond just copying Microsoft Office on the web—success will come from exploiting the new platform, not cloning the old model. Pretty easy to see something like this grow into a platform all its own too. With a few more financial metrics, a slightly more powerful macro language, and the ability to connect to more arbitrary data sources (say, Google Base or the CSV files my bank makes available to me), I could track my finances on the web in a Google spreadsheet and give Quicken the boot (for what I want to do, Quicken is like driving a nail with a sledgehammer).

Update: Google spreadsheets has an API now too.

6 Responses to “Now *this* is Office 2.0”

  1. [...] Google is building vertical functionalities in its office suite by integrating with other Google services, which is cool. And it can happen in many more ways. It makes sense for documents that are going to be online, like probably your resume. I follow the online office suites in spite of believing that webified applications are better than browsered ones, for most cases today. The reason being that I see use for online office suites in the space of sharing and collaboration. I still prefer a a publish button in my desktop office suite is better than having to compose the entire document online. Similarly, I would prefer if this can be done in my desktop office suite. [...]

  2. [...] Ian Murdock’s Weblog » Blog Archive » Now *this* is Office 2.0 “I look forward to the day when you can pull in all manner of structured information into a spreadsheet via similar formulas.” – me too (tags: Murdock Google spreadsheet dynamic updating) [...]

  3. rebolek says:

    nothing against google, but REBOL nanosheets had same feature at least three years ago. But that’s just REBOL and not the hyped AJAX Web2.0 on Rails BETA thing…

  4. Stubby says:

    Nothing against rebolek, but Excel had the same feature since at least 1995. But that used OLE/COM and not the hyped REBOL thing.

    Seriously, the cool thing about this is that it’s got to be a lot easier for anyone to use GoogleFinance() than it ever was to use OLE for external data feeds through Excel.

  5. @rebolek: The brilliant aspect of this feature is not the fact that google spreadsheets now allow formula lookups using http but the fact that the absurd amount of data Google has will be used on the very near future to enable functions like these:

    =GoogleTranslate(B3, “czech”)
    =GoogleDefine(C2)
    =GoogleLinkPopularity(C2)
    =GoogleCheckoutPriceQuote(“Product name”)

Additional comments powered by BackType