Office suites in the cloud: Microsoft Office Web Apps versus Google Docs and Zoho

A spreadsheet in your browser? A word processor on the Web? These days, SaaS (software as a service) is all the rage, and the success of Web-based upstarts like Salesforce.com has sent vendors searching for ever more categories of software to bring online. If you believe Google, virtually all software will be Web-based soon -- and as if to prove it, Google now offers a complete suite of office productivity applications that run in your browser.

Google isn't the only one. A number of competitors are readying Web-based office suites of their own -- most prominently Zoho, but even Microsoft is getting in on the act. In addition to the typical features of desktop productivity suites, each offering promises greater integration with the Web, including collaboration and publishing features not available with traditional apps.

[ Looking for a way to benchmark Windows 7 versus Vista or XP? Check out OfficeBench 7, a cross-version test script that uses your existing installation of Microsoft Office to evaluate your PC's performance. | Read InfoWorld's first look at Microsoft Office 2010. ]

But how serious are they? Even with today's modern browsers, can browser-based apps truly substitute for Microsoft Office for real-world work? I decided to find out. Armed with a selection of demo documents and actual work from my own files, I put Google Docs, Zoho, and the Technical Preview version of Microsoft's Office Web Apps to the test. Predictably, the results were mostly a disappointment -- but my experience yielded unexpected surprises, as well.

Google Docs: Your desktop, onlineNo company is more jazzed about Web-based applications than Google, so you'd expect its suite to be the best, right? Wrong. In fact, the most amazing thing about Google Docs turned out to be just how woefully inadequate for serious work it actually is.

When you log in to Google Docs, you're greeted with a familiar, Google-style UI: spare, reserved, understated, even elegant. But while this trademark approach works wonders for Google's search products, with Google Docs it belies a paucity of features that's instantly frustrating.

[ If the table and screen images in this article don't display properly, read them in the original story at InfoWorld.com. ]

  • Spare and easy to use UI
  • Presents chronological view of documents
  • Maintains version history of each document
  • Can import documents via e-mail or the Web
  • Docs are easy to embed in blogs and Web sites
  • Same ribbon bar UI we all know
  • Reproduces Word and PowerPoint files, and embedded graphs in Excel, with absolute fidelity
  • Excel Web App displays updates to multiple authors in real time
  • Printing is flawless
  • Provides a few advanced features such as mail merge, pivot tables, and charts
  • Beta VB Macro support for spreadsheets
  • Can insert HTML and CSS directly from Web pages
  • Blog posting via MetaWebLog and Blogger APIs
  • Complemented by a wide range of business apps
  • Almost completely lacking in advanced features
  • Fails to preserve all but the most rudimentary Word, Excel, and PowerPoint formatting
  • Printing is unreliable
  • Word and PowerPoint Web Apps are read-only in the Technical Preview
  • Excel Web App cannot edit files containing VBA, shapes, and other objects
  • UI is inconsistent across apps
  • Light on sophisticated features
  • Preservation of imported Office documents only slightly better than Google Docs
  • Printing is unreliable

Just for starters, forget about a smooth migration away from Microsoft Office. Google added support for Office 2007 file formats in June, but so what? Even with the older Office formats, Docs chokes on all but the most rudimentary formatting. I tried importing various real-world files from my archives -- not mock-ups or demos, but actual work -- and anything more complicated than a simple column of text came up distorted.

A demo file created in Word 2007 revealed just how many features Docs gets wrong. Tab stops, paragraph spacing, page margins, and placed images all move around indiscriminately. Curly quotes import properly, but that's actually a minus because there's no way to type them in Docs. Revisions made using Word's Track Changes feature appear all jumbled together as plain text; ditto for Comments. Page headers and footers are converted to inline text at the top of the document -- no surprise, because Docs doesn't even preserve pagination. Macros? Auto-update fields? Dream on.

The same goes for Excel files. Basic figures and formulas import properly -- which would be great if you were migrating from Lotus 1-2-3 -- but don't expect much else. Images are discarded, along with any formatting beyond simple cell sizing and shading. Charts embedded in Excel 2007 appear as big, white boxes labeled "No Data." Charts embedded in Excel 2003 or earlier simply disappear. It's often possible to tweak the Excel 2007 charts by hand so that they draw from the right columns, but even then, Docs' graphing engine is mostly a toy. There's no support for features like trend lines, no formatting options, and the output is hardly presentation-ready.

With PowerPoint files, Docs does an adequate job of preserving the basic look and feel of presentations, but again, it's a poor substitute for the original. Graphics appear blurry and re-sampled, text moves around without warning, and animations and transitions are eliminated. And here, Google doesn't bother making a pretense of supporting PowerPoint 2007.

Despite its faults, Docs does incorporate some intriguing, even revolutionary ideas. If the goal was simply to mimic the current office paradigm on the Web, Docs would be a miserable failure, but Google is looking at the bigger picture. If outside-the-box thinking excites you, you may want to give it a try.

For example, in keeping with Google's idea of working in "the cloud," Docs discards the usual files-and-folders desktop metaphor. Instead, it presents your documents in a chronological view resembling an e-mail inbox, based on what you worked on most recently. Similarly, you don't need to save multiple copies of documents as you make revisions because Docs maintains an internal version history for each document that allows you to view or revert to an earlier draft at any time.

Rather than simply re-creating desktop apps in the browser, Docs is Web-centric. You can import documents via e-mail or from the Web, or embed them in blogs or Web sites to share with the public. There's a UI for embedding YouTube videos in your presentations. There's basic version control to allow multiple authors to work on the same document. Forget paper; with Google Docs, it's all about sharing, collaboration, and online publishing.

A demo file created in Word 2007 (above) reveals just how many features Google Docs gets wrong. Charts embedded in Excel 2007 (below) appear as big, white boxes labeled "No Data." (Note: Click the images to enlarge them.)

But most of us in the real world have given up on the "paperless office," and once your feet land back on the ground, Docs disappoints once again. In keeping with its Spartan feature set, printing is thoroughly mediocre. As already noted, Docs seldom gets pagination right, particularly where images come into play, and it thinks nothing of breaking a page midtable. Fonts that render correctly onscreen might not print, and graphics come out blurry and jaggy.

Joel Spolsky once wrote that the problem with lightweight office suites is that 80 percent of users need only 20 percent of the features of Microsoft Office, but it's a different 20 percent every time. Google Docs doesn't give you all of the features of Office and it doesn't try to. Unfortunately, in its present state it's missing so much that it's sure to lack something for just about everybody.

Zoho: A SaaS back office for small businessZoho offers a slightly different take. While Google Docs presents a Spartan UI that emphasizes the online aspect of the suite, Zoho makes more of an effort to mimic the look and feel of traditional desktop applications. The results might seem more familiar to new users, but they also underscore the limitations of this strategy.

One problem is that Zoho's offering seems to have grown rapidly, with little thought to consistency. One application's menu might resemble a panel of buttons, while the next looks like tabs, and a third favors a drop-down layout. Icons and menus move around the toolbars from one app to the next. The spreadsheet's interface offers a choice of colored themes, but the other applications do not. A pull-down menu makes moving between applications simple enough, but the lack of a common UI undermines the illusion that this is an integrated suite.

Zoho has a few features that Google Docs lacks, but most are minor. For example, Google's word processor offers a robust equation editor based on the TeX language, but Zoho's equation editor is better. Zoho's thesaurus gives the part of speech for synonyms, while Google's does not. And Zoho allows you to insert HTML and CSS directly from files on the Web, rather than simply editing it in your browser as Google Docs allows you to do.

Like Google Docs, Zoho encourages Web-based publishing and collaboration. Here, Zoho's minor advantages include the ability to post to blogs directly using the MetaWebLog or Blogger APIs, the ability to generate a "doc roll" of recent documents for embedding in a Web site, and integration with EchoSign for digital signatures.

Zoho is slowly implementing more advanced features, too. Its spreadsheet offers rudimentary support for pivot tables and charts, while the word processor features a very basic mail-merge facility. Most remarkable, however, is the spreadsheet's elementary support for Visual Basic macros. I have to confess that when I saw some of my macros running automatically in the browser, I was stunned; still, other scripts failed with error messages.

All of these strengths aside, however, the overall problems with Zoho's applications are similar to those of Google Docs. While the suite is amazing as a Web-based curiosity and passable as a lightweight set of productivity applications, power users will be dismayed by its lack of sophisticated features and its halfhearted implementations of existing ones.

Zoho's support for Microsoft Office file formats is better than that of Google Docs, but only slightly. Page layout and image placement in the word processor are questionable, and revisions made using Track Changes get corrupted, just as in Google Docs. Support for Excel 2007 embedded graphs is a bit better than Google's, but the output is similarly disappointing. Imported presentations are reduced to static slideshows, losing their animated transitions. And as with Google Docs, printing is unreliable, particularly where fonts and images are concerned.

The beta status of Zoho's applications might also be an issue for some. I'd hardly call Google Docs bulletproof, but Zoho did seem to freeze up the browser more often (though a page reload would usually solve the problem).

Zoho's real strength lies not in the merits of its individual applications, however, but in its offering as a whole. In addition to its productivity suite, Zoho offers a whole range of back-office business applications, including groupware, conferencing, invoice management, project management, CRM, and more. Most are free for limited use with a modest amount of storage space; for increased capacity and a greater number of users, Zoho charges a per-head subscription fee.

As such, Zoho could appeal to small businesses who like the idea of a suite of a la carte business applications that don't require a dedicated IT staff to install and maintain. Although it seems unlikely that Zoho's online productivity apps will meet your needs as well as desktop software would, if the SaaS way of doing things is attractive to you, Zoho could be a cost-effective option that provides a wide range of business functionality with a minimum of hassle.

Zoho's support for Microsoft Office file formats (above) and Excel 2007 embedded graphs (below) is better than that of Google Docs, but only slightly. (Note: Click the images to enlarge them.)

Microsoft Office Web Apps: Office, everywhereAlthough Google Docs and Zoho are both flawed, Microsoft could hardly have expected to take this competition lying down. The Redmond-based giant is currently in the process of readying a fully Web-based version of its Office productivity suite, due to launch simultaneously with the release of Office 2010. While the Office Web Apps are currently only available as a Technical Preview (with a formal beta program to be announced later this year), they're already shaping up to become a formidable challenge to Zoho and Google Docs.

Nowhere is this more evident than when you import your first document into Word Web App. Unlike its competitors, Microsoft's online suite reproduces .doc and .docx files with absolute fidelity, down to the smallest detail. The results are jaw-dropping. Fonts, page spacing, headers, footers, auto-text entries, footnotes -- everything appears exactly as it does in the desktop version of Word. Images show up where they should, even when placed above or behind text. Documents that mix page sizes, or that alternate portrait and landscape modes from page to page, load correctly. And, most miraculous of all after experiencing the competition, printing is flawless.

1 2 Page
Insider: How the basic tech behind the Internet works
Join the discussion
Be the first to comment on this article. Our Commenting Policies