|Spreadsheet Mapper v3.2||click here for a fresh copy of the latest spreadsheet mapper|
|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||From the Spreadsheet Mapper menu, select "about spreadsheet mapper", and authorize the scripts to run in your account.|
|3||Rename this spreadsheet with an appropriate name (File menu > Rename).|
|4||Complete the "Basic Information" section below.|
|5||Follow the steps in the "Publish and View" section to publish your spreadsheet to the web and 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||Period survey team at Science Hack Day Berlin 2016||Your organization name or the author's name|
|Website URL:||https://gitter.im/Period-survey-SHDB16/Lobby||URL/Link to your organization's website.|
|About your KML Document:|
|Name:||Period survey results – awareness||Name of the top-level folder for this KML (short & sweet).|
|Snippet: (optional)||Short blurb under project name in 'My Places' (optional). Plain Text only.|
|Description:||Map of survey takers, pin color determines how comfortable they are with the subject menstruation||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:
|<NetworkLink><atom:author><atom:name>Period survey team at Science Hack Day Berlin 2016</atom:name></atom:author><atom:link href="https://gitter.im/Period-survey-SHDB16/Lobby" rel="related" /><atom:generator uri="http://www.google.com/earth/outreach/tutorials/spreadsheet3.html" version="3.2">Google Earth Outreach - Spreadsheet Mapper 3.0</atom:generator><name><![CDATA[Period survey results – awareness]]></name><snippet></snippet><description><![CDATA[Map of survey takers, pin color determines how comfortable they are with the subject menstruation]]></description><open>1</open><flyToView>1</flyToView><Link><href>https://docs.google.com/spreadsheets/d/1_NyvKbKKFSCMzevqYg8IdZ0JF6UhhDiwYjEngJX32-4/pub?single=true&gid=0&output=tsv</href></Link></NetworkLink>||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 "Period survey results – awareness".
|View Placemarks in Google Maps:|
|6||Link to Google Maps||The Google Maps site no longer supports KML display.||NOTE: KML still works with the Google Maps API.|
|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||=importData("https://docs.google.com/spreadsheets/d/1_NyvKbKKFSCMzevqYg8IdZ0JF6UhhDiwYjEngJX32-4/edit&gid=2&range=data_dump&output=csv")|
|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) >>||<<|