3 ms·
Trying to reorganize the locations in a useful way. Started by country but this raises the problem that Canada - Pacific - Vancouver isn't close to US - Pacific
by asolove 17y ago
Trying to reorganize the locations in a useful way. Started by country but this raises the problem that Canada - Pacific - Vancouver isn't close to US - Pacific - Seattle in the list. Other ideas?
- seiji 17y agoHave people use lat/lng? You can add two new columns for latitude and longitude populated by: =GoogleLookup("address to geocode", "latitude") "Address to geocode" can probably be made using the existing city/country columns. Then you can automatically make a map directly from spreadsheet data: http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsmapwizard/makecustommap.htm http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsma...