Slashdot Mirror
Hands on: Google Spreadsheets
feminazi writes "Google spreadsheets are more powerful than you might think, according to Richard Ericson. The free, Web-based service doesn't currently offer encryption, but the clean interface has standard drop-down menus, icons and buttons (just when MS is switching to "ribbons"). You can use it to work with existing files and "Formatting is simple, direct and fast. ... Sort, does precisely what you'd expect." Most importantly, it has most of Excel's functions -- including some that aren't listed or documented." We covered the launch of this program last week.
Anybody nervous that Google may be letting their eye off the ball (their original business model) by going off on these tangential projects?
The key to this being an "Excel Killer" is not that it needs to be able to do everything (or even most) of what Excel can do. Most people barely use probably 2% of Excel's capabilities, and don't even know how to use much of the other 98%.
The key to putting some hurt onto Excel sales, and MS Office in general is for Google to offer things like this that are "good enough" for the mass of home users that use 2% of Excel's product offerings. I personally have started using this for a couple personal spreadsheets that I have, where the network availability is more useful than having the whiz-bang Excel features.
Let's not forget that Google has also purchased Writely, which may be a "good enough" web based word processor to start attracting the mass of people who use Word as a fancy notepad.exe with spell-check. I don't need a heavy duty Word processor for most of what I do, and many other home users don't either. Writely is not yet available for users to register, unless they got in pre-Google.
While the Writely and Google Spreadsheets combo are not "killer apps" in terms of features, they may have enough functionality to put a serious dent in the very low end of Microsoft's user base.
Soccer Goal Plans
Does that include vulnerabilities that act as infection vehicles for viruses/worms?
I talk about stuff.
I am really wondering about this. I mean I am sure it is on the list of things to do, but I would think the OpenDocument Format would have been a bit easier to implement then working with XLS would have been. Granted more people use Excel then OOo, but I still find it strange that ODF wasn't in the list of early supported file formats.
"Some days you just can't get rid of a bomb."
The key to this being an "Excel Killer" is not that it needs to be able to do everything (or even most) of what Excel can do. Most people barely use probably 2% of Excel's capabilities, and don't even know how to use much of the other 98%.
Yeah, but you still need to get to the 2% mark. I'm looking at this review, and I am utterly dumbfounded at some of the features it's lacking. For example, Charts would be incredibly easy to compute on the server, then download as images. Alternatively, they could use SVG support, or canvas support, or Javascript Drawings. Yet they completely leave charts out! I don't know of a single Excel user who hasn't charted their data at some point in time. If Google isn't supporting this, then they can expect users to dislike their spreadsheet.
Similarly, the lack of online help is a no-no for a spreadsheet program. Users still need to do computations, even if they're as simple as addition, subtraction, averaging, and weighted averaging. Failing to include online help means that users will have no idea how to properly compute these formulas. Even just dropping the expected args into the text field would do wonders for usability!
All in all, this article makes me believe that Google is buying into this "users don't need that much" mantra that makes sites like ajaxLaunch so laughable. GMail "won" because it provided a completely new way to work with email. It wasn't just the best Webmail apps, it was better than even installable apps! If Google wants to follow that success, they need to take that sort of innovation (*blech* sorry, weasel word) into their other office products. Otherwise, they're going nowhere, fast.
Javascript + Nintendo DSi = DSiCade
> While the Writely and Google Spreadsheets combo are not "killer apps" in terms of features
Actually, Writely and Google Spreadsheet are Labs toys right now. However fast forward one year, with Firefox sporting an embedded database, and Writely and Spreadsheets will look far less toy-like. Add support for rich controls from the WHAT-WG and in a couple of ears you have an office suite you can download on demand and run inside your browser. And you can work with it offline.
And if you think Microsoft hasn't read the writing on the wall, you haven't been looking at XAML and IE7 very closely.
When I was at work, I decided to give Google Spreadsheets a shot (it wasn't for anything critical, just some simple calculations). I noticed one feature that, surprisingly, was not implemented--as far as I know, Google Spreadsheets can't merge cells vertically. Cells can only be merged horizontally. I ended up having to use Excel because of this one tiny missing feature. However, it's still in beta, and I am really impressed with what they've done. It's the second-coolest AJAX app out there (the first being Meebo).
Keep up the good work, Google!
Ride the skies
Google's doing this in a rather smart way, IMHO...
They're not chasing Excel's market. Nobody's going to be using this for business-critical applications, and this won't challenge the corporate market for Office. What Google is doing is chasing the long tail of the market - the people who might want to use a spreadsheet, but have no need for Excel. Let's face it, for a quick and dirty budget, a team roster, or a simple document, Excel is more than overkill.
What Google Spreadsheets has that Excel doesn't is simple collaboration -- no need to install SharePoint servers or any of that other Microsoft lock-in garbage required. Just add a few emails to a field and you're done. That is ideal for a whole host of simple, small projects. Say you're running a small business and want to have online schedules -- would you use Excel and some expensive Microsoft server setup, or just make a simple spreadsheet with Google and share it amongst your employees? It seems pretty easy to guess which one is the easiest and least painful option to someone without an IT budget.
Google knows that if they try to compete with Office, they'll get crushed. So they're not doing that at all. Google Spreadsheets isn't an enterprise app, it's a quick and dirty system for simple tasks -- and it excels at being what it is. By capturing that long tail of users who don't need Excels features and won't pay Excel's price, Google can pick up a sizeable user base. The real question is what Google intends to do with those users and how they'll turn this into a revenue generator.
Following that description was an image which apparently shows a ribbon. I'm still having difficulty grasping where the ribbon starts and other user interface controls end because the image appears to be almost entirely full of user interface controls.
The webpage went on to say: "One of the concepts behind the Ribbon is that it's the one and only place to look for functionality in the product. If you want to look through Word 2003 to find an unfamiliar command, you need to look through 3 levels of hierarchical menus, open up 31 toolbars and peruse about 20 Task Panes. It's hard to formulate a "hunting" strategy to find the thing you're looking for because there's no logical path through all of the UI."
Well, this is one of those Duh! statements. There's no logical path through the User Interface because Microsoft has no strong conceptual model of the document or the application functionality. Therefore functions are placed almost at random within the menus, toolbars and task panes.
Correct me if I'm wrong but I thought the menus were supposed to expose all the application functionality. "Ribbons" sound to me as though they are merely replacing menus. Perhaps they have more flexible layout.
Overall it seems to me like Microsoft is implementing Ribbons as yet more eye candy to attract people to upgrade. The talk of increased usability is merely lip service, misdirection from the fundamental problem that I have with Microsoft's user interfaces. The page mentions that "most people don't click on an unlabeled 16x16 icon". Microsoft's at fault here for their feature-driven requirements. It seems to me that a requirement of Microsoft user interfaces (particularly Word and Excel) is that every possible piece of screen real estate needs to have some function: either an icon or clicking with the mouse will do something. That makes the interface incredibly busy - not good for newbies, perhaps not necessary for experienced users.
I thought it might be interesting to import into Google Spreadsheets the database I keep of my movie collection. That's about 2,000 lines long, by a few columns, but first I just tried a single column of titles. Nothing fancy -- just a sorted list. I made a .csv file and uploaded it -- it was only about 50K, so that step was plenty fast.
:-) A pity, 'cause having these online from anywhere I can get to Google was an intriguing idea (although I have my own site for that). My impression of Google Spreadsheet is "neat, but basically toy." I don't use Excel very often either, but I do know it has no trouble with spreadsheets that are tens of thousands of lines long (nor would I expect any modern standalone spreadsheet to).
When I tried to actually open the imported spreadsheet with Google Spreadsheet, however, it just hung. I waited about an hour then killed Firefox. Tried twice with the same result.
That was with 2,000 lines; I guess I'm not going to be trying the application out with my 30,000-line book collection database or my 25,000-line record collection database any time soon
Kiscica
Just something I noticed. If you have a GMail account, and you've requested to be in the Beta Testing of the spreadsheet program, you may already be approved! I never received a confirmation from Google (perhaps it got caught in the Spam filter?), but I just went to http://spreadsheets.google.com/ and found that I could log in!
I have to say, the sheet has a nice feel to it. It really reminds you of Excel or OpenOffice Calc. Unfortunately, this comparison is quickly disappated once you start using it. Things I've noticed:
1. Formulas are edited in the cell rather than having a text field on top. This is REALLY annoying to anyone who uses a spreadsheet program regularly. There is an uneditable text field at the top (doesn't work right in Mozilla 1.7.12), but it's not useful for anything other than ogleing at.
2. Auto-resizing by double-clicking doesn't work. This is a core feature that I should think that everyone uses.
3. No size indicator when changing cell sizes. I don't know about anyone else, but I always try to resize my sheets to about 14.25 points high, as this looks best. In addition, the indicator is a good way of knowing that you've got the right size for a row, rather than by messing with trial and error.
4. You're limited to 100 x T cells. If you're one of those people with a lot of data, good luck. It doesn't look like Google will let you store it without manually inserting enough rows or columns to hold it all.
5. The formatting menu is useless. It's got a few data types, and that is IT. If you need a custom style, or a date in one of the billion other formats, you're SOL.
6. No cell borders. Raise your hand if you tend to mark headers with a cell border. (/Me raises hand.)
7. The "Freeze Rows" command makes no sense. Why are you choosing the number of rows from a menu, when a multiple row-select exists?
8. Sorting! Yippe! Now I can make my sheet into a database! (/sarcasm) Seriously, this feature actually works. I was expecting it to choke on numbers by treating them as text, but it automatically sorted then correctly. Score one for the team.
There's a lot of other minor annoyances that I won't get into, but the above are the big ones. Unfortunately, I've just about covered 90% of the functionality. My verdict? It's not ready for prime time. If Google wanted to do this, perhaps they should have teamed up with Sun's StarOffice team.
Javascript + Nintendo DSi = DSiCade