2
votes
2answers
3k views

Is there a way to populate a spreadsheet of city names with their latitudes and longitudes from Google Maps or some other service?

I have a long list of cities in the United States, and would like to get the coordinates for each city without looking up each one individually. Is there a way to do this?
4
votes
4answers
2k views

Using a list of geographic locations, and determining the X closest locations to a user-defined location

I've got a list of geographical locations in an Excel spreadsheet. I want users to be able to search for a user-defined location, and then have the X number of closest locations from the list pulled ...