![Page 1: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/1.jpg)
Geocoding an Excel file of addresses using Google MapsWritten by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14This example uses Cambridge grocery
stores from Reference USA
Do not use this method for data that needs to be protected for privacy!!
![Page 2: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/2.jpg)
To use Google Maps and convert to ArcMap shape file, you will need… A google account Google Earth installed on your computer
(download from earth.google.com) An Excel or .csv file of addresses (with
column headings) Excel file limit in Google maps is a maximum
of 100 records and 15 columns
![Page 3: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/3.jpg)
We want to geocode this Excel file using the address information
![Page 4: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/4.jpg)
Google Map free geocoding limits: 100 records, max 15 columns…
![Page 5: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/5.jpg)
If you have a gmail or google account and are using the old google maps…
![Page 6: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/6.jpg)
If you are using the new Google Maps:
![Page 7: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/7.jpg)
If you are using the new Google Maps:
![Page 8: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/8.jpg)
![Page 9: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/9.jpg)
![Page 10: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/10.jpg)
![Page 11: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/11.jpg)
![Page 12: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/12.jpg)
![Page 13: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/13.jpg)
![Page 14: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/14.jpg)
![Page 15: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/15.jpg)
Export to KML…
![Page 16: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/16.jpg)
Download the file and move it to your work folder…
![Page 17: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/17.jpg)
Now in ArcMap, go to Toolboxes…
![Page 18: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/18.jpg)
Complete the import process…
![Page 19: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/19.jpg)
The result is a geodatabase and a new .lyr file – you can change symbology of the placemarks and labels
![Page 20: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/20.jpg)
To export this layer file to a shape file if you prefer this to a geodatabase…
![Page 21: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/21.jpg)
Export this layer file to a shape file…
![Page 22: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/22.jpg)
Comparing the results with Reference USA latitude/longitude coordinates…
![Page 23: Geocoding an Excel file of addresses using Google Maps Written by Barbara Parmenter, Tufts Geospatial Services, updated 10/13/14 This example uses Cambridge](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f315503460f94c4c7ec/html5/thumbnails/23.jpg)
Comparing the results with Reference USA latitude/longitude coordinates…