Converting KML files to CSV or TXT

18,629 views
Skip to first unread message

vanser

unread,
Oct 31, 2006, 11:58:04 AM10/31/06
to KML Discussions
Hi,

Is there a program that would allow me to convert my KML file with locations in to a CSV or TXT file?

Thanks,

vanser

vanser

unread,
Oct 31, 2006, 2:14:48 PM10/31/06
to KML Discussions
Help Please.... Is there such a tool and if so where could I find it.

Thank You !!!!

ManoM

unread,
Oct 31, 2006, 2:18:28 PM10/31/06
to KML Discussions
Hi vanser,

One disclaimer: I haven't used any conversion utilities, so I can't guaruntee results. However, this thread has some good tips on file conversions, as does this thread.

ManoM

ManoM

unread,
Oct 31, 2006, 2:35:50 PM10/31/06
to KML Discussions
Also, vanser, if you have trouble finding something specifically that works for you, KML is XML, so any XML tools for converting to CSV, such as an XSLT stylesheet, would work for you.

ManoM

simon_a

unread,
Oct 31, 2006, 3:08:33 PM10/31/06
to KML Discussions
Hello,

KML (not KMZ) is text, so you don't need any conversion to that extent (try opening a KML file with a text editor).

As for CSV, you can use MS Excel if you have a reasonably recent version of it that will import XML files.

As ManoM said, KML is a type of XML; simply save as a KML (not KMZ) file, rename the file from ".kml" to ".xml" and then open it with Excel, which will convert it into a spreadsheet for you. Of course, you can then save as a CSV file if you want.



Cheers,

Simon.

vanser

unread,
Oct 31, 2006, 4:22:05 PM10/31/06
to KML Discussions
Thank you !

barryhunter

unread,
Oct 31, 2006, 5:49:59 PM10/31/06
to KML Discussions
Quote:

simply save as a KML (not KMZ) file, rename the file from ".kml" to ".xml" and then open it with Excel, which will convert it into a spreadsheet for you.




Never knew that, great tip thanks!
Reply all
Reply to author
Forward
0 new messages