Designate a template for each placemark by entering the desired Template Sheet Name into column H. This will sort all the data below the “freeze sheet” divider bar, and group your placemarks into folders.Įach placemark needs a template, to determine its icon, info-balloon layout, and other styles. One way to do this is to use the dropdown menu in the “ Folder Name” column header, and select “ Sort Sheet”. All the placemarks in the same folder must be grouped together, otherwise duplicate folders with the same name will be created. Optional: Put your placemarks into folders by specifying a “ Folder name”. Spreadsheet Mapper can also accept addresses instead of location coordinates, but it is not recommended, since a KML with addresses requires Google Earth to look up and geocode each address, every time a user opens the file. Then look at the pop up at the bottom center of the page, where the latitude and longitude will be listed. Simply go to, right-click on the desired location on the map and select “ What's here?” from the menu. Tip: Don't know the latitude or longitude coordinates of your location? You can get a location's latitude and longitude from Google Maps. Location coordinates must be in decimal degree format (e.g. A template sheet name is also required, but we'll get to that below. Start creating placemarks by entering your own data! A name and location are required for each placemark. Go to the PlacemarkData sheet, and delete the sample data in the white cells. Optional: To change the look of the placemark icons and labels, modify the values of the “ KML Style Variables” as desired. Scroll down to the “ Static Variables” section of the template and replace the values with your information, where applicable. Optional: Give the sheet a new name (eg: “Tem_OurSites”). Go to the sheet for the template(s) you've chosen. You will also be able to customize the HTML based balloon templates, or create your own. 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.
#BEST SHEET DOC MERGE FOR GOOGLE HOW TO#
This tutorial shows you how to enter data in an on-line spreadsheet to generate a set of placemarks in Google Earth.
0 kommentar(er)
