using spreadsheet data in google maps and google earth

By Jerry Monti   ·   Updated Apr 13, 2011   ·   Print Print

Use the Latitude and Longitude

Step 39

In a new Google Spreadsheet go to File>Import.

 import

Step 40

Import the .csv file and click "open now."

 import

Step 41

The information is displayed in a new spreadsheet.

new spreadsheet

Step 42

Copy the cells with the latitude and longitude information.paste

Step 43

Switch to the Placemark Data worksheet and paste in the latitude and longitude information. Make sure you have selected the top left cell in the latitude column before you paste in the copied information.

 latlong

Step 44

Go to the Start here worksheet, scroll to row 81, control+click the link to view the map in Google Maps.

starthere worksheet

Step 45

Google Maps now has all the information to display the location points. Congratulations! 

final

Filed under: Maps