13 Comments

Summary:

Google recently announced a new feature: forms. By combining spreadsheets with bulk e-mail, the new function (which was revealed on the Google Docs blog) lets a spreadsheet author send out a mail with fields for recipients to fill in. As they do, the spreadsheet gets completed. […]

Google recently announced a new feature: forms. By combining spreadsheets with bulk e-mail, the new function (which was revealed on the Google Docs blog) lets a spreadsheet author send out a mail with fields for recipients to fill in. As they do, the spreadsheet gets completed. It’s a real-time survey that pumps data straight into a spreadsheet. It’s also another example of the difference between desktop software and web-based applications.

Google does a great job of re-thinking basic applications when they live online, something traditional software vendors seem to have a hard time doing. In an earlier release, for example, they added functions like =ImportFeed (to pull data in from an RSS feed) and =GoogleFinance (to pull data in from Google’s financial tracking site.)

A few functions like this, and Google turns any spreadsheet-literate user into a web services developer.

By contrast, consider Windows Mobile. If I have a spreadsheet full of phone numbers, I should be able to select a number and dial it. But the Mobile version of Excel is so true to the original, it doesn’t think about data in the context of being a phone. So I have to manually copy the number to the clipboard, create a new contact with that number, and dial it.

We don’t need web-based versions of our desktop software. We need web software that takes advantage of being online.

You’re subscribed! If you like, you can update your settings

  1. Microsoft re-shuffles — Channel Marker Thursday, February 14, 2008

    [...] has its work cut out here. Windows Mobile still fails to impress in the picky cell phone/handheld device world where Apple’s iPhone is the cool kid and [...]

  2. To see spreadsheets automatically transformed into gadgets, check out iBuild at http://www.limitnone.com/ibuild.

  3. Links: 2008-02-14 – HP Spying, $3m party, Google forms, RCMP secret files « ideas Revolutionary Thursday, February 14, 2008

    [...] Rethinking the Spreadsheet: Google Forms and Live Data [...]

  4. I think you’ve made some valid points, but you’ve also confused some issues. I don’t think the Windows Mobile example works for two reasons — you’re talking about making traditional desktop apps work in new contexts, not just the web, in the phone number example. Also, I’m far more likely to get and want to call phone numbers out of emails than a spreadsheet, and for this Windows Mobile and Pocket Outlook are good at identifying potential phone numbers in emails (even when they use dashes or periods), and automatically creating a link that lets me simply click-to-dial.

    Google is good at web-ifying traditionally desktop apps, and really it is better than many of the other big players at doing so. I don’t think your main point is invalidated by this, but I want to point out there’s counter-examples and other issues involved.

  5. An ideal app, from my point of view, would be filling out a webpage form and having it automatically added to a spreadsheet.

    We could than rummage through the spreadsheet (data mine) to find info of interest.

    There may be a hint of that feature already, but it is not readily evident.

  6. @Casual Visitor: you can do that and more (i.e. display the aggregate results) with Google Forms:
    http://googlesystem.blogspot.com/2008/02/add-data-to-google-spreadsheets-using.html

  7. HTML forms in email was a patent dispute during the early days of the web. I’m not sure how it got resolved. A startup patented the email form concept after HTML email was created. As one of the people who worked on the HTML email spec we objected to the patents since HTML forms were one of the reasons HTML email was created in the first place. I think the start up died before lawyers got too involved. It’s been ten years and I’ve forgotten the startup’s name. Let’s hope those patents aren’t in the hands of a troll now.

  8. Thought MS Access had this functionality in the desktop world for a long time now. Not sure if you can expose MS Access based forms on the web though…

  9. Mary Branscombe Thursday, February 14, 2008

    Yes, in Access 2007 you can send an email around that people can fill out in Outlook and returning emails are automatically populated into the database
    http://blogs.msdn.com/access/archive/2006/06/30/data-collection-through-email.aspx
    http://blogs.msdn.com/access/archive/2006/07/11/data-collection-responces.aspx

    Putting this in a spreadsheet? Just encouraging people to do database things in a place where they don’t get as many tools – if Google want to replace Excel as the universal data munging engine I’m not sure this is a step forward.

    And you don’t have to create a new contact; just paste the number into the Windows Mobile dialler. I do it all the time; for conference calls you can even paste the passcode.

  10. The Mobile Excel example may not be a good illustration of what’s right about Google’s approach, but it is an excellent illustration of what’s wrong with Windows Mobile. This particular issue has frustrated me many times. When people e-mail out contact lists, they usually aren’t embedded in some sort of table inside the e-mail (which Mobile Outlook usually can’t read, anyway), they are in an excel attachment. There wouldn’t be so much interest in various incarnations of Linux for the smartphone if MS weren’t so lazy in their development of Windows Mobile.

Comments have been disabled for this post