Wednesday, May 28, 2008

Google Spreadsheets Rock! Google Sites is the Web2.0 equivalent of a Pet Rock.

Just saw that there is an API for getting data in and out of Google Spreadsheets.  This is interesting: combined with the fact that I can get feeds of what's changed, collaborate with others, this makes Google Spreadsheets an awesome platform.

This is more than I can say for the hopelessly underpowered Google Sites (JotSpot).  I'm using it for our intranet, and the biggest issues (this has been covered before, but here are my top three biggest problems with it):

1). Unlike Spreadsheets (which can be collaborated on real time), Google Sites locks everyone out when you're editing.  And it takes a while to release the lock, even after you've saved the page.

2). Unlike Spreadsheets (which has a great API to get data out), Google Sites has NO way of extracting data.  None, nada, niente.  If I want to copy-and-paste a LIST page from Google Sites, I can't even do that, because it's all ajax-y and you can't copy-and-paste.

3). Unlike a Wiki, you can't create a new page by just typing the name.  You have to (a) Save the page you're working on.  (b) Create a new page (c) put some content in it, (d) go back and find the original page (e) link to the new page, by finding it in a list (which could be huge) of existing pages.   What a pain.


No comments: