Google Docs Help: Map From Web Data Using Google Spreadsheets

Create a map from web data using a google docs spreadsheet

Webdata => Map

Create a map from web data using a google docs spreadsheet 

Grab data

Use a function to pull in external data

  =ImportFeed( ) to import RSS feed data

              or

  =ImportXml( ) to import xml

   For help visit http://docs.google.com/support/spreadsheets/bin/answer.py?answer=75507

 

   You can also use copy and paste to put (static) data in the spreadsheet.

 

Simple cleanup

In a free column of create the addresses you want to map.

E.g.

  • column contains addresses: use simple reference =B2
  • xml file contains Dutch zip codes: use =CONCATENATE("Nederland" , B2 ) to locate the zip code in The Netherlands (Nederland).

 

If you want display a tooltip when you click a location in the map, add the tooltip text to an adjacent column using formula like  =CONCATENATE(B6,"",C6,"",D6)

Make the map

Use the map gadget to display the google map

http://documents.google.com/support/bin/answer.py?answer=91601

 

Demo

1) http://spreadsheets.google.com/ccc?key=pUO-f6weoyVMtalkQrQiARg&hl=en_GB (editable version)

{

http://spreadsheets.google.com/pub?key=pUO-f6weoyVMtalkQrQiARg

 ( Purpose see http://groups.google.com/group/google-mashup-editor/browse_thread/thread/d9b088742c36e59e 

  xls file  http://spreadsheets.google.com/pub?key=pUO-f6weoyVMtalkQrQiARg&output=xls  )

}

 

2)   http://spreadsheets.google.com/ccc?key=pUO-f6weoyVN9D8XS0eX3OQ&hl=en_GB   (editable version)

{

 http://spreadsheets.google.com/pub?key=pUO-f6weoyVN9D8XS0eX3OQ

 ( xls file http://spreadsheets.google.com/pub?key=pUO-f6weoyVN9D8XS0eX3OQ&output=xls  )

 }

Comments


CRL Jones

Some useful tips

I found this didn't help me get the geocode coordinates - but this did.

in Cell A2 enter "http://maps.google.com/maps/geo?output=csv&q=" (inside quotes)

in Cell B2 enter a CityName or Postal Code like "Edmonton" or "T6E2A7"

in Cell C2 enter this formula "=ImportData(CONCATENATE(A2,B2))" (inside quotes)

This formula concatenates the geocode query + city/postcode to produce the 4 geocode characteristics:

1) http status (like "200")

2) Accuracy parameter (like "4")

3) latitude and 4 longitude (in decimal)

Thanks to Esa from Finland - he has alot of good geocode tools + info at his blog.

http://apitricks.blogspot.com/2008/10/geocoding-by-google-spreadsheets.html provided some

Last edited Nov 1, 2008 11:46 PM
Report abusive comment
©2009 Google