For Geeks @nd the not so Geeky

KML to XLSX – Convert KML file ns1:coordinates

HiRes

Convert KML ns1:coordinates to XML – KML to XLSX

Adapted from http://www.slideshare.net/RazaNajam2/importing-latlongs-from-googleearthkml-in-excel

Latitude and Longitude Formats

  • Decimal degrees (DDD): 40.446° N 79.982° W
  • Degrees and decimal minutes (DMM): 40° 26.767′ N 79° 58.933′ W
  • Degrees, minutes and seconds (DMS): 40° 26′ 46″ N 79° 58′ 56″ W

Belgian Lambert 1972

Based on the initial point being the Brussels Observatory (Uccle Royal
Observatory), using the Hayford Ellipsoid.

Lambert 2008 was constructed to be compatible with the WGS84 satellite positioning system.

For conversion from WGS84 check http://zoologie.umh.ac.be/tc/default.aspx

Sources:

 

KML to XLSX – Bulk Conversion

RIGHT CLICK AND SELECT “Save place as”

SELECT KML IN “save as type”

RENAME “.kml” FILE EXTENSION TO “.xml”

OPEN THE FILE IN MS EXCEL,

CLICK OK/YES IF ANY PROMPTS APPEAR

HIGHLIGHT THE WHOLE RIGHT COLUMN “ns1:coordinates”

GO TO “Data” TAB THEN SELECT “Text to columns”

CLICK NEXT.

SELECT “comma” AND UNSELECT “tab” CLICK NEXT AND FINISH

 

Convert to Belgian Lambert

http://zoologie.umh.ac.be/tc/default.aspx

 

 

 

 

 

 

 

Leave a Response