Map your Excel location data with BatchGeo
Many people and organizations use Excel documents to store location data in the form of addresses, zip codes, cities, and states. BatchGeo lets you easily take your excel spreadsheet data and create a map from it. Follow the steps below to get started.
- Open your excel spreadsheet.
- Select all the rows by hitting CTRL+A, then copy the rows by hitting CTRL+C.
- Open your web browser and go to batchgeo.com
- Click on the location data box with the example data in it, then paste your own data by hitting CTRL+V.
- Check to make sure you have the proper location data columns available by clicking "Validate and Set Options", proceed to Step #2.
- Under Step #2, select the proper location column from each drop down (you only need one location field to map, but the more better.)
- Go to Step #3, click "Make Google Map"
- Wait for geocoding to process, then you're done!
After your map is complete you can save it using the "Continue & Save" option, paste the URL to the resulting page in your spreadsheet so you have quick access to it in the future. From there you can also view in Google Earth by choosing "Export To KML" from the button at the bottom of the screen (scroll down.)