geocoding in excel [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 10 years ago.

Improve this question 开发者_Python百科

I have excel sheet with address column. Latitude and Longitude is required for these addresses.

How to fill next column with 'Latitude' and second next column with 'Longitude' ? Is there any helpful tool ? any suggestion ?

---

I forked and updated a tool that does this very easily: Excel Geocoding Tool

---

I'm not certain that it can do exactly as you ask but Google Fusion Tables has geocoding capabilities

---

One or more of the below links may provide an API so that you can geocode in Excel. Otherwise, at least some of the sites support the copying and pasting of such data to get the job done manually:

• http://geocoder.us/
• http://www.batchgeo.com/

More urls sans http that you may also find useful, in this form to circumvent stackoverflow filter:

• www.simplegeo.com
• www.vterrain.org/Culture/geocoding.html
• www.mooreds.com/wordpress/archives/296