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. Show
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. Tutorial ContentsBefore you beginSpreadsheet 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. 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 informationPrepare your template
Enter placemark names and locations (adsbygoogle = window.adsbygoogle || []).push({});
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: Apakah Google Spreadsheet save otomatis?File Spreadsheet / Google Sheet akan tersimpan secara otomatis di Google Drive, jadi anda tidak perlu menyimpan file secara manual. Setiap perubahan yang dilakukan di Spreadsheet / Google Sheet akan tersimpan secara otomatis di Google Drive, Namun anda juga bisa menyimpa file dengan format Excel jika dibutuhkan.
Bagaimana Melindungi 1 sheets agar tidak bisa diedit di Google Sheets?Melindungi sheet atau rentang. Buka spreadsheet di Google Spreadsheet.. Klik Data. ... . Klik Tambahkan sheet atau rentang atau klik perlindungan yang ada untuk mengeditnya.. Untuk melindungi rentang, klik Rentang. ... . Klik Setel izin atau Ubah izin.. Pilih cara yang diinginkan untuk membatasi pengeditan: ... . Klik Simpan atau Selesai.. Bagaimana cara menggunakan Google Spreadsheet?Berikut adalah cara membuat spreadsheet di Google Sheets dengan mudah:. Buka Google Sheets melalui alamat sheets.google.com. ... . Klik tombol '+' bertuliskan Blank yang ada di bagian atas kiri. ... . 3. Edit dan format spreadsheet. ... . 4. Simpan ke komputer, print atau bagikan.. Fungsi apa yang dapat digunakan di Google Sheet untuk mengambil data set dari file Google sheet yang berbeda?Jika Anda menyimpan data di Google Spreadsheet yang terpisah, salin rentang data dari satu spreadsheet ke spreadsheet lainnya menggunakan fungsi IMPORTRANGE.
|