NameLatLon2KML

NameLatLon2KML is a simple and fast tool to plot your list of names, latitudes and longitudes in Google Earth.

Example data:

Name	Latitude	Longitude
----	--------	---------
STA01	42.46778	0.71306
SMV01	42.48611	0.71583
TIN01	42.49111	0.72472
ART01	42.54833	0.76028
ART02	42.54750	0.75972
BLL03	42.56000	0.71917
RLH01	42.59806	0.76333
IST01	42.61250	0.76556
IST02	42.61250	0.76528
HOS03	42.62556	0.76528
MUL01	42.63000	0.74611
MUL04	42.62972	0.74500
OPN01	42.63639	0.74000
OPN02	42.63639	0.74056
OPN03	42.63639	0.74083
IPN01	42.64028	0.73861
IPN02	42.64028	0.73833
OBS01	42.60444	0.78639
BES01	42.60417	0.80611
LDB01	42.60528	0.82222
LDB03	42.60528	0.82250

This script works in Linux. You need to have Google Earth (or any other program that reads kml files) and xsel (for the script to read the clipboard) installed.

Just open your spreadsheet, copy the Name-Lat-Lon columns and run the script. Google Earth will magically open and plot the sites.

Site names should not contain any space.

NameLatLon2KML can be downloaded from here.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

<span>%d</span> bloggers like this: