BUT, also like all disruptive technologies Google Spreadsheet is quietly getting good at things that Excel can only dream of. Since it launched, Google Spreadsheet has had great sharing and concurrent editing capabilities. A team at school used a shared Google Spreadsheet as a “factory information system” in a simulated factory exercise and it was amazingly powerful.
More recently, Google has added amazing data extraction techniques. Put =GoogleFinance(“Oil”, “Price”) in a cell and you’ll get the price of oil updated in realtime. The following will pull all the headlines off Techmeme: =importxml(“http://www.techmeme.com”, “/html/body/div/div/div/div/div/div/div/div/strong/a”)
There are also functions for trolling arbitrary HTML, for parsing RSS and Atom feeds and for importing CSS feeds.
Where the mind really starts to boggle is when you think about how every cell in every google spreadsheet effectively has an URL. So it should be almost as easy to publish from your sheet as it is to pull in from somebody else’s. Suddenly, there are network effects for spreadsheets, where your work can leverage off the work of others. This ability to ref a cell in someone else’s sheet doesn’t seem to be enabled just yet, but I can’t imagine Google isn’t working on it. I’m sure there are some issues around permissioning and detection of dependency loops.
Throw in a little work on keyboard shortcuts and a little Google Gears magic to make the app more responsive and workable offline and Excel will be starting to feel the heat…