Advanced: Using the Geo script for Google Docs

This article comes from the Silk Data Handbook Once you ended up with a suitable spreadsheet, you can import the spreadsheet into your Silk site.

After you’ve installed this Geo script in Google Spreadsheets, you can use the MapQuest Nominatim or Yahoo PlaceFinder services to get geocodes for your addresses.

Uses

  • Export spreadsheet data to GeoJSON Any spreadsheet with geocodes (longitude and latitude coordinates) can be exported to a TileMill-ready file. After exporting, just copy the GeoJSON file to your TileMill/files/data directory.
  • Geocode arbitrary addresses If your spreadsheet does not have geocodes, you can add them using a geocoding service like those provided by Yahoo PlaceFinder or MapQuest Nominatim orCicero API. Consult these services for their terms of use.

Installation

  • Copy the source of mapbox.js
  • Open your spreadsheet and goto tools &> script editor
  • Replace the content in the text box with the copied source from mapbox.js
  • Set the name of this script to geo
  • Go to file &> save and close the popup window
  • Refresh your spreadsheet and you will see a new menu called Geo added after Help on the menu bar