I want to batch populate a new sheet from a list of pre generated URL search strings. one column of information per url if possible. from there I am going to clean out all but one line of information that I am going to use to return a true/false result. the information comes in uniformly and I can easily select the desired line of data and erase the rest.

currently i am using the generated hyperlinks by clicking each one, looking at the web page result and manually returning a value to a cell. I dont want to have to do this for the 4000 entrys i have in the list! loading the data from web or xml is just as tedious as it is a one at a time action... there must be a simple way!

also, is there any way to keep the information returned from the XML import isolated to a single column? the results seem to tab over to new cells at one point leaving empty cells to their left.

example: http://www.google.com/maps?q=1200 11...th bellevue wa
(all i want to know is the distance)

Thanks!