With Google Earth

Google batch geocoding

To find the spreadsheet and worksheet ID for your Google spreadsheet:

  • Save and publish the spreadsheet (Warning! Don't publish private data!)
  • Click on "More Publishing Options, " change file format to ATOM & generate URL
  • Find the parts of the URL that match the example below and paste them in.

Click "Load Worksheet Data" button when done. If your worksheet loaded successfully & you're using Firefox, you'll see a snapshot of the column data below. Note that the first row is treated as the header row - so it's best to put descriptive column titles there (e.g. "year", "revenue").

Pick column names

Please choose one column that has descriptive information (to help you identify the locations) and one column containing the addresses of the locations. To help us find your locations, please include as much information as you can in the addresses (city, state, zip, country, etc.). To quickly add the same extra info to all your addresses, create a new column in your spreadsheet and type, for example, =B1&"City, State ZIP". You can then paste that into every cell in the column, and use that column for the full address.


Check Output & Copy to Spreadsheet

On the map below, you'll see markers plotted where we think your addresses mapped to. For those addresses that we couldn't find a latitude & longitude for, we've placed markers along the bottom of the map that you can drag to the correct location. You can browse the markers using the map or the table in the sidebar. When you've verified the addresses are correct, you can select the latitude & longitude values in the scrolling table, copy them, and paste them into your spreadsheet.

Doyle Park...just up the street from my

by bikeriderdude

Office on Sonoma Avenue (towards Farmer's Lane).
Be great if you can bring a kid. We'll talk before then, but I'm pretty sure I can get my whole family to come.

7 Game of Thrones Apps That Will Get You Through the Much-awaited Winter  — Gizmodo India
.. or Winterfell, you get a dialog box, which asks you to buy more maps. Unfortunately, you can't dismiss the dialogue box, leading to the obstruction of the cartography. ..

Flagstaff's rocky lava field became a little piece of the moon  — azcentral
If American know-how could put a man on the moon, the man should bring back rocks to study. The government agreed, and in 1963, the .. Volcanoes were chosen because of the moon's volcanic history, the test site for its impact craters.

O'Reilly Media Google Maps Hacks
Book (O'Reilly Media)
  • Used Book in Good Condition

Missing in Alaska without a trace  — Anchorage Daily News
The official version of events, according to a still active missing person's bulletin from the Alaska State Troopers is that Griffis went into the wild "to test out a survival 'cocoon' that he had invented.

No Starch Press Map Scripting 101: An Example-Driven Guide to Building Interactive Maps with Bing, Yahoo!, and Google Maps
eBooks (No Starch Press)
Wrox Professional Android 2 Application Development
Book (Wrox)
Garmin Garmin nuvi 880 4.3-Inch Widescreen Bluetooth Portable GPS Navigator
GPS or Navigation System (Garmin)
  • Sleek, ultra-slim design fits in a pocket; High-sensitivity GPS receiver for fast satellite lock
  • Pre-loaded with City Navigtor NT maps for North America, including more than 6-million name-searchable points of interest
  • Speech recognition -- speak menu options and keep your eyes on the road
  • Multi-destination routing -- enter several destinations and get the best route to all of them; Where am I? and Where s my car? features
  • Full feature set -- text to speech for spoken directions with real street names; MP3 player, and Photo viewer

Popular Q&A

avatar
What alternatives to Google exist for geocoding?

I am just starting to experiment with simplegeo ($9/month) for geocoding and some other useful features.
Check out yahoo place finder for a free geocoding service

Related Posts