Spreadsheet Mapper 2.0

We've improved our Spreadsheet Mapper tool! Some of the new features include:

• Six ready-made balloon designs to quickly create up to 400 attractive placemarks
  
• A simple HTML templating system to create your own balloon designs.
• Works in Google Earth and Maps.
  

This tutorial shows you how to enter data in an on-line spreadsheet to generate a set of placemarks in Google Earth and Maps. Google Docs' web-based, collaborative editing allows your team members to simultaneously enter data and instantly publish updates.

Using this tool you could: showcase your organization's projects, program sites or partners; map your offices, volunteers, or resources; or visualize your data on local, regional or global scales.

See Edge of Existence Mammal and Amphibian layers that were created using this tool!

Video Demo (5 minutes)

Getting Started

Open the starter spreadsheet

1. To begin, open the starter spreadsheet. You may need to log into your Google Account to proceed.
   
   
2. Once loaded, give it an appropriate name: click the File button above and choose Rename.

Enter Basic Information

1. On the start here sheet, complete "Author's Information" and "About your KML Document" sections of the Basic Information form.
   
   
2. Enable "Google Maps Compatibility" if you want your layer to work in Google Maps and older versions of Google Earth (pre-4.2).
   
   
3. Optional: Access the "Advanced/Optional Settings" by clicking the tab indicated on the left to un-hide rows.

Publish your spreadsheet

1. Click Publish tab and choose Publish Now.
   
   
2. Copy the published URL (blue highlighted text below) and paste it into the white cell provided under "Publish spreadsheet".
   
   

View templates in Google Earth

1. Copy the "Network Link KML" cell, switch to Google Earth, select My Places, then right-click and Paste.
   
   
   
   
2. Sample placemarks for the six available templates will be displayed in Google Earth.
   
   
3. Click on the sample placemarks and decide on which balloon templates you'd like to use for your project.
   
   
   
   
4. You can also customize the six HTML based balloon templates, or create your own. See the Creating 'Spreadsheet Mapper' Templates tutorial to learn how.

View templates in Google Maps

1. "Backwards Compatibility" mode must be enabled to view your layer in Google Maps and Earth 3.0-4.1.
   
2. Control-click the link on the start here sheet to view the sample placemarks in Google Maps.
   
   
   View sample map

Enter your information

Prepare your template

1. Go to the sheet for each template you've chosen and replace the values of the "Static Variables" with your information.
   
   
   
   
   
2. Optional: To change the look of the placemark icons and labels, modify the "KML Style Variables" as desired
   
   
   

Enter placemark names and locations

1. Go to the PlacemarkData sheet, delete the sample data, and start creating your own placemarks.
   
   
2. A name and location are required for each placemark. Coordinates must be in decimal degree format (e.g., -122.34567).
   
   Tip: Don't know the latitude or longitude of your location? Click this link to add a mapplet to your Google Maps MyMaps tab which helps you find coordinates. You can also use free services like the geocoder.us or the Batch Geocoder.
   
   
   
   
3. Optional: Put your placemarks into folders by specifying a "Folder name". All the placemarks in the same folder must be grouped together, otherwise duplicate folders with the same name will be created. Use the sort bar on the "Folder Name" column to keep placemarks in the right order.
   
   
   

Apply a template to each placemark

1. Enter the desired template number for each placemark into column H. Available templates are listed in the table at the top of the sheet.
   
   
2. Each template uses the spreadsheet's columns for different pieces of balloon content (e.g., Template #1, column I = "Left Column Header"; Template #2, column I = "Title"). Make sure you enter each placemark's data according to the appropriate column headers as show in the template list.
   
   
3. To make data entry easier, highlight a specific template by entering its number in cell H10 (see steps a, b, c below). That template's column headers will be highlighted in the template list, and will also appear in row 10, right above the gray header bar.
   
   
   
   
   

Optional: Setting Time, LookAt views and Snippets

1. You can enter advanced placemark information including views (LookAt), time stamps (see valid formats), and Snippets.
   
   
2. Click the indicated tab in the upper right of the sheet to un-hide the extra columns, and enter values for your placemarks.
   
   

Publish your changes

1. Go to the Publish tab on your spreadsheet and click the Re-publish.
   
   
2. For Google Earth: In the Places panel, right-click on the Network Link (named "Link to - Spreadsheet") you added earlier, and select Refresh to load your changes.
   
   Note: A second refresh may be required to see changes made on the template sheets.
   
   
   
   
   
3. For Google Maps: control-click the Google Maps link on the start here page.

Sharing your placemarks

Anyone can view the placemarks generated by your spreadsheet in Google Earth and Maps.

Sharing your layer in Google Earth

1. In Google Earth's Places panel, right-click on your Network Link (named "Link to - Spreadsheet") and choose Save As...
   
2. Give the file a descriptive name and save it to your computer. The resulting KML/KMZ file will always retrieve the latest data from your spreadsheet.
   
3. Email the KML/KMZ file you saved above to your colleagues and friends, or post the file on your website.
   

Sharing your layer in Google Maps

1. Control-click the Google Maps link on the start here sheet. "Backwards compatibility" must be enabled.
   
2. Use the Send or Link to this page options on the upper right of the Google Maps page to send to others.
   
3. Embed your layer onto a website by clicking Link to this page and then copying the HTML in the "Paste HTML to embed in website" section.
   

Promoting your KML

Also see the Tutorial: Promoting Your KML for more tips on sharing your layer with the world.

 

Discussion / Feedback

Have questions about this tutorial? Want to give us some feedback? Visit the Google Earth Outreach Discussion Group to discuss it with others.

What's Next?

Want to make your own HTML balloon designs? Check out this tutorial which shows you how!

• Creating 'Spreadsheet Mapper' Templates

Note: This tutorial replaces the following tutorials: Adding Time as a Fourth Dimension and Creating KML From a Spreadsheet.