Spreadsheet Mapper v3.0 - #iwmw12
 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
1
8
2
9
3
10
4
11
5
12
6
13
7
14
8
15
16
Rules:
17
18
19
20
Detailed Instructions:
21
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
Martin HawkseyYour organization name or the author's name
27
http://mashe.hawksey.infoURL/Link to your organization's website.
28
29
30
About your KML Document:
31
Name:#IWMW12 TweetsName 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:Geo located tweets from IWMW12
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:
#ERROR!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 "#IWMW12 Tweets".
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
data
Template1
Template2
Template3
Template4
Template5
Template6
kml