Map Multiple Locations / Find Address Coordinates



Locate multiple addresses internationally - North America & Europe - calculate distances - make your own mashup map - instantly.  

Take any kind of street address list, for example copied from Excel, and geocode the addresses to get latitude and longitude coordinates using the tool below. The data can then be mapped in your browser, downloaded into Google Earth, saved to a web page, or transferred back into your spreadsheet. You can also use this tool to calculate distances to multiple addresses from a single point, or get quick driving directions to multiple destinations. Mapping multiple locations with your own custom data takes seconds, just follow the 6 steps below to plot your own data on a fully interactive multi-point map. It's fast, easy, and - free to use!

Is this not what you were looking for? try our other tools: bulk reverse geocoder / single address coordinate finder / multi-destination routing.

Step #1 Start by putting your data in a compatible delimited format
(tab-delimited is easier for copying from an external source, bar-delimited should be used for hand entry):
 
Step #2 Copy/paste addresses into the table below, or try it out with the example data provided:
(example file will load automatically upon selecting a format, click here to turn off example loading. )
Step #3 Click "Validate Source" to ensure data format is readable and populate column data:
 
 
Step #4
Select appropriate columns from the drop-downs below. Use address/city/state for exact map, or city/state or zip can be used for regional map:
Location Fields   Map Fields (not required)
Map Options (Note: URLs and Image URLs should start with "http://" or they will not work properly.)


 
Step #5 Click "Run Geocoder" and wait for geocoding to finish:
 
 
Step #6
Geocoding results are below, you can copy/paste this back into a spreadsheet or import into a database. Right click on the form below and click "Select All", then right click again and click "Copy." Formatting is maintained but 2 columns containing coordinates are added: bg_lat (latitude), bg_long (longitude):
You're done! Now that you have coordinates for your data, want to see your results on a map? Below is a map of the geocoded results. Click on each point to get the information from that record.
 
More Mapping Options Now that you've geocoded your custom address data,
want to display it on your own web page? or download it into Google Earth?:

What could I use this for?

  • 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.
  • International Geocoding - You can now bulk geocode for most European Countries including the UK, France, Germany, and Italy.
  • 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 and 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
  • Kids - you now have your own personal paper route mapper!
  • If you aren't finding the tools you need here, check out GPSVisualizer.com, they have a number of GPS and Google Earth specific tools
This free service is supported by donations and advertising. If you find this service useful, please feel free to send a donation by clicking the donate button on the right. Your support is appreciated, and will go towards paying maintenance on the server and funding the development of new features.

What is geocoding?

To Geocode, is to take a street address and convert it into latitude and longitude coordinates so that it can be displayed on a map. It can also be used to validate address data, or pull back unknown fields such as zip code. It works by finding the associated block face with an address, example: 123 Sesame St, the block would likely be 100-200 Sesame St. When trying to locate the segment the street number, street name, street direction, street type, and the city/state or zip code are all used. Once the segment is found, the location of the address is estimated along the line by using the street address number and the block range (this is the least accurate part of the process.) Simply put: Geocoding makes locating addresses and viewing multiple locations on a map instantly possible.

What makes this geocoder unique?

Geocoding on the web is not a new concept, in fact there are many free geocoders available on the web, but this is the first free browser based geocoding service to provide coordinate lookup in bulk and map multiple locations. This tool maps many addresses all at once, rather than one at a time. BatchGeocode.com also provides a more accurate geocoding dataset than others, most of which use TIGER data, which is known to be inaccurate up to several hundred feet in some areas. The Yahoo! Geocoding API which this site uses is based on uses a much more powerful commercial street dataset, one well known as an industry standards for transportation data. Your data will also be kept secure, check here for more information on data security and privacy.

How do I host the map on my site?

Just run through the geocoder as normal, and then use the "Save to Map to a Web Page" button. You will have the opportunity to specify a name and description for your map, then you will be sent to the web page where your map is hosted. Just copy the URL and post a link to it on your web site, or send it to a friend, or keep it for yourself. We will not distribute the URL to anyone. To update your data, simply create a new map and update your links. Check our blog for information on creating a static URL for your map.

Data Coverage

Street level geocoding is available in United States, Canada, and the following European Countries: Austria, Belgium, Denmark, England, France, Finland, Germany, United Kingdom (UK), Luxembourg, Netherlands, Ireland, Norway, Portugal, Scotland, Spain, Sweden, Switzerland, Wales, and Italy. Country, State, and City level geocoding is available for Europe, Asia, Central and South America. We expect Yahoo! will continue to expand coverage of their street level data to the rest of the world soon, keep checking back! The name of the coordinate system used is WGS84, this is the decimal degrees version of the coordinate system commonly used in GPS devices.

About the Technology

This tool makes primary use of ON-Demand JavaScript and JSON to dynamically call and interact with the Yahoo! Geocoding API. When bulk geocoding is taking place the end-user browser interacts directly with Yahoo! servers allowing the 5,000 query per day limit to be extended to the end-user IP address. ON-Demand JavaScript + JSON is used instead of the common XMLHttpRequest interface, most commonly associated with AJAX, because it allows for communicating with a different domain other than the one the page is served from. The rest of the tech is a small JavaScript application that parses the user's tabular input and sends it line by line to the Yahoo! geocoding service. BatchGeocode.com's ability to interact across many domains makes it once of the first true Web 2.0 applications that really works!
Copyright © 2009 Phillip Holmstrand - Visit the Batch Geocode Blog