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 comments on “Now *this* is Office 2.0

  1. Pingback: Google Extending Office Suites on iface thoughts

  2. Pingback: tecosystems » Blog Archive » links for 2006-12-03

  3. rebolek

    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

    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. Ricardo Cabral

    @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”)
    =GoogleCheckoutPriceQuote(“Product name”)

  6. Pingback: Comment on Now *this* is Office 2.0 by tecosystems » Blog Archive …Google Blog Search: office 2.0 at office 2.0

Comments are closed.