ABCDEG
1
Spreadsheet Mapper v2.0Created by Google Earth Outreach
2
3
4
ver. 2.0Can't connect >>unable to check for latest version - try again later
5
6
News: unable to check messages - try again later
7
8
Quick Instructions
9
10
1.Click the "File" button, choose "Rename" to give this spreadsheet an appropriate name.
11
2.Complete the "Basic Information" form below.
12
3.Follow the steps in the "Publish and View" section below.
13
4.Choose which balloon template(s) you like, or create your own on the "Template 1-6" sheets.
14
5.Go to your chosen template sheet(s) and replace/modify sample data with your information.
15
6.Create your placemarks on the "PlacemarkDATA" sheet (erase sample data first)
16
7.To see changes: "Republish" the spreadsheet and refresh the network link in Google Earth
17
18
Editing Rules:
19
ONLY edit white cells!
20
When editing, deleting, cutting, copy or pasting cells, make sure that you ONLY make changes in the white cells.
21
22
Detailed Instructions & Videos:
23
Control-click this cell to see the tutorial for this spreadsheet.
24
Control-click to see a 5 min video demo of how this spreadsheet works.
25
26
Basic Information
27
28
Author's Information:This info is embedded into your KML and helps search engines index your KML layer.
29
Name/OrganizationLibrary Day in the Life, Round 8Your organization name or the author's name
30
Website URL:http://librarydayinthelife.pbworks.com/w/page/48173078/Round%208%2C%20January%2030th%20through%20February%205th%202012URL/Link to your organization's website.
31
32
33
About your KML Document:
34
Name:#libday8Name of the top-level folder for this KML (short & sweet).
35
Snippet: (optional)Short blurb under project name in 'My Places' (optional). Plain Text only.
36
Description:Library Day in the Life, Round 8Short description of your project (recommended). HTML OK.
37
On by default?Yes(Yes/ No): Should all placemarks be visible when loaded?
38
Open by default?Yes(Yes / No): Should top-level folder be open/expanded when loaded?
39
40
41
Google Maps Compatibility
42
Compatible with Maps and old versions of Earth?Yes(Yes / No)
43
- If yes: your placemarks will work in Maps & all version of Google Earth (3.0 - current), but will make a larger KML file.
- If no: Will make a much smaller KML that will work in Earth 4.2+ only. Warning messages are given to Google Maps and older versions of Google Earth.
- You can customize these messages in the "Advanced/Optional Settings" below.
44
45
Advanced / Optional Settings:
68
<< To access advanced/optional settings, unhide rows 46 - 67.
69
70
71
Publish and View
72
73
Publish spreadsheet:
74
1.In the "File" menu (upper left), choose "Publish to the web". Click "Start Publishing" (or "Republish Now"), and copy the link to the published data.
75
2.Paste published URL here:https://docs.google.com/spreadsheet/pub?key=0AndilCNIaDr8dGZMT1dCYUc0MmExR29GOUUyTGxVQ3c&output=html
76
e.g.,http://docs.google.com/spreadsheet/pub?key=abcdefghijklmnopqrstuvwxyz
77
78
79
View Placemarks in Google Earth:
80
3.Copy this
Network Link KML:
<NetworkLink><atom:author><atom:name>Library Day in the Life, Round 8</atom:name></atom:author><atom:link href="http://librarydayinthelife.pbworks.com/w/page/48173078/Round%208%2C%20January%2030th%20through%20February%205th%202012" /><atom:generator url="https://docs.google.com/spreadsheet/pub?key=0AndilCNIaDr8dGZMT1dCYUc0MmExR29GOUUyTGxVQ3c&amp;output=html&amp;output=txt&amp;gid=1&amp;range=kml_output" version="">Google Earth Outreach - Spreadsheet Mapper 2.0 - http://earth.google.com/outreach/tutorial_mapper.html</atom:generator><name><![CDATA[Link to - <a href='https://docs.google.com/spreadsheet/ccc?key=0AndilCNIaDr8dGZMT1dCYUc0MmExR29GOUUyTGxVQ3c'>Spreadsheet</a>]]></name><open>1</open><flyToView>1</flyToView><Link><href>https://docs.google.com/spreadsheet/pub?key=0AndilCNIaDr8dGZMT1dCYUc0MmExR29GOUUyTGxVQ3c&amp;output=txt&amp;gid=0&amp;range=kml_output</href></Link></NetworkLink>single click to select, then copy
(don't double click to edit the cell's formula)
81
4.Select "My Places" in the "Places" panel of Google Earth and paste the Network Link KML from above.
Sample placemarks will load from this spreadsheet under the folder "#libday8".
Choose which balloon template(s) you want to use, or create your own by modifying the "Template 1-6" sheets.
82
83
84
View Placemarks in Google Maps:
85
Link to Google MapsControl-Click this cell 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 will timeout.
86
87
88
89
Create Placemarks
90
1.Go to your chosen template(s) sheet(s), and enter your own information under the "static" variable section. Optionally, edit the "style" variable section.
91
2.Go to the "PlacemarkData" sheet. Give each placemark a name, location, and specify the number of the template it should use.
92
3.Enter each piece of balloon information in the appropriate columns, according to which template that placemark is using.
Enter a template number into cell H10 on the "PlacemarkData" sheet to get a column header guide for that template.
93
94
95
96
Re-publish & Refresh to view changes
97
If you edit your data or change the spreadsheet, follow the steps below to view the changes in Google Earth:
98
1.Go to the "Share" button above, choose "Publish as a web page" and click the "Re-publish document" button.
99
2.In Google Earth, right-click on the Network Link (named "Link to - Spreadsheet) 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.
100
101
102
103
Save/export your placemark data:
104
View/Save placemark dataControl-click to view your placemark dataThis 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
105
106
Export this data to another spreadsheet
=importData("https://docs.google.com/spreadsheet/pub?key=0AndilCNIaDr8dGZMT1dCYUc0MmExR29GOUUyTGxVQ3c&output=html&output=csv&gid=2&range=data_dump")
107
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 placemark cells that were populated with your data (C11:AY...), and copy them.
5. Click the paste button in the toolbar (left of the 'Format' button). Choose "Paste values only".
108
109
110
111
Debugging your KML:
112
KML Debugging Link:Control-click this cell to view KMLDisplays the raw KML file created by this spreadsheet.
113
114
hidden column for developers only (unhide at top) >><<