Multimedia and Technology Training At the UC Berkeley Graduate School of Journalism
In a new Google Spreadsheet go to File>Import.

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

The information is displayed in a new spreadsheet.
Copy the cells with the latitude and longitude information.
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.

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

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

Comments? Contact us | ©2007-2009 The Regents of the University of California.
Add your comment
Login to post a comment.