Aug 232006

Thanks to Geography 2.0: Virtual Globes for news that excellent online spreadsheet EditGrid now has an official add-on that supports the creation of KML for spreadsheet data. This means that spreadsheet data can be displayed on a Google Map or Google Earth.

Online spreadsheets lend themselves to all sorts of collaborative projects, whether sharing weather data, fieldwork measurements or any other kind of spatially located information. EditGrid is very student-friendly and intuitive to work with, as the following demonstration shows.
I have created a open spreadsheet which is dynamically illustrated below (i.e it will update when the data set is edited.)

Online Spreadsheet by user/juicygeography.

Feel free to edit and contribute to the spreadsheet, click the “done” button and observe the changes in the map below. I would be interested in ideas for potential projects. Note that the spreadsheet requires longitude and latitude in decimal format. Here is an online converter. Many online maps, such as Multimap will output coordinates as decimal degrees to save the hassle.

The spreadsheet can also be seen in Google Earth.
google earth link
Click here for the file.

Note that you’ll need to refresh the network link once loaded in Google Earth in order to see any changes to the spreadsheet. (Right-click on the folder and choose ‘refresh’)
I wonder how long it will be before Google Spreadsheets adds similar functionality? There are other free online spreadsheets, for example IRows which offers a chart function. EditGrid remains my favourite for several reasons. It’s very easy to use, there are several options for exporting the data and publishing to web pages. Judging by the EditGrid blog there’s lots more features to come soon, including charts (yay!) EditGrid is open source, free to use and a triumph for the developers.