using spreadsheet data in google maps and google earth

Step 18

Return to the spreadsheet and scroll down to the Create Placemarks section.

To use Template #3, the first step is to customize the information that will be the same on all the pop-ups that use location template #3 Click the worksheet named Template3 at the bottom of the spreadsheet.

Step 19

This displays the Template #3 static information input page. This is where you change the static information that will appear in all of your location balloons.

Note the reminder to only modify white cells. 

Step 20

This shows several elements that have been manually changed.

The icon color and highlight color are changed (1). The label color and label highlight color are changed (2). The organization information and link information are changed (3). The link for the logo URL and the size of the logo are changed. 

Step  21

Switch to the PlaceMark Data worksheet. 

Step 22

Note this is where the folder name category is set (1) and the placemark name (2). For example, if you wanted to organize listings on your published map into "coffee shops" and "restaurants" categories, you would set the folder name for each coffee shop to "coffee shops" and the folder name for each restaurant to "restaurants." Note: it is important that you group all of the "coffee shops" and "restaurants" individual entries sequentially for them to appear grouped in the same folder. All of the coffee shops must be grouped. All the the restaurants must be grouped.

In the image below, the latitude and longitude for the template locations are set, but there is no address entry (3). Google Maps require latitude and longitude information to work. Google Earth can use either latitude and longitude information or raw address information to place location markers.

Step 23

This step explains how to use the spreadsheet to select a balloon template style and enter the information that will appear in your final published map.

The first step is to enter number of the location balloon template that you want to use to display the individual location information. Enter the temple you want to use in the Template cell (1).

After you enter the template number and hit the Enter key the header row (2) changes and now displays the information you need to enter.

You can mix pop-up styles on a map.

The information for each location row must match the heading row for the template number. For example, to use the template 6 pop-up for the location in the last row below, change the template number (1) to 6 and enter 6 in the template number identifier column for the last row (3). The header row information (2) will change to match the information in the template 6 header row (4). You would enter the individual location information for template six base on the new information displayed in the header row.

Step 24

Select all the existing demonstration information and Delete>Clear section.