Converting addresses to coordinates

[sayling]

I have a largish list of nearly 500 addresses in an excel spreadsheet that I want to convert into longditude and latitude references, so that I can turn the file into an ov2 overlay.

Does anyone have any ideas other than looking them all up individually?

And, as I don't intend to repeat this exercise, I don't really want to spend any money - tight git that I am

[mike142sl]

There is no simple quick way to do this from an address list. Even looking them up individually via www.streetmap.co.uk will show minor discrepancies and you will need to 'move' the arrow on streetmap to its proper location a few times.

However if you have Outlook (not express) you might be able to convert the spreadsheet into a list of contacts. Then if you have TTN5 you can navigate direct to each contact.

Just checked and you can import an excel file into your list of contacts. You may have to adjust the spreadsheet to match appropriate columns though, and split first names and last names to separate columns etc.