languages

coordinate mapper

coordinate finder

map inside excel

blog

Take your data from Excel Map your data onto a Google Map! Is your data is in a spreadsheet? Well try this free and unique tool to...
  • Map it using Google Maps
  • Share it on the Web
  • Download it into Google Earth
  • Get latitude and longitude coordinates
Step 1: Source Data
Start by using our Excel Data Template for your data (recommended for first time users.)
Copy the data from your spreadsheet, click below and paste OR try it out with the example provided:  
Step 2: Columns & Options
Make sure the proper column is selected for each of the address components.
Step 3: Geocoding
Click "Run Geocoder" and wait for geocoding to finish:
 
Map Results
See your map below. If you find any markers out of place - just drag and drop them to the correct location.
Geocoding Results
Geocoding results are below, you can copy/paste this back into a spreadsheet or import into a database.
If the results are innaccurate, you can try our Yahoo Maps Geocoder.
Save Map to a Web Page / Print

Enter a short title for your map, what is it?

If you select "Unlisted" your map will be saved to a unique URL that will be kept private to you, it will not be listed anywhere on the site. You can read up on map privacy on our blog.

Enter this in case you want to EDIT your map later.
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.

How do I host the map on my site?

Interested in having a google map on your site, but don't want to hassle with the Google Maps API? Just run through workflow above, and then use the "Save / Print / Share" 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 map URL to anyone. To update your data, simply create a new map and update your links. Our blog has more on embedding maps on your site, you can also read about creating a store locator, and editing your map.

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 Google 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.

Map Internationally

Geocode addresses in North America, South America, Europe, Asia, and Oceania. Bulk geocode for most Countries including the UK, France, Germany, Australia, Denmark, Belgium, Switzerland, Portugal, New Zealand, Singapore, Russia, Philippines, Malaysia, Ireland, Brazil, China, Sweden, Spain, Netherlands, Mexico, Japan, and Italy.

What could I use this for?

  • Create a map - Copy directly from spreadsheet program such as Excel or the free Google Docs or OpenOffice Calc.
  • Multiple Destination Driving Directions - Locations 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.
  • Get postal codes / zip codes - Retrieve postal or zip codes for a given address internationally.
  • Print a map - Make a printable map with your addresses on it.
  • Save a map - Create a map with your locations and associated data to a web page for later use.
  • Create a store locator - Map your store properties, and then link to them from your website.
  • 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.
  • 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!

Accuracy Codes

These indicate how accurate your geocode was. If you are finding a large number of your geocodes end up as APPROXIMATE, check the formatting and completness of your addresses.
  • ROOFTOP (most accurate) - indicates that the returned result reflects a precise geocode.
  • RANGE_INTERPOLATED - indicates that the returned result reflects an approximation (usually on a road) interpolated between two precise points (such as intersections). Interpolated results are generally returned when rooftop geocodes are unavailable for a street address.
  • GEOMETRIC_CENTER - indicates that the returned result is the geometric center of a result such as a polyline (for example, a street) or polygon (region).
  • APPROXIMATE (least accurate) - indicates that the returned result is approximate, usually the center of the zip code.