New features for Google Spreadsheets

Google's spreadsheet gets a weird new auto-fill function, and RSS import feature, and a way to stalk other users.

First, the bad news: No, Google is not announcing a business wiki or presentation product at the Office 2.0 conference. However, I did get a demo of a few new features in Google's spreadsheet.

First, there's a new autofill function. If you enter a series of consecutive numbers, it will extend the series. OK, yawn. But, using data provided by the old Google Sets experiment, the spreadsheet will automatically fill in a row or column with items it thinks match your selection if they're not in an obvious sequence. For example, highlight a name of a state, press Ctrl (on a PC) and drag down a few cells, and the spreadsheet will fill in other states. You can also try a state of mind (e.g., "happy") to get other emotions. Or names. The more items you select before you control-drag, the more likely Google is to fill in items you expect, as opposed to wild guesses.

Google Apps product manager Rishi Chandra demos spreadsheet user stalking. Rafe Needleman / CNET

Second, you can now pull in data from other sources, including RSS feeds. (For instructons, see this Google Help page.) This means the Google spreadsheets can now be real-time, for any data that's expressed in an RSS feed. Previously, you could look up certain real-time data, like stock prices, but this is much more flexible.

There's another important feature that launched a few weeks ago: If you're collaborating with someone on a Google spreadsheet, cells that other people are working on are color-coded by user. When someone starts to edit a cell, it will get grayed out so you don't collide with their edits. You can also follow a user as they read and edit a spreadsheet. This is a feature I've been waiting for. It's great for collaboration and training.

Featured Video
This content is rated TV-MA, and is for viewers 18 years or older. Are you of age?
Sorry, you are not old enough to view this content.

Roku 4: Our favorite TV streaming system gets 4K video and a remote locator

Ever lose your remote in the couch cushions? Ever wish you could stream 4K Netflix without having to use your TV's built-in app? Roku's new high-end player, the $129 Roku 4, brings these new extras to its best-in-class streaming ecosystem.

by David Katzmaier