Google Earth Community: KML from Google spreadsheets. Revolution?

1. Read manual by Gerardo64 (thanks!)
http://bbs.keyhole.com/ubb/showthreaded.php/Cat/0/Number/550183
See Editgrid solution.

2. Prepare need dataset in spreadsheets and assembly all KML file in cell A1.
I use Cell A1 as standard for fast change of datasets.

3. Publish current spreadsheets and see link.
We see near http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw

4. Create Network link, open Properties by right click and insert into field Link generated string
( for path calculator it is http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw )

5. Add to string "&output=txt&range=a1"
a1 it is cell with generated KML file

6. Check the network Link, add need description and public this. Enjoy.

7. Open http://www.google.com/maps and insert into field Search Maps string Link from Network Link. Press Enter and see results.

8. Press "Link to this page" and see http link. Copy result from http string to need place. Press link and check results. Enjoy two

9. Add source "published" link or place embed spreadsheets in a web page.

10. Check and clean my bad English, prepare best manual, public in BBS.

Thanks.

PS: Generation KML from Google spreadsheets is very fast!
Nice!

--------------------
Applications | Blog | Geoblog(ru) | Spreadsheets | Photos | Pict'Earth | Eastgeology (ru)

Post Extras