Google Sheets Gets Offline Editing - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Productivity/Collaboration Apps
12:40 PM
Connect Directly

Google Sheets Gets Offline Editing

Update to Google's online spreadsheet app brings much needed speed and other features.

Android Security: 8 Signs Hackers Own Your Smartphone
Android Security: 8 Signs Hackers Own Your Smartphone
(click image for larger view)

Google on Wednesday plans to introduce a new version of Google Sheets, its online spreadsheet.

Part of the Google Apps suite, Sheets has long stood in the shadow of Microsoft Excel, one of the pillars of that company's battered but still vital Office empire.

Through a major rewrite in 2010 and the recent integration of QuickOffice, Google has managed to make Docs, another part of Google Apps, into a viable alternative to Microsoft Word, at least for creating content and sharing it online. But its spreadsheet still doesn't get much respect, particularly when used to import files that originated in Excel.

In February, a PC World comparison found "Microsoft's Excel Web App is superior to Google Spreadsheets," to say nothing about the capabilities of the desktop version of Excel. And in a March column, CNET's Stephen Shankland characterized Sheet's import capabilities as inferior. "When it comes to importing and editing files from the incumbent power, Microsoft Office, Google just isn't meeting even my low-end needs," he wrote.

The new version of Sheets should improve its standing, though it won't provide complete parity with Excel. But then Google isn't trying to clone Excel online. Rather, it seeks to provide a functional alternative that offers unique collaboration capabilities at a more affordable price point.

With this latest update, Google has made Sheets faster, removed old size limits, and added the ability to create and edit Sheets offline, a feature already present in Docs and Slides. The fidelity of imported files has also been improved through revised text wrapping code, expanded number formatting options, and bug fixes.

[Google's Web-to-TV media device has also been updated. See Google Chromecast Adds 10 Apps.]

The revised Sheets includes a feature called Filter Views that allows users to create custom views of data without altering how data is presented to others with shared access to the file. This function can be accessed from the Data menu.

There are new formulas, like SUMIFS, and a new inline help experience, backed by links to online support articles.

Speed has been enhanced significantly, something that's particularly noticeable when scrolling through large, complex spreadsheets.

Perhaps the most meaningful change is the ability to create and edit Sheets offline. Those who have already set up Docs or Slides to work offline can expect Sheets to work offline without doing anything. Other users must install the Google Drive Chrome Web app -- the offline functionality for Google Apps is available only to Chrome users.

Sheets also adds the ability to create spreadsheet tabs with different colors for easier visual identification. It is available initially on an opt-in basis so Google can collect feedback and make changes if necessary. To use the new software, select the Setting menu item in Google Drive, choose the Editing tab, and click the "Try the new Google Sheets" checkbox.

Thomas Claburn is editor-at-large for InformationWeek. He has been writing about business and technology since 1996, for publications such as New Architect, PC Computing, InformationWeek, Salon, Wired, and Ziff Davis Smart Business. Before that, he worked in film and television. He’s the author of a science fiction novel, Reflecting Fires, and his mobile game Blocfall Free is available for iOS, Android, and Kindle Fire.

Consumerization 1.0 was "We don't need IT." Today we need IT to bridge the gap between consumer and business tech. Also in the Consumerization 2.0 issue of InformationWeek: Stop worrying about the role of the CIO. (Free registration required.)

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
Kristin Burnham
Kristin Burnham,
User Rank: Author
12/12/2013 | 8:50:34 AM
mobile version
I use Google Docs often, but haven't found the mobile version of spreadsheets easy to use. It's not optimized for the screen size and cumbersome to edit on the go.
David F. Carr
David F. Carr,
User Rank: Author
12/11/2013 | 4:46:31 PM
How do you work this thing?
I confess I've never gotten the Google Drive offline mode to work, although I've futzed with it several times. Not intuitive (or maybe I'm just dense)
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

How CIO Roles Will Change: The Future of Work
Jessica Davis, Senior Editor, Enterprise Apps,  7/1/2021
A Strategy to Aid Underserved Communities and Fill Tech Jobs
Joao-Pierre S. Ruth, Senior Writer,  7/9/2021
10 Ways AI and ML Are Evolving
Lisa Morgan, Freelance Writer,  6/28/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Flash Poll