Yes, another one of those. Last week I had to geocode a bunch of addresses which were held in a csv file and came across this really handy geocoding utility/page, (which you can download it on your PC) written by Esa. As expected, it takes a list of addresses and geocodes them. Geocoded addresses and coordinates are listed on an output textbox whereas addresses that cannot be geocoded are listed on a different textbox. Any geocoded addresses are also placed on a map.
The only problem was that I had a whole load more data to go with the address strings and I really wanted an input/output process, where I would take my input csv file, process it and get the original csv plus the lon/lat coordinates. So I slightly changed the code on the page. The idea is that you have a csv file with your data in BUT the bit that includes the address has a different separator than the rest of the data, e.g. a semi-colon. For example:
<id1>,<name1>,<surname1>,<telno1>;<address1> <id2>,<name2>,<surname2>,<telno2>;<address2> <id3>,<name3>,<surname3>,<telno3>;<address3>
Note the ‘;’ between the tel no and the address. The new page will take this list, and geocode it so the end result would be:
<id1>,<name1>,<surname1>,<telno1>;<address1>,<lon1>,<lat3> <id2>,<name2>,<surname2>,<telno2>;<address2>,<lon2>,<lat3> <id3>,<name3>,<surname3>,<telno3>;<address3>,<lon3>,<lat3>
You can download the new page here.