How to Create a Google Earth Map From a Google Spreadsheet

Create a Google Earth Map from location data stored in a Google spreadsheet using Google Fusion Tables. Google Fusion Tables is a sophisticated data management application used to visualize large data sets. Using Google Fusion Tables, you can create a detailed Google Earth Map with no javascript coding. Instead, import your Google Spreadsheet into a Google Fusion table, then click a few buttons to generate a Google Earth Map.

Instructions

1

Navigate to Google Fusion Tables at google.com/fusiontables and log in to your Google Account.

2

Click the "New Table" drop-down list on the top-right of the screen, then select "Import Table."

3

Click the "Google Spreadsheets" icon on the window's left column.

4

Click on "Spreadsheets" in the Select a Spreadsheet window. Google displays all Google Spreadsheets in your account.

5

Select the Google Spreadsheet containing location data and click the "Select" button. Google opens the New Fusion Table window.

6

Name your table in the Table Name field.

7

Cite the owner of the data in the Attribution field.

8

Enter the URL that points to where the data originated in the URL field.

9

Describe the type of data and the purpose of your map in the Description field and press the "Finish" button. Google uploads your Google Spreadsheet data into a new Google Fusion Table.

10

Click the "Visualize" button on the top of the screen, then select "Map" from the drop-down list. Google maps all the locations on a standard Google Map.

11

Click the "Satellite" button on the right side of the Google Map to display the data on a Google Earth map.