using spreadsheet data in google maps and google earth
Use Google Earth
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.
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.
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.
Examine the Sample (#3) location.
This is a complete display of what this location pop-up template looks like with content.
Examine the Template (#3) location.
This is the #3 template with placeholder information. You will setup this template to display your own information.