I have a question regarding Google Maps integration I am planning for my site. Right now I have a list of approximately 5,000 addresses (Street Address, City, and Zip Code). I would like to add two columns to the table these address are stored in for Longitude & Latitude so that when a user visits a particular location's page, a Google map can be served up with the chosen location being centered on the map with a marker.
I've tried reading the API; however, it doesn't seem to me there is a way to submit a request of the address I already have to get the Longitude & Latitude. It seems that the API only dynamically generates this info through JS or XML. Does anyone know if there's a way to submit something like an XLS or CSV file to get the longitude & latitude directly? Or, if there's a service that offers this?