Konversi koordinat google Earth ke Excel

Upload your KMZ File and Convert

Drag & Drop files here...

Table of Contents Show

Upload your KMZ File and Convert
Conversion from KMZ to XLSX
About MyGeodata Converter
Supported coordinate reference systems
Conversion from XLS to KML

Please note that your data will not be shared to anybody unless you do it yourself.

Conversion from KMZ to XLSX

Upload your KMZ data (widely used in software like Google Earth and GPS devices) and convert them by one click to XLSX format (widely used in software like MS Excel).

Notice to XLSX format - In case your data are POINT type, then XY coordinates will be exported as well.

About MyGeodata Converter

Our online converter of Keyhole Markup Language Zipped format to Microsoft Excel format (KMZ to XLSX) is fast and easy to use tool for both individual and batch conversions. Converter also supports more than 90 others vector and rasters GIS/CAD formats and more than 3 000 coordinate reference systems. If the coordinate system of your input data is not present or not recognized correctly, it is possible to assign the correct one. Then it is possible to transform your data to any other coordinate reference system.

Files can be uploaded using multiple selections or packed into any supported format (ZIP, RAR, 7Z, TAR, GZIP). If the input format is directory-based, it is necessary to pack whole directory - not only the content.

To avoid considerable servers loads we had to set conversions limits for each user - please see Free plan. If you exceeded the limit, you may register a prepaid plan - otherwise you will be charged by credit card during the conversion process (one-off payment). Your charges allow us to cover costs associated with the servers operation and to improve our service.

Supported coordinate reference systems

MyGeodata Converter supports more than 3 000 coordinate systems - including:

WGS 84
ETRS89 / LAEA Europe
ETRS89 / UTM zone 30N (N-E)
ETRS89 / UTM zone 29N
MGI / Austria Lambert
GDA94 / MGA zone 54
GDA94 / MGA zone 55
RGF93 / Lambert-93

WGS 84 / UTM zone ...
ED50 / TM27
Amersfoort / RD New
Pulkovo 1942 / Gauss-Kruger
S-JTSK / Krovak
NAD27
NAD83

Pseudo-Mercator, Spherical Mercator, Google Maps, OpenStreetMap, Bing
OSGB 1936 / British National Grid - United Kingdom Ordnance Survey
... and 3 000+ other coordinate reference systems

Conversion from XLS to KML

Upload your XLS data (widely used in software like MS Excel) and convert them by one click to KML format (widely used in software like Google Earth, Fusion Tables, Maps and GPS devices).

Notice to XLS format - Detection of columns containing coordinates is based on attribute name - please rename columns containing coordinates to any of these: x, xcoord, xcoordinate, coordx, coordinatex, longitude, long (and of course: y, ycoord, ycoordinate, coordy, coordinatey, latitude, lat). If you have geometry as WKT or WKB, use wkt or wkt name for the geometry column name.

Notice to KML format - KML converter strictly transforms input dataset to WGS 84 coordinate reference system (if needed). Please make sure that coordinate reference system of your input dataset is assigned correctly - otherwise the resulting KML file may be spatially shifted or wrong.

Posting kali ini akan diuraikan cara mengeplot koordinat UTM ke dalam program google earth melalui file kml menggunakan program Microsoft Excel.

Program Microsoft Excel digunakan untuk merubah file koordinat UTM ke koordinat Lintang, Bujur kemudian berdasarkan koordinat Lintang, Bujur tersebut dibuatkan file KML yang dapat dibuka dengan program Google Earth.

Sebagai panduan langkah-langkah di bawah, silakan download file terlebih dahulu.

Contoh list koordinat UTM yang akan diplot:

Berikut adalah tahapan-tahapan yang saya lakukan:

1. Konversi Koordinat UTM ke Koordinat Geografis (Lintang, Bujur).

Rumus untuk merubah koordinat UTM ke Koordinat Geografis, menggunakan rumus yang telah diuraikan dalam [XLS-MAP-09]:Speadsheet Proyeksi Traverse Mercator di Excel (Versi #2).

Konversi atau proyeksi UTM ke Koordinat Geografis dengan asumsi menggunakan Ellipsoid Reference WGS 84, maka pada sheet [Parameters] dilakukan setting sebagai berikut:

[C2]	Pilih WGS 84	Parameter a dan 1/f akan otomatis terisi
[C6]	Pilih UTM	Parameter proyeksi UTM akan terisi sendiri
[C14]		Masukkan koordinat Bujur pendekatan
[C15]		Masukkan koordinat Lintang pendekatan. Masukkan nilai negatif jika terletak di lintang selatan (South)

Setelah dilakukan setting parameter proyeksi, pindah ke sheet [Grid2Geo] untuk selanjutnya dilakukan proses proyeksi/konversi koordinat:

[A:C]		Masukkan koordinat UTM dengan urutan Nama Titik, East (X), North(Y)

[D8]	=lat	menghitung nilai Koordinat Lintang dalam satuan desimal
[E8]	=lg	menghitung Koordinat Bujur dalam satuan desimal
[F8]	=gConv	menghitung konvergensi grid dalam satuan desimal
[G8]	=pntScale	menghitung faktor skala titik

		copy rumus di [D8:G8] ke bawah sampai ke titik terakhir yang akan dihitung

2. Setting XML untuk plotting koordinat dalam bentuk titik.

Pindah ke sheet [point(xml)] untuk membuat file kml dam bentuk titik.

KML generator di atas akan membuat kumpulan titik dalam folder yang didefinisikan dalam cell [C4], nama titik dan koordinatnya dimulai dari cell [C6] dan cells [E6] sampai titik yang diinginkan. Cells yang berwarna kuning adalah cells yang berisi rumus atau formula dengan menggunakan referensi [Grid2Geo].

Rumus yang disgunakan dalam worksheet [point(xml)]:

[C4]		Masukkan nama group atau folder titik
[C6]	=Grid2Geo!A8	mengambil point desc dari sheet [Grid2Geo] sebagai nama placemark
[E6]	=TEXT(Grid2Geo!E8,"0."&REPT("0","14"))&","&TEXT(Grid2Geo!D8,"0."&REPT("0","14"))&","&TEXT(list!D2,"0.00")	memformat koordinat Bujur, Lintang dari sheet [Grid2Geo] dalam unit desimal dengan format 14 digit desimal
[G6]	=B6&C6&D6&E6&F6	Menggabungkan text di kolom B, c d e dan F

		copy rumus di [A6:G6] sampai ke titik terakhir di sheet [Grid2Geo]
[G19]	</Folder>	jangan lupa akhiri dengan text </Folder>