using spreadsheet data in google maps and google earth

Use Google Earth

Step 11

Launch Google Earth.

Control+click My Places (1) in the navigation side bar. Select Paste (2) from the contextual menu. This pastes the code from your Google Spreadsheet to the Google Earth application.

 myplaces

Step 12

The link is processed and the location information is displayed.

Note the network icon (1) and the folders with category names (2). Each folder contains two versions of a pop-template.

places

Step 13

Google Earth displays the locations defined in the template.

Click the reveal triangle to display the two locations that use the Text & Photo Banner (#3) template for the pop-up.

map

Step 14

Examine the Sample (#3) location.

This is a complete display of what this location pop-up template looks like with content. 

sample location

Step 15

Examine the Template (#3) location.

This is the #3 template with placeholder information. You will setup this template to display your own information.

template