Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

Review: Microsoft Office 365 vs. Google Apps

Woody Leonhard | Jan. 9, 2014
Web browser or Office suite? Microsoft's and Google's office productivity and collaboration clouds pit rich and complex against simple and lean

Office 365 Outlook Web App
Figure 4: With the business versions of Office 365, you also get access to the Outlook Web App, which works on just about any browser, on any platform.

There's a huge array of additional differences between the productivity apps in Office 365, compared to Google Apps for Business. Office documents almost always survive a round-trip through the Office Web Apps. For example, you can use Word Web App to open a fairly complex Word document, make a few changes, save it, and expect to get back a document that looks more or less like the original. You can't add any fancy formatting to the document in Word Web App — the options aren't there — but at least you won't break anything ... usually.

Google Docs, on the other hand, has no such guarantee. In my experiments, I've found that most simple documents go through the round-trip with few problems. Save a straightforward memo with Google Docs (File, Download As, Microsoft Word), and you're likely to come up with a reasonable rendition in the DOCX file. Not long ago, Google Docs broke a very large percentage of all the Word documents handed to it. Now, it appears to me as if Google refuses to open Word documents it doesn't understand. That's an improvement, albeit a frustrating one.

That said, Google Docs, Sheets, and Slides have nary a fraction of the features offered in the desktop versions of Word, Excel, and PowerPoint. You would never want to put together a moderately complex document in Google Docs, for example. Just getting the headers and footers to work right would drive you nuts. Then again, complicated headers and footers in Word aren't a walk in the park, either.

The Office programs are well established and mature. Google Apps are scrappy and improving. Case in point: pivot tables. While the Google implementation of pivot tables in Sheets isn't as capable (or complicated) as Microsoft's, Google hits the high points very nicely.

Google is also playing catch-up in other areas your business might care about. Google Apps Script is a JavaScript variant designed to build macros for the Google Apps. The Scripts run in the cloud, not on your machine. There's an active, if young, developers' site to help get started. Microsoft Office, on the other hand, exposes an enormous amount of information — a huge API — for custom development using .Net (or even Visual Basic for Applications). Those programs run on the local machine. There's a huge ecosystem of programmers, books, and code for Office-related development, as well as help for would-be Office add-on programmers. Office has a lot more power and flexibility on the PC, while Google runs rings around the Web.

 

Previous Page  1  2  3  4  5  6  7  8  9  10  11  12  Next Page 

Sign up for Computerworld eNewsletters.