My Google spreadsheet fail

commentary Google wants it to be a "non-issue" when Google Docs and Chrome OS users work with Microsoft Office files. CNET News' Stephen Shankland ran into hitches and glitches that show that's not the case.

(Credit: Google)

I'm a cloud-computing, Chrome OS fanboy for the most part. But today was one of those days I was glad to have old-school Mac and Windows PCs lying around my home office.

I'm no power user, but Google Docs suits me for word processing, while Google Sheets works fine for creating spreadsheets. However, when it comes to importing and editing files from the incumbent power, Microsoft Office, Google just isn't meeting even my low-end needs.

Google handles such documents — in either the older .doc and .xls formats, and the newer .docx and .xlsx formats — in a variety of ways. With most browsers, Gmail offers two choices in addition to downloading an attached document: the first is a viewer that provides a non-interactive glimpse of the document's contents; and the second is the option to open it as a Google document.

On Chrome OS, there's a third option via the QuickOffice software that Google acquired to let its browser-based operating system handle files. At the moment, this software, written atop Google's Native Client programming foundation, allows you to view Office files. And, coming in the next three months, QuickOffice will let you edit Word and Excel documents, too, according to Sundar Pichai, leader of Chrome (and now Android).

"We want to make it a non-issue if you run into Office files," Pichai told me in February, giving the example of his daughter's teacher sending an Excel spreadsheet virtually and him filling it out and sending it back.

This morning, I encountered that exact situation while trying to make a hotel reservation. I can understand if Google Sheets or QuickOffice can't handle a complicated Excel spreadsheet with lots of pivot tables and other complicated factors, but in this case, neither platform could handle a spreadsheet with fairly basic formatting. In the end, I wound up bypassing Google's software altogether.

Below are screenshots of the Google Sheets translation, the QuickOffice view and the Gmail viewer so you can see how bad it is. Note, for example, in Google Sheets how the date-of-birth label got overwritten by adjacent cells. I initially thought it was a field for today's date, not my birthday, because all I saw was "dat".

Google Sheets made a hash out of a fairly unsophisticated Excel spreadsheet, overwriting words and dropping a graphic altogether.
(Credit: Stephen Shankland/CNET)

Google's QuickOffice software, built into Chrome OS, fared better than Google Sheets, perhaps because it doesn't have to worry about compatibility with Google Sheets.
(Credit: Stephen Shankland/CNET)

The Gmail preview tool did the best job providing a look at the spreadsheet — though it can't handle high-DPI displays, such as the one on the Chromebook Pixel.
(Credit: Stephen Shankland/CNET)

Now, for comparison, here's the Microsoft Excel version:

(Credit: Stephen Shankland/CNET)

I trimmed off the acres of space squandered by the ribbon, of course, but that's a different complaint.

The QuickOffice version was a lot closer to the original than the Google Sheets version, which I'll take as a good sign only to the extent that it shows Google technology might someday be up to the task of importing spreadsheets. The reason why I'm pessimistic: Google obviously wants people to live their productivity lives in Google Sheets, not in some pale reflection of Microsoft Office.

I fear the reason the Google Sheets import function is so inferior (and I've had other ugly Excel imports, too) is that the file format for it is fundamentally pared down to handle Excel fully. In the long run, this might make sense, because Google, no doubt, is increasing the number of native Google Sheets documents and building its corner of the productivity world.

But with so many coming in from Office, and, even worse, maintaining a presence both there and in Google Apps, Google really should do better.

And don't get me started about Google Slides coping with PowerPoint files.

Via CNET.com

Previous Story

Facebook's plan B: new ads in newsfeed

Software
Next Story

Bitcoin hits US$105



Add Your Comment 1


Post comment as
 

Chandler posted a comment   
Australia

Whilst I haven't done a lot of importing myself, I have also found that Google's "Office" suite it's not quite ideal, and with the coming closure of Google Reader (which I use frequently - and for catching up on new articles on CNET :D) I have to say I agree with the general sentiment of Microsoft's mockumentary "Googlighting" where they poke at Google's "Office" apps that change regularly due to Google tweaking features and adding and slashing them...

Apart form the potential for your 'primary' "Office" applications changing overnight, Google Docs can't handle some of the more complex features of Microsoft's suite: Word Documents - a prime example with some documents I wanted to import were their headers and footers: whilst Google Docs inserted the image in the header properly on the first page header, for some reason it doesn't translate across to the following pages (the space is there but the image is not displayed...). It also doesn't (appear) to have any functionality for different headers between the first and second pages (MS Word's "First Page Header" option).

Google Sheets also does not process formulas too effectively. Admittedly, my sheet in question is quite complex with array formulas (see "CSE" from "Ctrl Shift Enter" formulas for MS Excel) - which is good that you can do by the way - but when making changes to the sheet it regularly locks up whilst it is "Working..." and calculating the formulas, sometimes for minutes at a time. Add to this having someone else viewing/editing the sheet at the same time (one of Google's most advertised features for the Office suite...), and by golly I hope you've got time for the sheet to calculate... mine frequently ends up showing up as "Offline", even though my network connection is fine...

:)




Sponsored Links

Recently Viewed Products