Friday 2 May 2008

Easily and Simply Add Data to Google Doc Spreadhseet from a Mobile Device?

I had a thought today with which I'm quite pleased. If someone has already thought of this then hey, cool and props to you!

Just in case you could find a use for easily adding data to a spreadsheet from a mobile phone without having to mess about with cells and cursors, then this will work a treat.

All you need is a Google Apps account (which is free and comes with a normal Google account, go to http://doc.google.com for details) and a mobile device that can view simple web pages.

Here's what you do;
  • Open up (or create) your Google Docs Spreadsheet and design yourself a form by clicking on Share and selecting to fill out a form.


  • Once you've done all that, enter your own e-mail address as an invitee, but don't Include form in invitation e-mail (this didn't work in my testing).
  • Click on Invite People.
Now you should have an invite e-mail is in your inbox. Just access that e-mail from your mobile device and click on the link at the top of the e-mail. What will open is a dead simple form which you can fill in. When you're finished, click on Submit.

The data you entered into the form has now been added to your fully functional Google Docs spreadsheet.


You can keep this e-mail in a folder ready for use and re-use whenever you need it and the benefit of it going into a Spreadsheet is that it is easy to manipulate and any formatting conditions or charts can and will be up-to-date for when you go and view your spreadsheet properly.

Since every submission has an automatic timestamp, this could be useful for fieldworkers who need to enter simple information after a job or, as I've done here, for keeping a track on your fuel economy.


No comments: