How would you like to take any kind of street address list, for example copied from an Excel spreadsheet, and automatically geocode the addresses to get latitude and longitude coordinates? Then, map the data in your browser, download it into Google Earth, save it to a web page, or transfer it back into your spreadsheet?
You CAN with Batch Geocode!
Batch Geocode provides an Excel template for data entry. You could also use a data source of your own and map the address cells to match the online Batch Geocode tool.
I downloaded their template, deleted the sample data and entered my own addresses. After cutting and pasting the data from the provided spreadsheet, it looked like the graphic below. A couple of clicks later, I had an interactive Yahoo! map with all of the addresses pinpointed.
The spreadsheet also has provisions for changing the colors of the pins. For example Group 1 might be green for sales, Group 2 might be red for listings, blue for pending sales, etc. BatchGeocode will even allow you to link to photos and website addresses.
Appraisers and salespeople can also use this tool to calculate distances to multiple addresses from a single point, or get quick driving directions to multiple destinations. Using your own data, it just takes seconds to plot it into a fully interactive multi-point map.
Click below for the map that resulted from the data input above . . .
What are some other uses . . . . .
- Plot Multiple Address Points on a Map - Copy directly from spreadsheet program such as Excel or the free equivalent OpenOffice Calc.
- Multiple Destination Driving Directions - Location points are linked to Google Maps for driving directions ("Calculate Distance" option.)
- Distance Calculator - Calculate the distance in miles or kilometers to several locations from a single address.
- Satellite Photos - Addresses are linked to Google Maps for satellite photos and driving directions.
- Make your own Google Earth KML - Quickly create KML files with your address data for 3D viewing data in Google Earth.
- Locate several address coordinates for use in development of a online map mashup using Yahoo Maps or Google Maps.
- Save your multiple mapped locations and associated data to a web page for later use.
- Import latitude/longitude coordinates into a SQL database for usage in a GIS application.
- Plan a road trip - make yourself a road trip map for your next vacation, include hotel addresses and sites to see.
- Plot a list of real-estate property addresses on a map with photos to link from a web site or for emphasis in a presentation.
- House Hunters - use a saved location map to keep a reference index of your favorite properties.
- Outlook and Thunderbird both support exporting their address book to tab-delimited formats, use this tool to make a map of your contacts list.
- Get center coordinates (centroids) for a listing of zip codes, cities, or states.
- For quick single address geocodes, zip code, city or state centroids use our Single Address Lookup Tool
For more information - click here.