Geocode batch conversion + latitude, longitude, formatted address

I recently worked on a project that required getting latitude and longitude based on unstructured addresses. My advisor found me a website that run this conversion in batch and it turned out that website was quite decent.

http://www.findlatitudeandlongitude.com/batch-geocode/

Looking at its javascript a bit, they seem to be using Google’s API. So, if you just put in any piece related to something’s location, it will do its best to convert into normalized address, and latitude-longitude coordinates. Here’s an example.

"original address","returned address",latitude,longitude,accuracy,status code
"georgia tech","Georgia Institute of Technology, North Ave NW, Atlanta, GA 30332, USA",33.775618,-84.396285,3,200
"seoul","Seoul, South Korea",37.566535,126.977969,3,200
"white house","The White House, 1600 Pennsylvania Avenue Northwest, Washington, DC 20500, USA",38.897676,-77.03653,3,200

It seems to be a pretty useful research tool for me as I don’t have to code for myself to get to the Google’s geocoding API.


Also published on Medium.