Extract Coordinates (Lat/Long) from Google Earth Pro | then export to UTM

This video is about extracting coordinates from Google Earth Pro software to Excel. In this video I have extracted lat long data of a polygon drawn in Google earth to excel.
I have shown step by step method to extract the coordinates in batch.
After extracting the lat long coordinates I have then converted this lat long data to
UTM coordinate also by using QGIS Software.
This video tutorial is very helpful in GIS Field.
I have taken West Bengal Survey Institute to show the example of the method.
I have used these software in this overall tutorial:
1. Google Earth Pro
2. Notepad
3. Microsoft Excel
4. QGIS
These are tho following steps I have shown in this video to extract lat long
coordinates:
Step 1: Draw a Polyline in Google Erath Pro by "Add Path" option
Step 2: Save the Path as KML : (Right click-- SavePlaceAs)
Step 3: Open the KML file by openwith Notepad
Step 4: Copy all the text in Notepad and paste to Excel
Step 5: Copy the coordinate section
Step 6: Process the data in excel -watch the video
Step 7: Filter the data
Step 8: after getting lat long save the data as CSV
Step 9: Add Delimited Layer in QGIS
Step 10: Save as UTM
Step 11: Your data is succesfully exported - (congratulations!)
Thank you for watching.
Keep supporting us
Don't forget to SUBSCRIBE us!
Learn & Explore Team

[@LearnExplore]

Download GoogleEarthPractice zip folder Download Link: goo.gl/U4PFtP Practice this method and tell me in comments :) and Don't forget to SUBSCRIBE :) (Its Free)

[@Meenaghak]

I tried using Wordpad instead of Notepad and it worked very well. I was actually having challenges with the Notepad due to the horizontal arrangement of the coordinates which is contrary to the Wordpad.

[@LearnExplore]

Nice

[@prativadas4794]

Thank you for sharing this great info. Keep up with your good work

[@RamTheArcher]

this is ravikant few day ago i called you and you are helping me alot sir thankyiu sir

[@LearnExplore]

Thanks. All the best

[@aliyarmohamedriza1880]

Thank you very much your vedieo help my final year project work

[@LearnExplore]

You are welcome

[@snehasneha5892]

What a talent ....

[@pengamatpengairankediri6585]

thank you, this is very helpful

[@ajibola294]

Hello, learn & explore. Your videos have been helpful for me as young surveyor as I've picked many useful lessons from them. Meanwhile, I'd like you to know that some parts of some videos are antiquated and they need a newfangled one. for example, they used a GEarthView plugin in this video and its no longer in use. Pls give us new videos for learning.. God bless you.

[@LearnExplore]

Thank you for the valuable feedback. We will definitely look into this.

[@hrishikeshsardar4549]

I Passed Diploma Degree in GIS & GPS From recognised institute.. West Bengal Survey Institute

[@LearnExplore]

Vai ami oi college er e pass out

[@hrishikeshsardar4549]

@@LearnExplore kon year Passout.....? Kon Stream Chilo.....?

[@LearnExplore]

Survey 2014

[@hrishikeshsardar4549]

@@LearnExplore achha..... Ami GIS & GPS 2020...

[@jacktonemomanyi8574]

Thanks a lot your video was helpful

[@joyshreemondal7232]

Very good..👍

[@rogercharlie]

Darun dada darun

[@gameromg5312]

What if these coordinates not corresponding to these from Google earth when transferring them to qgis?where is a problem then as I follow everything step?

[@LearnExplore]

No problem. You can also convert the other coordinates too. While exporting please select geometry as x,y in the export page

[@claudiahintz5631]

@@LearnExplore what? I'm having this problem to and this doesn't make much sense?

[@SuperThracian]

Hi there, thank you for the great video. There is though a problem when I remove the 0 values; unfortunately the 0 digits inside numbers are removed as well. Thus, if in a cell the value 0 108.15 is included, your method removes not only the 'leading' 0 but also the 0 digit in 108.15, and consequently is transformed to 18.15. Any solutions to this problem?

[@LearnExplore]

I will look into this. Thanks for your patience.

[@LearnExplore]

Use "0 " during replace Not only "0" There is a space after 0 Watch the video carefully

[@SuperThracian]

@@LearnExplore Many, many thanks!

[@LearnExplore]

You are welcome 😊

[@donkumarsarme5228]

grt..keep it up..

[@ashutoshsharma3189]

Texts were not imported to QGIS. Why? Is there any method to import texts along with points. pls guide.

[@LearnExplore]

Yes there is a way. But need some complex method. I will upload a separate video on this

[@lukaskramer6079]

Thank you that was a big help ! I ran into a problem though, with me it also exported the altitude as well and it does not separate from the longitude, and I've got around 500 values. Is there a way to get rid of them without doing it manually ?

[@LearnExplore]

Use Text to Column option in excel. That could be helpful for u

[@asidmahmood2881]

Hi I have two picture saved on in my email address these of ocean but have do I add latitude and longtiude to themthankyou

[@naseeryounasbhatti1077]

sir, google earth Icon b QGIS mn show ni ho raha isk liye kiya procedure hai.?

[@dewakaracharya6551]

sir it is possible to convert the data obtained in latitude from google earth which uses WGS as datum to Everest speriod

[@koushikbanerjee4783]

Thank you very much for the video, I have taken point wise170 lat long values for my area, simultaneously I have also shape file of that particular area, when I am exporting the lat long value and shape file in QGIS environment, these points and shape file are not overlaying exactly, what to do ,,, pls help me

[@LearnExplore]

May be some projection error. You can connect me through Anydesk. I will guide you

[@tamuniachkhapelia9068]

BRAVO!!!!!!! THANK YOU

[@MrMka19]

I can't find Gearth view. I'm using 3.4.1 version. please help.

[@naseeryounasbhatti1077]

sir, note pad mn jb file open hoti hai tu us mn Coordinate Northing easting ki bijaye decimal mn show ho rahy hn jb k mn ne google earth mn utm e select kiya huwa hai tu is problem ko kaisy solve karun please rply.?

[@usmanrafi3244]

Hello. Question # 1.there any way to get contours from Google earth and paste into autocad. Question # 2. Is there any to plot two or more points in Google earth and get x y z coordinates for all the intermediate points.??

[@LearnExplore]

For your both question we need Z values for which There is a google altitude api for altitude extraction which is paid. You can search in google "google altitude api"

[@gah-mutisalvanusyevalla5296]

Insteresting video

[@dipankarpal6091]

How we convert utm coordinate to decimal please a video.

[@03blackoperandi]

When I opened .CSV on QGIS, it became "PTID Lat Long" as one column, so I can't process it further. Any help would be apreciated..Thanks :)

[@LearnExplore]

In qgis import dialogue box Use delimited as tab, comma, space etc respective of your data.... Otherwise choose auto detect

[@03blackoperandi]

@@LearnExplore Okay, it's now working thank you :)

[@03blackoperandi]

Sorry for asking again, since I'm new on QGIS. After successfully referencing using nodes, what I want to do is putting both raster image from google map (jpeg) and a vector image from autocad (dwg). But now I'm stuck on how to resize and positioning the raster image correctly. Importing autocad files also didn't work yet...

[@LearnExplore]

No need to import google nap jpeg image. Instead of that you can directly overlay google map satellite online map in QGIS. For this do this method as described here kzbin.info/www/bejne/bGi9o6iCoayXgNU And if you have an autocad drawing with real coordinates then save as it as .dxf file format and then import in QGIS using vector data inport. For this watch this video kzbin.info/www/bejne/qprWYWyJmZJno7c If any problem always feel free to ask me anytime.

[@khanmustak1368]

good morning sir pls,,,, help me..,, mujhe malum karna hai ki ek autocad drawing me coordinates x,y bana liya or computer ki window par Excel me save kiya ab ky kru kitotal station ke memory card me data dalna hai to konsa format usb kru ya ky kru bata na pls

[@LearnExplore]

Hi pehle Total Station ko aap ka computer ke saath connect karna he USB or Bluetooth ke madhyam me. Uske baad aap import or export kar sakte he. I think insert karne ke liye apko x,y data ko PtID,Easting,Northing ayse format me arrange karna he uske baad usko *.csv format me save karna he. Total station me kaise data import or download karte he uske baare me me baad me ek vidio banaunga Dhannyabad

[@mdabdullahalmamun6635]

Dear Sir, plases countor volume video create by autolips.

[@rehmanmehar9405]

Can you make a vedio on how to convert google earth coordinates into autocad

[@LearnExplore]

For this please watch lat long to utm

[@LearnExplore]

Then watch how to import xyz coordinate from excel to AutoCAD

[@mesfinhailegiorgis7985]

wonderful

[@atulabhishek9817]

How can we get coordinates for every point on the path

[@LearnExplore]

Watch the video without any skip.

[@sourabhsuresh6578]

thank you so much

[@LearnExplore]

Thank You for your valuable feedback 😊

[@tariqmalik6747]

dear sir after showing pionts on screen,,how we see on google earth.

[@LearnExplore]

Save the file as csv format (Sl No,lat,long) then import the file to Google Earth

[@tariqmalik6747]

@@LearnExplore ALL POINTS SHOWEN ON SCREEN AFTER IN QGIS,THEN HOW WE CAN SEE THE SAME AREA OR NOT .bECAUSE I DONOT HAVE GOOGLE EARTH VIWER,

[@tariqmalik6747]

ALREADY SAVED IN EXCLE ALL DATA BUT THE PROBLEM

[@donkumarsarme5228]

keep it up

[@skahmedali5797]

How to convert utm cordinator to zone area

[@LearnExplore]

I don't understand ur question

[@destahailu5403]

hello, How about the altitudes?

[@LearnExplore]

You need paid application for that.

[@ksthar5631]

use TCX converter

[@martontapas1283]

Please can u send me all files of these tutorials? I am a GIS Technician and i wish to learn from you

[@LearnExplore]

Already link given in pinned comment section

[@martontapas1283]

@@LearnExplore thank you sir. I truly love those videos. Very helpful

[@martontapas1283]

@@LearnExplore Can you help me convert Non Earth Coordinates to UTM Coordinates? I am using MapInfo and I came across something like this and i hope you can do a video tutorial.

[@LearnExplore]

We have video for this kzbin.info/www/bejne/i4PTeZeNhZmeiZI

[@LearnExplore]

You are welcome and thank you for your valuable feedback

[@tariqmalik6747]

i mean on gearth view

[@getachewabeje2276]

Thanks

[@maanpal1190]

Plz extract with value also

[@LearnExplore]

Which value?

[@maanpal1190]

Z value

[@claudiahintz5631]

This doesn't work!!! just wasted 2 hours slowly following and redoing, with no success, outdated video, needs to be removed

[@LearnExplore]

Yes it is outdated, there are other methods which can be used. But it doesn't mean that what I have shown is wrong. Try it, it will definitely work

[@1rl574]

Bro can i ask your email? I need to ask something,.

[@LearnExplore]

Sure. Please mail us at [e-mail]

[@LearnExplore]

Whatsapp [phone]