Converting Earthrover marker CSV files to KML

 

Earthrover map applications allow you to export your markers in CSV format via email.  Below are instructions for converting the CSV files to KML format for use in Google Earth or Google Maps.


System requirements: You’ll need a computer with perl installed (which it should be by default for Unix or Mac systems, often in /usr/bin/perl).


Instructions:

  1. 1.On your iPod or iPhone, export your markers from AFCTrailMap or another map application using the “Mail...” button on the Marker screen.  Enter your email address when the Mail app launches, and send the message.

  2. 2.Download the csv2kml.pl perl script.  (We’ll assume you’ve saved it in your home directory in this example.)

  3. 3.Open your email, and save the message to a file (markers.csv in your home directory, in this example).  You can also cut-and-paste the message to a new text file.  Don’t worry about stripping out the email headers, your signature, or other text--they’ll be ignored by csv2kml.pl.

  4. 4.Open a terminal window and type:  

  5.  

  6. /usr/bin/perl ~/csv2kml.pl ~/markers.csv


  1. This will create a file named markers.kml. If you’ve saved the script or CSV file to different places, substitute the appropriate paths and/or filenames. 


  3. 5.Open Google Earth, and select File->Open... and then select markers.kml.  The placemarks will appear in a folder called “My Markers” under the “Temporary places” folder.