These placemarks show the starter balloon templates built into the spreadsheet.Ĭlick on the sample placemarks and decide which balloon templates you would like to use for your project. The sample placemarks will be displayed in Google Earth. Switch to Google Earth, select the My Places or Temporary Places folder in the left-hand panel, then Paste using Ctrl-V or Right-Click > Paste. Note that even though the network link will always appear, it will not work until your spreadsheet is published to the web. Copy the contents with Ctrl-C or Right-Click > Copy. Select the “ Network Link KML” cell by single clicking the cell (do not double-click to edit). In the dialog box, expand the "Publish content & settings" section and un-check the Automatically republish when changes are made box.Ĭlick the Publish button, and then click Close to dismiss the dialog. Optional: Access the “ Advanced/Optional Settings” by clicking the tab indicated on the left to un-hide rows.įrom the menu bar, select File > Publish to the Web. On the start here sheet, complete “ Author's Information” and “ About your KML Document” in the Basic Information section. After the spreadsheet re-loads, wait a few seconds and the menu should appear. If you don't see the Spreadsheet Mapper menu, try refreshing the web page. Once opened in your account, give the new spreadsheet an appropriate name by clicking on the title, or from the menu bar, select File > Rename.Ĭheck that the Spreadsheet Mapper menu has appeared at the top (next to the 'Help' menu). When asked if you want to make a new copy of the document, click “Yes, make a copy.” You may need to log into your Google Account to proceed. To begin, open a copy of the starter spreadsheet using the link below, which will create a new spreadsheet in your Google Docs account. Sharing your map as a layer in Google Earth Optional: Setting Time, LookAt views and Snippets View the sample placemarks & templates in Google Earth Tutorial ContentsĮnter basic information and publish your spreadsheet Spreadsheet Mapper 3 uses Google Apps Scripts to help generate the KML placemarks, and to provide useful tools. Six simplified balloon design templates - add more if needed.Create 1000 placemarks - add more if needed.Some of the new and improved features in Spreadsheet Mapper version 3 include: 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. Google's web-based, collaborative editing allows you and your team members to simultaneously enter data and instantly publish updates. This tutorial shows you how to enter data in an on-line spreadsheet to generate a set of placemarks in Google Earth.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |