Google tries to make its spreadsheets more like wikis

By Michael Hatamoto and Nate Mook | Published May 16, 2008, 7:22 PM

In a strange move, Google has added a new feature to Google Docs that enables users to allow anyone to edit a spreadsheet, advertising the option as a way to make a spreadsheet like a wiki.

Previously, individuals could be invited to view or edit a spreadsheet, but they had to create an account with Google after entering a custom URL that effectively served as a security-through-obscurity barrier.

Google Spreadsheets users simply need to know the URL of the document to be edited. Simply loading that URL provides full access to edit and add content as if they were logged into Google Docs. For now, the feature remains only for spreadsheets and not written documents or presentations.

Those with security concerns simply must ensure the "Anyone can edit this document without logging in" button is not checked. By default, the option is disabled.

What's not entirely clear from Google's announcement, however, is why anyone would want to turn the option on. While publicly editable wikis are commonplace around the Web, spreadsheets aren't typically the type of document that necessitates such open collaboration. The feature isn't yet part of Google's online word processor, which was actually developed by another company that Google acquired.

Google's example spreadsheet comparing productivity services and software was quickly defaced by the public. Under "Most Annoying Feature" of Google Docs, someone added "Offline use doesn't work."

Google added offline editing capabilities to Docs recently with the help of its Google Gears software, but users have had problems making it work properly. The document is downloaded for local editing and then synced back to the service, but changes are not tracked for approval or disapproval.

Separately, Google also this week added the ability to embed forms into a Web site and pass the result back to a spreadsheet.

Another recent addition is the option to save Google Docs presentations as PowerPoint (PPT) files, which joins saving documents as text and PDF files. Mobile viewing on cell phones is now also possible by visiting docs.google.com/m.

Google Spreadsheets Wiki

Comments

View comments by with a score of at least

Actually, this is quite useful.

I know in World of Warcraft there's tons of 'theory crafting' that goes on, where there are complex formulas for everything from how much damage you do, to how one piece of armor (or a weapon) is better than another, even though the statistics are different.

In the past, you downloaded someone elses spreadsheet, and if you had improvements, you'd have to update it and upload, and then before long you have 20 different versions.

There are, I imagine, other online discussion topics that would benefit from pivot tables, calculations, etc.

I think it's a pretty good idea, tbh.

-Strack

Score: 0

|

If you're motivated you can type in the url from the image, it works.

Score: 0

|

well it will be used by at least one phisher for storing credit card numbers of their victims So they can just swoop by and pick them up or sell off the url to the spread sheet.

I am sure that someone can come up with a use that does not involve fraud.

But that is the distributed data gathering that I see today.

Score: 0

|

Umm... what's so strange about collaborating on a spreadsheet. This was one feature that was missing that led me to decide against using Google apps. Right now the implementation is still behind the dedicated collaborative spreadsheet offerings, or other "suites" such as the one from Zoho.
Seriously, can no one think of a legitimate use for a wiki that allows you to manipulate the data like a spreadsheet? (yes, basically used as a simple light-weight database)

Score: 0

|

And what's so original about it again? Let's make DOC files shared too. Will that make the news as well?

Score: 0

|

Strange feature indeed for a spreadsheet, however, I have a feeling that it will all make sense in the near future; as Google is usually taking a holistic approach in designing those feature, it is probably part of a bigger future puzzle.

The feature might be related to Google Apps where the spreadsheet can be edited by anyone in the the same team for example without logging in.

Score: 0

|

PDC 2009: What have we learned this week?

There was the freebie that no one will forget, the heebie-jeebies courtesy of Scott Guthrie, and a teensy bit clearer picture of how this cloud thingie should work.

Live report: Will Google Chrome OS change Linux?

The mysteries of just what Chrome OS is, and how much of an operating system it truly is, may be resolved today.

PDC 2009: Microsoft cares about Web browser performance

The effort to give users of the world's dominant Web browser the impression of quality, is a personal one for the man who leads that battle.

Nokia re-affirms its commitment to Symbian, sort of

Maemo won't necessarily be replacing Symbian in the Nokia N-Series, but that's definitely a place where it will be found.

E-book readers will be in short supply this holiday season

E-readers are hot this year, and a lot of compelling new products have been released, but are there enough electrophoretic displays to go around?

Sony looks to finally open a single storefront for downloads

Sony has had many different download portals for movies, music, e-books, and games, and now it's looking to make a single shop for all of it.

Tuning out the tablet: Time to give the endless speculation a rest

Wide Angle Zoom: Wishing and hoping and thinking and praying....won't put an iTablet on the market.

Five improvements for IT managers in 2010

If businesses are to improve their efficiency for next year, they need to stop and reassess the basic tenets of their job.

AOL's spinoff from Time Warner to shed 2,500 jobs

As AOL moves toward become an independent company again, it will cut nearly a third of its workforce.

Gartner: SMS-based money transfer will be bigger than mobile browsing, search

Gartner issues its predictions for the 10 things our phones will be doing in 2012.

Don't forget to upgrade to Firefox 3.6 beta 3 today

Mozilla has released the latest beta its Firefox 3.6 browser software, just over one week after beta 2.