Add, edit, sort, and filter: Improved mobile access to spreadsheets

Posted on: February 23, 2009

now this is really usefu1 isn’t it?


via Docs Blog by Google Docs on 2/13/09

Over a year ago, we enabled view-only access to docs from mobile devices. This has come in handy for me because I use Google Docs spreadsheets to keep track of a lot of nerdy and not-so-nerdy things in my life. I’ve often found myself wanting to access my spreadsheet data on the go, when I’m not near a computer.
Today, I’m happy to announce that we’ve made mobile access even better by adding new capabilities with List View for spreadsheets. You can quickly view, edit, sort, and filter your spreadsheets on a variety of mobile devices including Android-powered devices like the T-Mobile G1, the iPhone and iPod touch, and the Nokia S60.
With Valentine’s Day coming soon, I’d like to share two ways that List View is helping me to play cupid.
Last week I was trying to find some Broadway tickets to surprise my boyfriend for Valentine’s Day. A friend of mine at a ticket agency publishes an online spreadsheet with a list of last-minute available tickets. From my iPhone, I was able to quickly access his spreadsheet to see upcoming shows:
Mobile List View showing all shows (sorted by “Show” column).  Shown in portrait mode on the iPhone.
From here, in just a few taps, I was able to filter down to tickets available on Valentine’s Day:
Choosing a filter for the “Date” column.
I could see only the rows that matched my filter, and I eventually found a show that I knew that my boyfriend would like: “Billy Elliot The Musical” at 7pm with orchestra seats.
All rows matching the “2/14/2009” filter.
With tickets purchased, and a restaurant booked, I’m nearly set. Here’s another example of how this enhanced mobile access will come in handy tomorrow night. A few of my friends and I like to think of ourselves as wine aficionados. We rate wines that we like (and don’t like) in a wine diary and it’s kept in a shared spreadsheet. On the T-Mobile G1 or the iPhone home screens, we all have shortcuts which link directly to the spreadsheet.
Mobile List View showing all wines. Landscape mode on the G1.   
While at a restaurant or wine bar, we can see each others’ recommendations and note our likes and dislikes.  Here I can view and add a new entry:  

Mobile List View “Add row” widget on the G1.
Tomorrow night, mobile access to this spreadsheet will come in handy when presented with a big wine list, with my significant other looking at me across the table waiting for me to pick a wine (already).
Try this out by pointing your mobile device’s browser to m.google.com/docs. And if you use Google Apps, go to docs.google.com/a/your-domain. This feature is available in all 38 languages that are supported in Google Docs spreadsheets.

Posted by: Eric Bogs, User Interface Software Engineer

Posted via email from PointStar


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


  • None
  • bigsurf: yeah it's really cool.. well i guess you can also come to Singapore as there's a big cosplay thing going on here too!
  • Lasitha Silva: I also like to have a snap with a Star wars character. And I think..I need to be at Tokyo for that. Coz I love to be there too.
  • Mr WordPress: Hi, this is a comment.To delete a comment, just log in, and view the posts' comments, there you will have the option to edit or delete them.


%d bloggers like this: