Spreadsheet Mapper v3.0 - citizenrelay
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEG
1
Spreadsheet Mapper v3.0Created by Google Earth Outreach
2
ver. 3.0Can't connect >>unable to check for latest version - try again later
3
News: unable to check messages - try again later
4
5
Quick Instructions
6
7
1Check that the Spreadsheet Mapper menu appears above. If not, refresh this page and wait a few seconds for the script to run.
8
2Rename this spreadsheet with an appropriate name (File menu > Rename).
9
3Complete the "Basic Information" section below.
10
4Follow the steps in the "Publish and View" section to publish your spreadsheet to the web.
11
5Use the links in the "Publish and View" section to view the sample data in Google Earth.
12
6In Google Earth, choose the balloon template(s) you like. In the related template sheet(s), replace the sample template data with your own.
13
7Create your own placemarks on the "PlacemarkData" sheet (erase the sample data first).
14
8View the changes: "Republish" the spreadsheet and refresh the network link in Google Earth.
15
16
Rules:ONLY edit white cells!
17
When editing, deleting, cutting, copy or pasting cells, make sure that you ONLY make changes in the white cells.
18
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.
19
20
Detailed Instructions:
21
Click this link to see the Tutorial for this spreadsheet.
22
23
Basic Information
24
25
Author's Information:This information is embedded into your KML file and helps search engines better index your KML layer.
26
Name/OrganizationMartin HawkseyYour organization name or the author's name
27
Website URL:http://mashe.hawksey.infoURL/Link to your organization's website.
28
29
30
About your KML Document:
31
Name:CitizenRelayName of the top-level folder for this KML (short & sweet).
32
Snippet: (optional)Short blurb under project name in 'My Places' (optional). Plain Text only.
33
Description:CitizenRelay Audioboo
Created with Spreadsheet Mapper v3.0
Short description of your project (recommended). HTML OK.
34
Visible by default?Yes(Yes / No): Should all placemarks be on/visible when loaded?
35
Open by default?Yes(Yes / No): Should top-level folder be open/expanded when loaded?
36
37
38
Advanced / Optional Settings:
39
40
Document ID (optional)Assign an id value to your KML <Document> tag if you want to link to it via advanced Fly-to-Feature hyperlinks using balloonFlyTo; etc.
41
Document ID:spreadsheet_to_kml_3Letters, numbers and underscores only (no spaces).
42
43
44
Custom "LookAt" view: (optional)Set a custom view for this KML project. This overrides the default view showing all placemakrs when the file is loaded in Google Earth.
45
Longitude:
46
Latitude:
47
Range:
48
Tilt:
49
Heading:
50
51
52
Custom KML: (optional)Normally left blank. Use to insert custom KML code, either before (top) or after (bottom) the placemarks from this spreadsheet.
53
Custom KML, top:(Warning: no error-checking on this line. You must enter valid KML)
54
Custom KML, bottom:(Warning: no error-checking on this line. You must enter valid KML)
55
56
57
Network Link Details Override:Override copying the KML Document details by setting custom details for the automatically generated Network Link.
58
Name (optional):Name of the Network Link file (short & sweet). Text only.
59
Snippet (optional):Sub-title for the Network Link file; appears under name. Text only.
60
Description (optional):Info-balloon content for the Network Link file. HTML Ok.
61
Include Spreadsheet Link:No(Yes / No): Include link to spreadsheet in Network Link description?
62
Visible by default?Yes(Yes / No): Should all placemarks be on/visible when loaded?
63
Open by default?Yes(Yes / No): Should top-level folder be open/expanded when loaded?
64
65
<< To access advanced/optional settings, unhide rows 39 - 64.
66
67
68
Publish and View
69
70
Publish spreadsheet:
71
1From the menu bar, select: File > Publish to the Web...
72
2In the dialog box, click the "Start Publishing" button (or "Republish now").
73
Note:The Links below will not work if you have not published your spreadsheet!
74
75
View Placemarks in Google Earth:
76
4Copy this
Network Link KML:
#NAME?single click to select the cell, then copy (don't double click to edit the cell's formula)
77
5In 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 "CitizenRelay".
78
79
80
View Placemarks in Google Maps:
81
6Link to Google MapsClick this link to view in Google MapsDisplays 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.
82
83
Download the KML
84
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.
85
1Download this file:Click this link to download your current data KML
86
2Rename the downloaded file to change the file's extension from ".tsv" to ".kml"
87
88
89
90
Create Your Own Placemarks & Templates
91
1Choose 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.
92
2Go to the "PlacemarkData" sheet. Give each placemark a name, location, and specify the sheet name of the template it should use.
93
3Enter 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.
94
95
96
97
Re-publish & Refresh to view changes
98
After you edit your data or change the spreadsheet, follow the steps below to view the changes in Google Earth:
99
1Make sure your KML is finished generating, and doesn't have Errors or Warnings, by looking at the top of your PlacemarkData sheet.
100
2From the menu bar, select: File > Publish as a web page, and click the "Republish Now" button to re-publish the new KML.
- If you have checked "Automatically republish when changes are made", then it should republish on its own, but may take a minute longer.
Loading...
 
 
 
start here
PlacemarkData
Template1
Template2
Template3
Template4
Template5
Template6
kml