Software // Productivity/Collaboration Apps
News
12/11/2013
12:40 PM
Connect Directly
LinkedIn
Twitter
Google+
RSS
E-Mail
50%
50%

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.)

Comment  | 
Print  | 
More Insights
Comments
Oldest First  |  Newest First  |  Threaded View
anon4453030347
50%
50%
anon4453030347,
User Rank: Apprentice
12/11/2013 | 2:42:35 PM
Google sheet
Its a good step by Google. Now every can edit google docs sheet offline. Thanks to Google:)

Blog: GPS Tracking
JSORENSEN980
50%
50%
JSORENSEN980,
User Rank: Apprentice
12/11/2013 | 3:56:53 PM
Check out Smartsheet
Those who want to collaborate with others in a familiar spreadsheet interface, but also want/need collaborative features like file sharing, auto reminders, and the ability to share a sheet, or just a single row, along with sophisticated project management features like a Gantt chart and dependencies, should check out Smartsheet.com. Easy like Excel, but way better for coordinating work that's shared between teams.
David F. Carr
50%
50%
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)
Kristin Burnham
50%
50%
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.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest - July 22, 2014
Sophisticated attacks demand real-time risk management and continuous monitoring. Here's how federal agencies are meeting that challenge.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.