|Spreadsheet Mapper v3.1||Created by Google Earth Outreach|
|ver. 3.1||Can't connect >>||unable to check for latest version - try again later|
|News:||unable to check messages - try again later|
|1||Check that the Spreadsheet Mapper menu appears above. If not, refresh this page and wait a few seconds for the script to run.|
|2||Rename this spreadsheet with an appropriate name (File menu > Rename).|
|3||Complete the "Basic Information" section below.|
|4||Follow the steps in the "Publish and View" section to publish your spreadsheet to the web.|
|5||Use the links in the "Publish and View" section to view the sample data in Google Earth.|
|6||In Google Earth, choose the balloon template(s) you like. In the related template sheet(s), replace the sample template data with your own.|
|7||Create your own placemarks on the "PlacemarkData" sheet (erase the sample data first).|
|8||View the changes: "Republish" the spreadsheet and refresh the network link in Google Earth.|
|Rules:||ONLY edit white cells!|
|When editing, deleting, cutting, copy or pasting cells, make sure that you ONLY make changes in the white cells.|
|To add or remove rows, use the add or remove tools in the Spreadsheet Mapper menu. Do not add or delete rows manually. |
To move data or rows, use copy/paste. Do not drag data or rows to move them.
If rows or formulas stop working correctly, use the repair tool in the Spreadsheet Mapper menu.
|Detailed Instructions & Resources:|
|Click this link to see the Tutorial for this spreadsheet.|
|Author's Information:||This information is embedded into your KML file and helps search engines better index your KML layer.|
|Name/Organization||Ogle Earth||Your organization name or the author's name|
|Website URL:||http://www.ogleearth.com/||URL/Link to your organization's website.|
|About your KML Document:|
|Name:||MH370 - candidate landing spots||Name of the top-level folder for this KML (short & sweet).|
|Snippet: (optional)||Known airports, large and small.||Short blurb under project name in 'My Places' (optional). Plain Text only.|
|Description:||Created with Spreadsheet Mapper v3.1||Short description of your project (recommended). HTML OK.|
|Visible by default?||Yes||(Yes / No): Should all placemarks be on/visible when loaded?|
|Open by default?||Yes||(Yes / No): Should top-level folder be open/expanded when loaded?|
|Advanced / Optional Settings:|
|<< To access advanced/optional settings, unhide rows 39 - 64.|
|Publish and View|
|1||From the menu bar, select: File > Publish to the Web...|
|In the dialog box, Un-check the box for "Automatically republish when changes are made".|
Click the "Start Publishing" button (or "Republish now").
|Note:||The Links below will not work if you have not published your spreadsheet!|
|View Placemarks in Google Earth:|
Network Link KML:
|Loading...||single click to select the cell, then copy (don't double click to edit the cell's formula)|
|5||In Google Earth, Select "My Places" in the "Places" panel and paste the Network Link KML (above).|
The Sample placemarks (or your data) will load from this spreadsheet under the folder "MH370 - candidate landing spots".
|View Placemarks in Google Maps:|
|6||Link to Google Maps||Click this link to view in Google Maps||Displays the your placemarks in Google Maps. In case of error, try reloading the link - connection to the spreadsheet is sometimes too slow, and Google Maps may timeout.|
|Download the KML|
|The Network Link KML above provides a small file that does not contain your data, but rather links to the data KML published by this spreadsheet.|
To get a KML file that contains your actual data, follow the steps below. Note that this file will not auto-update like the Network Link.
|1||Download this file:||Click this link to download your current data KML|
|2||Rename the downloaded file to change the file's extension from ".tsv" to ".kml"|
|Create Your Own Placemarks & Templates|
|1||Choose which template(s) you want to use, go to their sheet(s), and enter your own information under the "static" variable section. Optionally, edit the "style" variable section. You can create your own templates by duplicating one of the template sheets, giving it a new name, and customizing it.|
|2||Go to the "PlacemarkData" sheet. Give each placemark a name, location, and specify the sheet name of the template it should use.|
|3||Enter each piece of balloon information in the appropriate columns, according to which template that placemark is using.|
HINT: Enter any template sheet name into cell A1 on the "PlacemarkData" sheet to get a column header guide for that template.
|Re-publish & Refresh to view changes|
|After you edit your data or change the spreadsheet, follow the steps below to view the changes in Google Earth:|
|1||Make sure your KML is finished generating, and doesn't have Errors or Warnings, by looking at the top of your PlacemarkData sheet.|
|2||From the menu bar, select: File > Publish as a web page, and click the "Republish Now" button to re-publish the new KML. |
- DO NOT check the box to "Automatically republish when changes are made", as it may cause errors.
|3||In Google Earth, right-click on the Network Link and choose "Refresh".|
- A fresh copy of the KML with your changes will be fetched.
- A second refresh is sometimes required to see all changes.
|Save/export your placemark data (optional):|
|If you want to save a backup of the data in your spreadsheet, or export it to another spreadsheet mapper, use the links below.|
|View/Save placemark data||Click this link to view your placemark data||This link will launch in a new browser window. After it loads, choose File > Save in your web browser, and save the file to you computer. Your spreadsheet must be published to the web.|
|Export this data to another spreadsheet||Loading...|
|1. Select the cell above, and copy the "importData()" formula. |
2. On the new spreadsheet, go to the PlacemarkData sheet, double-click the first data cell (C11) to edit, and paste in the formula.
3. Placemark data from this spreadsheet will be imported (Note: templates you created/modified here are not copied! Copy those separately).
4. Once complete, select all the white cells that were populated with your placemark data (C11:AY...), and copy them.
5. Click the "Edit" menu, then "Paste Special", then "Paste values only".
|Debugging your KML (optional):|
|KML Debugging Link:||Click this link to view KML||Displays the raw KML created by this spreadsheet.|
|hidden column for developers only (unhide at top) >>||<<|