Convert File So I can GeoCode

 

I have found a website that gives me the addresses of multiple locations ...

How can I take this data and import it into a spreadsheet so that I can easily geocode them all?

For example ...

Wisdom Ranch School
PO Box 166
Arco, ID 83213
Phone: (208) 527-4750

Wood River High School
1250 Fox Acres Road
Hailey, ID 83333
Phone: (208) 578-5020

But in order to run them through a GeoCode tool they have to be in this format, right?

Wisdom Ranch School, PO Box 166, Arco, ID 83213, 208) 527-4750

Wood River High School, 1250 Fox Acres Road, Hailey, ID 83333, 208) 578-5020

--
Aaron Grames

.

If you have Microsoft Excel it would be pretty simple to move the data into columnar format.

But before you spend time creating your own file, have you looked at this file http://www.poi-factory.com/poifiles/us/schools