This tutorial shows you how to enter data in an on-line spreadsheet to generate a set of placemarks in Google Earth. Google's web-based, collaborative editing allows you and 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. Some of the new
and improved features in Spreadsheet Mapper version 3 include: Spreadsheet Mapper 3 uses Google Apps Scripts to help generate the KML placemarks, and to provide useful tools. Before you begin Let's get started... Open the starter
spreadsheet Enter basic information and publish your spreadsheet View the sample placemarks & templates in Google Earth Enter your own information Prepare your template Enter placemark names and locations Apply a template to each placemark Optional: Setting Time, LookAt views and Snippets Publish and view your changes Need more or less rows? Add more rows... Remove some rows... Messed up your rows or formulas? Sharing your placemarks Sharing your map as a layer in Google Earth Discussion, Feedback & Questions What's Next More tutorials... Spreadsheet Mapper is a powerful tool for mapping point locations. It starts with enough spreadsheet rows for 1,000
placemark points, and provides a tool for adding additional rows. Adding more than a few thousand rows/points will slow down the spreadsheet mapper, and produce a very large KML file. To begin, open a copy of the starter spreadsheet using the link below, which will create a new spreadsheet in your Google Docs account. You may
need to log into your Google Account to proceed. When asked if you want to make a new copy of the document, click “Yes, make a copy.” Spreadsheet Mapper v3 - get a new copy 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... Check that the Spreadsheet Mapper menu has appeared at the top (next to the 'Help' menu). If you don't see the Spreadsheet Mapper menu, try refreshing the web page. After the spreadsheet re-loads, wait a few seconds and the menu should appear. Enter basic information and publish your spreadsheet
View the sample placemarks & templates in Google Earth
Enter your own informationPrepare your template (adsbygoogle = window.adsbygoogle || []).push({});
Enter placemark names and locations
Apply a template to each placemark
Optional: Setting Time, LookAt views and Snippets
Publish and view your changesEach time you make a change to the information in your spreadsheet, by editing the placemark data, the start here sheet, or one of your balloon templates, you must re-publish your changes in order to see them in your KML on Google Earth or Maps.
Need more or less rows?Add more rows...If you want to create more than 1000 placemarks, you can easily add more rows to Spreadsheet Mapper.
Remove some rows...If you added more rows than you needed, or you simply want to optimize your spreadsheet and KML by removing unused rows, we've provided a tool for that too.
Messed up your rows or formulas?There are a number of ways that the rows and formulas in your spreadsheet might get messed up and stop working correctly. Some common mistakes include:
If you have done any of these things, or are seeing unusual errors in your KML, then it is possible that the number of placemark generation rows in your KML sheet no longer corresponds to the number of data rows in your PlacemarkData sheet, or that one or more formulas in those sheets were corrupted. If so, we provide a script that will attempt to repair such errors:
Sharing your placemarksAnyone can view the placemarks generated by your spreadsheet in Google Earth. You can help make it easy for them with the techniques below. Sharing your map as a layer in Google EarthThere are two ways to share your placemark map with Google Earth users. One is to use a link directly to the spreadsheet, so that Google Earth can always get the latest updated data/KML from your spreadsheet. This is useful for datasets that you update frequently, and for users who will always have an internet connection. The other method is to make a static snapshot of your data, and share that as a KML file with all the placemark data inside it. This is useful for datasets that don't change as much, or for users who want to view the KML when they are working offline. Sharing a static version of our KML is also useful if you want to continue editing your Spreadsheet Mapper, without your users seeing the edits... until you create a new static snapshot. To share access to an automatically updating KML linked directly from the spreadsheet:
To share a static snapshot of your current KML, which contains all the data but will not get updates from the spreadsheet:
Discussion, Feedback & QuestionsDo you have questions about this tutorial or about Spreadsheet Mapper? Do you want to give us feedback or discuss with other users and experts? Visit the “Nonprofit Outreach / Education” section on the Google Earth discussion forum to find answers, ask questions, and discuss with others: Google Earth Forum - Nonprofit Outreach / Education What's NextMore tutorials...See all the tutorials and tools available from Earth Outreach. Bagaimana cara membuat drop down list di Google sheet?Membuat menu drop-down. Buka spreadsheet di Google Spreadsheet.. Pilih sel atau beberapa sel tempat Anda ingin membuat menu drop-down.. Klik Data. ... . Di samping "Kriteria", pilih opsi: ... . Sel akan memiliki tanda Panah bawah.. Langkah menggunakan Google Spreadsheet?Cara Membuat Spreadsheet Baru di Google Drive
Untuk membuat Google Spreadsheet baru bisa melalui Google Drive dengan membuka link: drive.google.com . Di sisi kiri pada tampilan layar browser, klik 'New'. Secara otomatis, kamu akan diarahkan ke laman online docs.google.com/spreadsheets untuk membuat spreadsheet baru.
Bagaimana cara mengedit Spreadsheet?Mengedit data dalam sel. Buka spreadsheet di aplikasi Google Spreadsheet.. Di spreadsheet, ketuk dua kali sel yang ingin diedit.. Masukkan data Anda.. Opsional: Untuk memformat teks, sentuh lama teks, lalu pilih salah satu opsi.. Setelah selesai, ketuk Selesai .. Langkah yang benar untuk membuat template dalam Google Docs?Membuat template Anda sendiri. Pilih salah satu opsi: ... . Dari layar utama Dokumen, Spreadsheet, Slide, atau Formulir, di bagian atas, klik Galeri template. ... . Klik Kirim template. ... . Klik Pilih dokumen, lalu pilih file template yang telah dibuat.. Klik Buka.. (Opsional) Untuk mengirimkan salinan file, bukan yang asli, centang kotak.. |