Export Coordinates from Google Earth to Excel

Рет қаралды 105,049

Күн бұрын

In this video, I will Show you, How to Export Coordinates from Google Earth to Excel.
This video is about extracting coordinates from Google Earth to Microsoft Excel. I have extracted lat long data of Point, Polyline and Polygon drawn in Google Earth to Microsoft Excel.
I have shown step by step method to extract the coordinates in batch.
This video tutorial is very helpful in GIS Field.
I have used these software in this overall tutorial:
1. Google Earth Pro or Google Earth
2. Microsoft Excel
============================
Share, Support, Subscribe!!!
#spatialpost
Website: www.spatialpost.com
Facebook: / spatialpost
Twitter: @spatialpost / spatialpost
Pinterest: / spatialpost
Instagram: / thespatialpost
Google Plus: plus.google.com/1050612104195...
KZfaq Channel: / @spatialpost
Follow and Subscribe SpatialPost KZfaq channel for more GIS related Howto’s and walkthrough.
=============================
PLEASE HIT LIKE BUTTON!!!!!
SHARE WITH YOUR FRIENDS AND IN SOCIAL MEDIA!!!!!!
DON'T FORGET TO SUBSCRIBE THE CHANNEL!!!!!!
=============================
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.
=============================
#gis #geo #map #geospatial #mapping #geographicinformationsystems #geography #spatial #GoogleEarth

Пікірлер: 43

@wenukabandara6164 3 жыл бұрын

Simple, yet elegant. Thank you.

@hermannvalsson4237 4 жыл бұрын

Great Video, I learned a lot of thanks and regards from Reykjavik Iceland.

@ekipusamuel5228 4 ай бұрын

thank for the guidance.... God bless you

@thebible3663 7 ай бұрын

Thank you, Very important and interesting.

@bredleemurray904 Жыл бұрын

Thank you. It's helpful.

@ganiwahdi4085 3 жыл бұрын

Thanks for your information tutorial

@eliasbaez6923 3 жыл бұрын

Excellent, Thank you

@athlete265 4 жыл бұрын

Really helpfull thanks

@kaviyanmuhilan 3 жыл бұрын

Thanks a lot... great video for me to have a idea about this

@icas12 2 жыл бұрын

Thank you bro. You make great job.

@akshayp3879 2 жыл бұрын

Many thanks! I saved marking as .kmz as I couldn't save it as .kml and converted it to .xlsx, got x and y coordinates seperately.

@sayedalihashemi8779 Жыл бұрын

very good and useful, thank you

@nsphaiti3837 2 жыл бұрын

Very useful!

@yax309 2 жыл бұрын

Good lecture so far

@tamilarcgisuniversity 2 жыл бұрын

Your video is amazing....

@prajwalparmar4168 9 ай бұрын

This is great

@naelatieh9143 4 жыл бұрын

Thanks for the video. I faced a problem when I was trying to open a Placemarks via excel since excel is not an option when i use (open with), it gave me a lot of option like even Microsoft word but not excel, what should I do to add excel as an option?

@mohammadaasifkhaja1892 Жыл бұрын

superb

@The_Engineer Жыл бұрын

Helpful tip, when doing txt to columns, delimit by a space using the “other” as well as the commas… then the zeros will be put into separate columns!

@범곡리 10 ай бұрын

Thank you. There was an error in changing the search It goes smoothly because I check commas, guitar, and spaces

@maryghillianesantos1201 4 жыл бұрын

Thanks a lot for this. What a great help. 😍

@lunababy8027 3 жыл бұрын

Happy

@lunababy8027 3 жыл бұрын

Happy

@manasranjansahoo9613 4 жыл бұрын

Thanks. Really helpful. Can we copy the co-ordinates from SpatialNet?

@teketelanshebo632 2 жыл бұрын

Thank you for your interesting teaching. How can I extract coordinates from a given path at certain interval ? Let us say the road is 5km but if I want to extract the coordinate at 15m interval through the route.

@borpit087 Жыл бұрын

❤

@LawrenceJohmann Жыл бұрын

It ought to be mentioned that a single cell of Excel has a 32k character limitation. A polyline with many, many vertices may be defined by more characters than Excel will store in one cell. Consequently, the results of the method shown may contain fewer coordinates than defined by the kml file.

@utubemania9079 4 жыл бұрын

Please make a video how to use these coordinates in qgis to make a map.

@salgadoxx 3 жыл бұрын

this only seems to work for placemarks that were manually placed, what about for larger lists that were imported into GIS using address geocoding without coordinate data?

@amyyates7761 3 жыл бұрын

Is there a way to export to the UTM (Universal Transverse Mercator) format instead?

@rapidtriptv3778 3 жыл бұрын

it seems for me it works different. I did the process of what the video shows but the it has come out with an "error" result. XML parse error. Please help me, what should i do?

@wickedhate2006 4 жыл бұрын

why does mine say this app cant run on your pc

@israrahmed1641 3 жыл бұрын

"This app can't run on your PC" this error is pop up please guide me regarding the export of coordinates from Google earth Pro to MS excel.

@prasannalakshmi5560 2 жыл бұрын

open with microsoft excel option is not coming in my laptop,please give advice on this issue

@mohamednur2797 4 жыл бұрын

very useful, but your excel sheet is out of focus.very difficult to follow where your curser is aiming.Thanks

@nghiatrinh8753 3 жыл бұрын

My computer had a problem where it was unable to export the Kml file of the pathway, which I just plotted on Google Earth, to Excel. It didn't show the data. Please help

@k11vin 2 жыл бұрын

you need to save the klm file then convert it to gpx file to add elevation data and then export to excel as a csv file.